PHP + MySql +存储过程,如何获得访问“out”值?
问题描述:
文档严重缺乏MySQL中与PHP存储过程有关的任何事情。我目前有一个存储过程,我通过PHP调用,我怎样才能得到一个out参数的值?PHP + MySql +存储过程,如何获得访问“out”值?
答
它看起来像它的回答在这个岗位:
http://forums.mysql.com/read.php?52,198596,198717#msg-198717
随着mysqli的PHP API:
假设存储过程myproc的(IN I INT,从j个INT):
$mysqli = new mysqli( "HOST", "USR", "PWD", "DBNAME");
$ivalue=1;
$res = $mysqli->multi_query("CALL myproc($ivalue,@x);SELECT @x");
if($res) {
$results = 0;
do {
if ($result = $mysqli->store_result()) {
printf("<b>Result #%u</b>:<br/>", ++$results);
while($row = $result->fetch_row()) {
foreach($row as $cell) echo $cell, " ";
}
$result->close();
if($mysqli->more_results()) echo "<br/>";
}
} while($mysqli->next_result());
}
$mysqli->close();
答
下面是如何使用mysql,mysqli和pdo完成此操作的示例:
http://www.joeyrivera.com/2009/using-mysql-stored-procedures-with-php-mysqlmysqlipdo/