PHP Call stored procedure returns result set, resolves cant return a result set in_php tutorial

Need php call stored procedure, return a result set, find very difficult, find a half-day, finally in the Foreigner's Forum find solution, here localization.

The key is two.

1) define (Client_multi_results, 131072);

2) $link = mysql_connect ("127.0.0.1", "Root", "" ", 1,client_multi_results) or Die (" Could Not Connect: ". Mysql_error ());

The following can be used normally, the following is an example program.

Define (Client_multi_results, 131072);

$link = mysql_connect ("127.0.0.1", "Root", "" "," 1,client_multi_results ") or Die (" Could Not Connect: ". Mysql_error ());
mysql_select_db ("vs") or Die ("Could not select Database");
?>

$result = mysql_query ("Call get_news_from_class_id (2)") or Die ("Query failed:". Mysql_error ());
while ($row = Mysql_fetch_array ($result, MYSQL_ASSOC))
{
$line =. $row ["title"]. (. $row ["Page_time"].). r>;
Echo $line;
printf ("");

}
Mysql_free_result ($result);
?>

Mysql_close ($link);
?>

http://www.bkjia.com/PHPjc/508368.html www.bkjia.com true http://www.bkjia.com/PHPjc/508368.html techarticle need php Call stored procedure, return a result set, find very difficult, find a half-day, finally in the Foreigner's Forum find solution, here localization. The key is two point 1) ...

