/*
* 数据库文件导入
* $path sql文件路径
* $host 数据库链接地址(默认端口3306,其他端口连接地址为 host:端口号)
* $user 数据库用户名
* $pass 数据库密码
* $database 选择的数据库
*/
function input($path,$host,$user,$pass,$database)
{
//读取文件内容
$_sql = file_get_contents($path);
$_arr = $this->parse_sql($_sql,0);
$_mysqli = new mysqli($host,$user,$pass);
if (mysqli_connect_errno()) {
exit('连接数据库出错');
}
$_mysqli->query("CREATE DATABASE IF NOT EXISTS ".$database." DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;");
$_mysqli->query("USE ".$database);
//执行sql语句
foreach ($_arr as $_value) {
$_mysqli->query($_value.';');
}
$res = $_mysqli->close();
$_mysqli = null;
return $res;
}
$r_data = input('C:/Users/Administrator/Des