Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $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();
Add Comment
Please, Sign In to add comment