Use PHP to execute SQL files and import SQL files into the database, _PHP tutorial

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

How to use PHP to automatically execute .sql files is to obtain the contents of the sql file and then convert each sentence of sql The statement is executed 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 user name, DB_PASS password!

This is just the most basic automatically executed sql file. You can also customize the name of the generated 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>

Added

$_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>);

http://www.bkjia.com/PHPjc/1107663.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1107663.htmlTechArticleUse PHP to execute SQL files and import SQL files into the database. How to use php to automatically execute .sql files is to obtain sql file, and then execute each sql statement once. Generation...