\[quote\] $link = mysqli_connect("localhost", "username", "testpassword", "dbname")or die('connection problem'); /* check connection */ if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } //if ($result = mysqli_query($link, "CALL my_sqrt(Other,@out_value)")) { $result = mysqli_query($link, "CALL show_sp_test()"); $row_cnt = mysqli_num_rows($result); printf("Result set has %d rows.\n", $row_cnt); /* close result set */
mysqli_free_result($result); //} /* close connection */ mysqli_close($link);\[/quote\]I got error like \[code\]Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in sample-sp.php on line 19Result set has 0 rows.Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in sample-sp.php on line 24\[/code\]but i change the stored procedure CALL to normal query working fine, Tell me , is there any thing i should check /, Is there any Bug in my snippet,NOTE: IN MY SERVER MYSQLI ENABLEDThanks
printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } //if ($result = mysqli_query($link, "CALL my_sqrt(Other,@out_value)")) { $result = mysqli_query($link, "CALL show_sp_test()"); $row_cnt = mysqli_num_rows($result); printf("Result set has %d rows.\n", $row_cnt); /* close result set */
mysqli_free_result($result); //} /* close connection */ mysqli_close($link);\[/quote\]I got error like \[code\]Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in sample-sp.php on line 19Result set has 0 rows.Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in sample-sp.php on line 24\[/code\]but i change the stored procedure CALL to normal query working fine, Tell me , is there any thing i should check /, Is there any Bug in my snippet,NOTE: IN MY SERVER MYSQLI ENABLEDThanks