Executing multiple SQL queries in one statement with PHP

by

Pass 65536 to mysql_connect as 5th parameter.

Example:

$conn = mysql_connect('localhost','username','password', true, 65536 /* here! */) 
    or die("cannot connect");
mysql_select_db('database_name') or die("cannot use database");
mysql_query("
    INSERT INTO table1 (field1,field2) VALUES(1,2);

    INSERT INTO table2 (field3,field4,field5) VALUES(3,4,5);

    DELETE FROM table3 WHERE field6 = 6;

    UPDATE table4 SET field7 = 7 WHERE field8 = 8;

    INSERT INTO table5
       SELECT t6.field11, t6.field12, t7.field13
       FROM table6 t6
       INNER JOIN table7 t7 ON t7.field9 = t6.field10;

    -- etc
");

When you are working with mysql_fetch_* or mysql_num_rows, or mysql_affected_rows, only the first statement is valid.

For example, the following codes, the first statement is INSERT, you cannot execute mysql_num_rows and mysql_fetch_*.
It is okay to use mysql_affected_rows to return how many rows inserted.

$conn = mysql_connect('localhost','username','password', true, 65536) or die("cannot connect");
mysql_select_db('database_name') or die("cannot use database");
mysql_query("
    INSERT INTO table1 (field1,field2) VALUES(1,2);
    SELECT * FROM table2;
");

Another example, the following codes, the first statement is SELECT, you cannot execute mysql_affected_rows. But you can execute mysql_fetch_assoc to get a key-value pair of row resulted from the first SELECT statement, or you can execute mysql_num_rows to get number of rows based on the first SELECT statement.

$conn = mysql_connect('localhost','username','password', true, 65536) or die("cannot connect");
mysql_select_db('database_name') or die("cannot use database");
mysql_query("
    SELECT * FROM table2;
    INSERT INTO table1 (field1,field2) VALUES(1,2);
");

More Related Contents:

  1. Comma separated numeric values – PHP CodeIgniter
  2. PHP PDO and Mysql [closed]
  3. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  4. Select those record only from table 1 where city exist against state id in table 2 in PHP
  5. PHP PDO prepared statements
  6. PDO MySQL: Use PDO::ATTR_EMULATE_PREPARES or not?
  7. strange character encoding of stored data , old script is showing them fine new one doesn’t
  8. select count(*) from table of mysql in php
  9. Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?
  10. Loading .sql files from within PHP
  11. Incorrect Integer (2147483647) is inserted into MySQL?
  12. How to loop through a mysql result set
  13. Cannot connect to MySQL 4.1+ using old authentication
  14. Object of class DateTime could not be converted to string
  15. PHP Commands Out of Sync error
  16. MySQL db question marks instead of hebrew characters..?
  17. “Warning: Cannot modify header information – headers already sent by” error [duplicate]
  18. mysql_num_rows() expects parameter 1 to be resource, boolean given in [duplicate]
  19. Easy way to export a SQL table without access to the server or phpMyADMIN
  20. using nulls in a mysqli prepared statement
  21. How can I count the numbers of rows that a MySQL query returned?
  22. How I can create installer for website. PHP mysql [closed]
  23. How to join two tables with ssp.class.php
  24. How to run the PHP script at scheduled time
  25. How to handle error for duplicate entries?
  26. How to convert IPv6 from binary for storage in MySQL
  27. Eloquent many-to-many-to-many – how to load distant relation easily
  28. Replacing \r\n with PHP
  29. How to check if a value already exists to avoid duplicates?
  30. How to use MySQL Found_Rows() in PHP?

Leave a Comment