Stored Procedures.
In order to call a stored procedure that returns a result set, use mysqli_real_query.
Here is a short example:
$mysqli = new mysqli(DBURI,DBUSER,DBPASS,DBNAME);
if (mysqli_connect_errno())
{
printf("Connection failed: %s\n", mysqli_connect_error());
exit();
}
$SQL = "CALL my_procedure($something)";
if (!$mysqli->real_query($SQL))
{
printf("Invalid query: %s\nWhole query: %s\n", $mysqli->error, $SQL);
exit();
}
if ($result = $mysqli->store_result())
{
while ($myrow = $result->fetch_array(MYSQLI_ASSOC))
{
$aValue[]=$myrow["a"];
$bValue[]=$myrow["b"];
}
$result->close();
}
$mysqli->close();
I hope this saves someone some time.
mysqli_real_query
(PHP 5)
mysqli_real_query(no version information, might be only in CVS)
mysqli->real_query -- Execute an SQL queryDescription
Procedural style
bool mysqli_real_query ( mysqli link, string query )Object oriented style (method):
class mysqli {bool real_query ( string query )
}
The mysqli_real_query() function is used to execute only a query against the database represented by the link whose result can then be retrieved or stored using the mysqli_store_result() or mysqli_use_result() functions.
注: In order to determine if a given query should return a result set or not, see mysqli_field_count().
add a note
User Contributed Notes
Beeners
07-Jan-2006 04:41
07-Jan-2006 04:41