PHP: multiple SQL queries in one mysql_query statement

by

You have more problem cases than just semicolons within strings.

  • Script builtin commands that cannot be executed by mysql_query(), like USE.
  • Statements that are not terminated with a semicolon, like DELIMITER.
  • Statements that contain semicolons, but not inside quotes, like CREATE PROCEDURE.

I don’t know of an easy way to handle this task, without shelling out to the mysql command-line client. I realize you said you can’t rely on that client being present, but without that client, you need a large amount of PHP code to parse the script and execute statements appropriately.

You may be able to find such code inside the phpMyAdmin product. However, that product is licensed under the GPL, so if you use any of the code, you must also license your own project under the GPL.

See also my answers to these related questions:

More Related Contents:

  1. Order results from two queries based on time in second query [closed]
  2. Query database then email posts from where user is subbed to
  3. Save the data into a database and return another value from database using PHP
  4. Problame with files on SQL
  5. How can I prevent SQL injection in PHP?
  6. SQL injection that gets around mysql_real_escape_string()
  7. How to include a PHP variable inside a MySQL statement
  8. How can I do ‘insert if not exists’ in MySQL?
  9. How to apply bindValue method in LIMIT clause?
  10. Can I parameterize the table name in a prepared statement?
  11. Getting raw SQL query string from PDO prepared statements
  12. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  13. MySQL Prepared statements with a variable size variable list
  14. Achieve hierarchy, Parent/Child Relationship in an effective and easy way
  15. PDO with INSERT INTO through prepared statements [closed]
  16. How to search for slash (\) in MySQL? and why escaping (\) not required for where (=) but for Like is required?
  17. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102 [closed]
  18. Comma separated values in MySQL “IN” clause
  19. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  20. Doing a while / loop to get 10 random results
  21. Do SQL connections opened with PDO in PHP have to be closed
  22. MYSQL Select from tables based on multiple rows
  23. How to execute raw queries with Laravel 5.1?
  24. How to convert ISO8601 to Date format in php
  25. How do you do multiple SQL statements in one mysql_query?
  26. MySQL/SQL retrieve first 40 characters of a text field?
  27. Do I have to use mysql_real_escape_string if I bind parameters?
  28. PDO and MySQL ‘between’
  29. MySQL Join Multiple Rows as Columns
  30. Aggregated query without GROUP BY

Leave a Comment