Use PHP to execute SQL files and import SQL files into the database

How to use php to automatically execute .sql files, that is, to obtain the contents of the sql file, and then execute each sql statement once.

Code example:

<span>//</span><span>读取文件内容</span>$_sql = file_get_contents(<span>'</span><span>test.sql</span><span>'</span><span>);
 
$_arr </span>= explode(<span>'</span><span>;</span><span>'</span><span>, $_sql);
$_mysqli </span>= <span>new</span><span> mysqli(DB_HOST,DB_USER,DB_PASS);
</span><span>if</span><span> (mysqli_connect_errno()) {
    exit(</span><span>'</span><span>连接数据库出错</span><span>'</span><span>);
}
</span><span>//</span><span>执行sql语句</span><span>foreach</span> ($_arr <span>as</span><span> $_value) {
    $_mysqli</span>->query($_value.<span>'</span><span>;</span><span>'</span><span>);
}
$_mysqli</span>-><span>close();
$_mysqli </span>= <span>null</span><span>;

</span>

The above text.sql is the sql file you need to execute, DB_HOST host name, DB_USER username, DB_PASS password!

This is just the most basic automatic execution sql file, you can also customize it Generate the name of the database by deleting the following code in the sql file

<span>CREATE DATABASE IF NOT EXISTS 数据库名 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE 数据库名</span>

and adding

$_mysqli->query(<span>"</span><span>CREATE DATABASE IF NOT EXISTS 数据库名 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;</span><span>"</span><span>);
$_mysqli</span>->query(<span>"</span><span>USE 数据库名</span><span>"</span>);

The above introduces the use of PHP to execute SQL files and import SQL files into the database, including the content. I hope it will be helpful to friends who are interested in PHP tutorials.