How can I use mysql_multi_query in php?

Question

<?php 
include "../../settings.php";  
include "$basepath/includes/conn.php"; 

/*$receiptnum='';*/ 
$submittedby=''; 
$statementno=''; 
$amount=''; 
$accno=''; 
$dateofpayment='';

if(isset($_POST['submit'])) { /*$receiptnum=$_POST['receiptnum'];   */   
    $statementno=$_POST['statementno']; $amount=$_POST['amount'];   
    $accno=$_REQUEST['accountnum']; $submittedby=$_POST['submitby'];   
    $dateofpayment=$_REQUEST['dateofpayment']; }
    /*$query= "CALL newreceipt('$reciptnum','$statementno','$amount',@doj1,'$accno','$submitedby')";*/ 
    $query="INSERT into statement(statementno) VALUES('".$statementno."')"; 
    $query.="INSERT into   
          receipt(statementno,accountnum,dateofpayment,amount,submittedby)   
          VALUES('".$statementno."','".$accno."','".$dateofpayment."','".$amount."','".$submittedby."')";
    $result=mysqli_multi_query($con,$query); {  
    if($result) { 
         die ("An unexpected error , Please try again!");           
    } else {
         header('Location: receipt.php');
    }
}
?>

Answer 1

According to the official documentation, you have 2 ways to do it. Since you are not using the object oriented way, I'll nearly-copy-paste an example (from the doc, as I said) of the procedural way:

// Your queries
$query="INSERT into statement(statementno) VALUES('".$statementno."')"; 
    $query.="INSERT into   
          receipt(statementno,accountnum,dateofpayment,amount,submittedby)   
          VALUES('".$statementno."','".$accno."','".$dateofpayment."','".$amount."','".$submittedby."')";

/* execute multi query */
if (mysqli_multi_query($con, $query)) {
    do {
        /* store first result set */
        if ($result = mysqli_store_result($con)) {
            while ($row = mysqli_fetch_row($result)) {
                printf("%s\n", $row[0]); // Or whatever...
            }
            mysqli_free_result($result); // Free in order to store the next
        }
        }
    } while (mysqli_next_result($con));
}