????PHP???SQL???????SQL????????????
???????????? ???????[ 2015/12/22 11:02:48 ] ?????????????
???????????php??????.sql?????????????????sql????е?????????????sql???????????????
????????????
//??????????
$_sql = file_get_contents('test.sql');
$_arr = explode(';'?? $_sql);
$_mysqli = new mysqli(DB_HOST??DB_USER??DB_PASS);
if (mysqli_connect_errno()) {
exit('????????????');
}
//???sql???
foreach ($_arr as $_value) {
$_mysqli->query($_value.';');
}
$_mysqli->close();
$_mysqli = null;
????????text.sql?????????е?sql?????DB_HOST????????DB_USER???????DB_PASS????!
????????????????????sql??????????????????????????????????????sql???????????????
????CREATE DATABASE IF NOT EXISTS ??????? DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
????USE ???????
?????????text.php????????е?sql??????????
????$_mysqli->query("CREATE DATABASE IF NOT EXISTS ??????? DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;");
????$_mysqli->query("USE ???????");
??????????????????????????????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11