我想做两个准备好的语句,一个在PHP中使用MysqLi一个接一个.我是PHP和MysqLi的新手所以我不知道是否应该关闭语句,关闭数据库连接,将所有代码放在函数中,或者只是让代码不在函数内部.
基本上我只想在一个表中插入一条记录,然后使用MysqLi将同一条记录插入另一个表中.
谢谢！
最佳答案
直接关闭MysqLi页面：http://php.net/manual/en/mysqli.commit.php
PHP
$MysqLi = new MysqLi("localhost","my_user","my_password","world");
/* check connection */
if (MysqLi_connect_errno()) {
printf("Connect Failed: %s\n",MysqLi_connect_error());
exit();
}
/* set autocommit to off */
$MysqLi->autocommit(FALSE);
/* Insert some values */
$MysqLi->query("INSERT INTO table1 VALUES ('DEU','Bavarian','F',11.2)");
$MysqLi->query("INSERT INTO table2 VALUES ('DEU',11.2)");
/* commit transaction */
$MysqLi->commit();
/* close connection */
$MysqLi->close();
*编辑准备好的“非理智”行动声明：
PHP
$MysqLi = new MysqLi("localhost","root","","");
/* check connection */
if (MysqLi_connect_errno()) {
printf("Connect Failed: %s\n",MysqLi_connect_error());
exit();
}
/* set autocommit to off */
$MysqLi->autocommit(FALSE);
$stmt1 = $MysqLi->prepare("INSERT INTO tbl1 (id,intro) VALUES (?,?)");
$stmt2 = $MysqLi->prepare("INSERT INTO tbl2 (id,name) VALUES (?,?)");
$str1 = 'abc';
$str2 = 'efg';
$str3 = 'hij';
$str4 = 'klm';
$stmt1->bind_param('ss',$str1,$str2);
$stmt2->bind_param('ss',$str3,$str4);
if ($stmt1->execute() == false)
{
echo 'First query Failed: ' . $MysqLi->error;
}
$stmt1->close();
if ($stmt2->execute() == false)
{
echo 'Second query Failed: ' . $MysqLi->error;
}
$stmt2->close();
$MysqLi->close();