假设存储过程的名字是p_test()
create PROCEDURE `p_test`()
BEGIN
select 3 as 'end';
select NOW() as 'time';
END
php代码
/**
* mysqli connect
*/
$mysqli_link= mysqli_connect($db_host, $db_user, $db_password, $db_database, $db_port );
if( $mysqli_link ){
echo 'db connect ok'.PHP_EOL;
}else{
die('db connect error');
}
/**
* mysqli query
*/
$sql_select=<<call p_test();
EOF;
// Execute multi query
if (mysqli_multi_query($mysqli_link, $sql_select)) {
do {
// Store first result set
if ($result = mysqli_store_result($mysqli_link)) {
while ($row = mysqli_fetch_row($result)) {
var_dump($row);
echo PHP_EOL;
}
mysqli_free_result($mysqli_link);
}
echo '=========='.PHP_EOL;
} while (mysqli_next_result($mysqli_link));
}