PHPi与MySQLi中的多个Prepared语句 [英] Multiple Prepared statements in PHP with MySQLi
本文介绍了PHPi与MySQLi中的多个Prepared语句的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想做两个准备好的语句,一个在MySQLi的PHP中接一个.我是PHP和MySQLi的新手,所以我不知道我应该关闭语句,关闭数据库连接,将所有代码放入函数中,还是仅将代码置于函数内.
I want to do two prepared statements, one right after the other in PHP with MySQLi. I am a novice at PHP and MySQLi so I don't know whether I should close the statement, close the database connection, put all of the code in a function, or just have code not inside a function.
基本上,我只想在一个表中插入一条记录,然后使用MySQLi将同一条记录插入到另一张表中.
Basically I just want to insert a record into one table and then insert the same record into another table using MySQLi.
谢谢!
推荐答案
Directly off the mysqli page: http://php.net/manual/en/mysqli.commit.php
<?PHP
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
$mysqli->set_charset('utf8mb4');
/* 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', 'Bavarian', 'F', 11.2)");
/* commit transaction */
$mysqli->commit();
/* close connection */
$mysqli->close();
*使用非明智"操作的准备好的语句进行
*Edit with prepared statements for "non-sane" action:
<?php
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = new mysqli("localhost", "root", "", "");
$mysqli->set_charset('utf8mb4');
/* 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);
$stmt1->execute();
$stmt2->execute();
/* commit and set autocommit to on */
$mysqli->autocommit(true);
这篇关于PHPi与MySQLi中的多个Prepared语句的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文