Question

How to execute multi query with initiate a result set using MySQLi in PHP

Answer 1

$db_host        = 'localhost';
$db_user        = 'root';
$db_password    = '';
$db_name        = 'allonpage';
  
$con = new mysqli($db_host, $db_user, $db_password, $db_name);
  
if ($con->connect_error) 
    die('Connection Error: ' . $con->server_info);
  
$sql_query  = "SELECT * from images;";
$sql_query .= "SELECT * from webpages";

// execute multi query 
if ($con->multi_query($sql_query)) 
{
    do {
        // store first SQL result set 
        if ($result = $con->use_result()) 
        {
            while ($row = $result->fetch_row())
             {
                echo $row[0] . "<br />";
            }
            $result->close();
        }
        if ($con->more_results()) 
            echo "------------------------------<br />";
        else
            break;
    } while ($con->next_result());
}
                                   
$con->close();
 
/*
run: 

49
50
51
52
53
54
55
56
57
58
59
63
64
------------------------------
60
 
*/

 

70+ SQL courses for beginners and professionals