How to Run Multiple Queries at Once in OOP
Note:The SQL Queries Shld be seperated by Semicolon(;)
$Conn = $this->dbConnect;
$strSQL = "SELECT name FROM tbSample1;";
$strSQL = $strSQL."SELECT age FROM tbSample1;";
if ($Conn->multi_query($strSQL))
{
do
{
/* store first result set */
if ($result = $Conn->store_result())
{
while ($row = $result->fetch_row())
{
$item = array();
$item = $row;
$arrTempCounts[] = $item;
}
$result->free();
}
/* print divider */
if ($Conn->more_results())
{
print("-----------------n");
}
}while ($Conn->next_result());
}