PHP执行SQL文件

广告 广告

<?php

$db_file = 'SQl文件路径';
$db_host = 'localhost';
$db_port = '3306';
$db_user = '数据库用户名';
$db_pwd = '数据库用户密码';
$db_name = '数据库名称';

$_sql = file_get_contents($db_file);
$_arr = explode(';', $_sql);

$_mysqli = new mysqli($db_host.':'.$db_port,$db_user,$db_pwd,$db_name);
if (mysqli_connect_errno()) {
  exit('数据库链接失败');
}

foreach ($_arr as $_value) {
  $_mysqli->query($_value.';');
}
$_mysqli->close();

?>