@ $db = new mysqli('localhost','root','root','book'); //我的数据库
if (mysqli_connect_errno()){
echo "Error: could not connect the database;<br>";
exit;
}
$tem = $_SERVER['DOCUMENT_ROOT']."/web/searchbook/book.sql"; //我的sql文件位置
$sql = file_get_contents($tem);
$a = explode(";", $sql);
foreach ($a as $b) {
# code...
$c = $b.";";
$d = $db->query($c);
if ($d) echo "success";
else echo ' failed';
}
昨晚突然想知道怎么实现用php读入sql文件以此来连接数据库执行创建数据, 试了百度上几个做法,最后成功的方法是用php的file_get_content()函数把sql文件读进来, 然后用explode分割, 加上分号后用query 逐条语句执行,搞定