Use a PHP statement to import a database *.sql file into a database _php tips

The simplest PHP statement imports the database *.sql file into the database

Copy Code code as follows:

$sql =file_get_contents ("Text.sql"); Read the SQL statement as a string into the $sql
$a =explode (";", $sql); Use the explode () function to put the $sql string ";" Split an array

foreach ($a as $b) {//traversal array
$c = $b. ";"; After the split is no ";" , because the SQL statement is ";" End, so before executing SQL, add it to the
mysql_query ($c); Execute SQL statement
}

In many setup programs, you will see the installation of the database, the other mysterious behind is such a simple few code. First, there will be a SQL file in the installation and then follow the code in PHP.