/*
新建数据库
*/
public function sql_data(){
$request = json_decode(base64_decode(file_get_contents("php://input")), true);
if (empty($request)) {
exit(100);
}
$ip = $request['platform_ip'];
$db = $request['database'];
$_sql = file_get_contents('http://127.0.0.1/XXXX/xxxxx.sql');
$servername = '127.0.0.1:3306';
$username = "xxxxx";
$password = "xxxxxx";
// 创建连接
// $conn = new mysqli($servername, $username, $password);
$conn = @mysql_connect($servername, $username, $password, $db);
// 检测连接
if (!$conn) {
$sta['status'] = 0;
$sta['content'] = "连接失败: " . mysql_error();
return $sta;
}
mysql_query('set names utf8;'); //设置编码方式
mysql_query("CREATE DATABASE IF NOT EXISTS ".$db." DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;");
mysql_query("USE ".$db);
$_arr = explode(';', $_sql);
//执行sql语句
foreach ($_arr as $_value) {
$res = mysql_query($_value.';');
if (!empty($res)){
$sta['status'] = 0;
$sta['content'] = "数据库sql插入失败!".mysql_error();
}
}
$sta['status'] = 1;
$sta['content'] = "数据库sql插入成功!";
mysql_close();
return $sta;
}