PHPize Online / SQLize Online  /  SQLtest Online

<?php mysqli_report(MYSQLI_REPORT_ALL ^ MYSQLI_REPORT_STRICT); $query = "SELECT 'ok 1'; SELECT 'ok 2'; SEkECT 'failed'; SELECT 'ok 3'"; $queries["SELECT 'ok 1'"]="SELECT CURRENT_USER()"; $queries["SELECT 'ok 2'"]="SELECT 'ok 2'"; $queries["SEkECT 'failed'"]="SEkECT 'failed'"; $queries["SELECT 'ok 3'"]="SELECT 'ok 3'"; if($mysqli->multi_query(implode(';',$queries))){ do{ if($result=$mysqli->store_result()){ if(mysqli_num_rows($result)<1){ echo "<p>Logic Error @ $current_table Query<br>$current_query</p>"; }else{ while($row=mysqli_fetch_row($result)){ printf("%s\n",$row[0]); } } mysqli_free_result($result); } } while(mysqli_more_results($mysqli) && mysqli_next_result($mysqli)); }else{ list($current_table,$current_query)=each($queries); } if($error=mysqli_error($mysqli)){ echo "<p>Syntax Error @ $current_table Query<br>$current_query<br>Error: $error</p>"; } return; $result = $mysqli->multi_query($query); if ($result) { do { // fetch results if (!$mysqli->more_results()) { break; } if (!$mysqli->next_result()) { echo $mysqli->error; break; } } while (true); } echo $mysqli->error; return; if ($mysqli->multi_query($query)) { do { /* store first result set */ if ($result = $mysqli->store_result()) { while ($row = $result->fetch_row()) { printf("%s\n", $row[0]); } $result->free(); } /* print divider */ if ($mysqli->more_results()) { printf("-----------------\n"); } echo $mysqli->error, $result->error; } while ($mysqli->next_result()); }