php/mysql with multiple queries

by

Thanks to php.net I’ve come up with a solution : you have to use (mysqli_multi_query($link, $query)) to run multiple concatenated queries.

 /* create sql connection*/
$link = mysqli_connect("server", "user", "password", "database");

$query = "SQL STATEMENTS;"; /*  first query : Notice the 2 semicolons at the end ! */
$query .= "SQL STATEMENTS;"; /* Notice the dot before = and the 2 semicolons at the end ! */
$query .= "SQL STATEMENTS;"; /* Notice the dot before = and the 2 semicolons at the end ! */
$query .= "SQL STATEMENTS"; /* last query : Notice the dot before = at the end ! */

/* Execute queries */

if (mysqli_multi_query($link, $query)) {
do {
    /* store first result set */
    if ($result = mysqli_store_result($link)) {
        while ($row = mysqli_fetch_array($result)) 

/* print your results */    
{
echo $row['column1'];
echo $row['column2'];
}
mysqli_free_result($result);
}   
} while (mysqli_next_result($link));
}

EDIT – The solution above works if you really want to do one big query but it’s also possible to execute as many queries as you wish and execute them separately.

$query1 = "Create temporary table A select c1 from t1"; 
$result1 = mysqli_query($link, $query1) or die(mysqli_error());

$query2 = "select c1 from A"; 
$result2 = mysqli_query($link, $query2) or die(mysqli_error());

while($row = mysqli_fetch_array($result2)) {

echo $row['c1'];
    }

More Related Contents:

  1. While loop within While loop not looping
  2. Sign in form always showing "Wrong Credentials"
  3. Prevent creating duplicate entries in PHP
  4. php nested while loop. Inner loop works only once [closed]
  5. How to include a PHP variable inside a MySQL statement
  6. PHP – concatenate or directly insert variables in string
  7. php String Concatenation, Performance
  8. Single quotes or double quotes for variable concatenation? [closed]
  9. Concatenation with addition in it doesn’t work as expected
  10. PHP variable interpolation vs concatenation [duplicate]
  11. Include constant in string without concatenating
  12. How can I list data in sections by an ID, with a while loop in PHP? [closed]
  13. Php date() Date and time is stuck [closed]
  14. mysqli or die, does it have to die?
  15. PHP/MySQL insert row then get ‘id’
  16. Show values from a MySQL database table inside a HTML table on a webpage [duplicate]
  17. PHP equivalent of .NET/Java’s toString()
  18. PHP file cannot enter some part of code
  19. MySQL returns only one row
  20. Populate a Drop down box from a mySQL table in PHP
  21. How to get email address from a long string
  22. Doing a while / loop to get 10 random results
  23. Warning: mysql_num_rows() expects parameter 1 to be resource, object given [duplicate]
  24. MySQL error when inserting data containing apostrophes (single quotes)?
  25. How to reverse a Unicode string
  26. Convert a String to Variable
  27. How can I do a migration in laravel 5.5?
  28. How to get last inserted id from table MySQL [duplicate]
  29. Save array in mysql database
  30. find in set in laravel ? example

Leave a Comment