PHP：读取文本文件并对MySQL执行SQL语句

Question

I want to create a form in PHP that will load a .sql file, read its contents, and execute those statements against a MySQL database.

Currently using function get_file_contents but it's not working. What can I do?

Answer 1

If you have several queries in your file, you'll either have to :

• split the file into multiple distinct queries, and use either mysql_query or mysqli_query for each one of those queries.
  • those two functions cannot execute more than one query per call : quoting the manual page of mysql_query : "multiple queries are not supported"
• use mysqli_multi_query to send several queries at once
  • There is no equivalent using the mysql_* family of functions
• use the mysql command-line client, to import the file, with something like this (you'll have to pass the right values, of course) :
  • mysql --user=USERNAME --password=PASSWORD --host=localhost DATABASENAME < your-file.sql