php导入数据库sql操作
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
//代码导入.sql文件生成数据库： public function sql_input(){ $file_sql=dirname('sitestar.sql'; $sql_content=file_get_contents($file_sql); $sql_content = str_replace("\r", "\n", $sql_content); $config_sql=explode(";\n", $sql_content); $conn = mysql_connect($dabate['hostname'],$dabate['user'],$dabate['password']); mysql_query("SET NAMES 'utf8'"); mysql_query("CREATE DATABASE IF NOT EXISTS ".$username." DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;"); mysql_select_db($username, $conn); foreach ($config_sql as $_value) { mysql_query($_value.';'); } mysql_close(); } |