PHP MySQL Database import script (example)

PHP implementation MySQL data import Define ("Dbhost", "localhost"); Database Host Define ("DbUser", "root"); Database user Define ("Dbpass", "password"); Database Password Mysql_connect (Dbhost,dbuser,dbpass) or Die ("Cannot connect to server!"); mysql_create_db ("dbname") or Die ("could not establish database, you may have installed"); mysql_select_db ("dbname") or Die ("Cannot select database, installation Failed"); $FP =fopen ("Install.sql", "R") or Die ("Cannot open SQL file, please check"); $sql =fread ($fp, FileSize ("Install.sql")); Fclose ($FP); $sql =explode (";", $sql); for ($i =0; $i mysql_query ($sql [$i]); echo "Installation Successful"; ?> Copy Code When a database statement is not created in the 1,sql file Define ("Dbhost", "localhost"); Database Host Define ("DbUser", "root"); Database user Define ("Dbpass", "password"); Database Password Define ("DbName", "DbName"); Database name Mysql_connect (Dbhost,dbuser,dbpass) or Die ("Cannot connect to server!"); mysql_create_db (DbName) or die ("could not establish database, you may have installed"); mysql_select_db (DbName) or Die ("Cannot select database, installation Failed"); $FP =fopen ("Install.sql", "R") or Die ("Cannot open SQL file, please check"); $sql =fread ($fp, FileSize ("Install.sql")); Fclose ($FP); $sql =explode (";", $sql); for ($i =0; $i mysql_query ($sql [$i]); echo "Installation Successful"; ?> Copy Code The 2,sql file has the CREATE DATABASE statement (that is, contains the Create databases and use statements) Define ("Dbhost", "localhost"); Database Host Define ("DbUser", "root"); Database user Define ("Dbpass", "password"); Database Password Mysql_connect (Dbhost,dbuser,dbpass) or Die ("Cannot connect to server!"); $FP =fopen ("Install.sql", "R") or Die ("Cannot open SQL file, please check"); $sql =fread ($fp, FileSize ("Install.sql")); Fclose ($FP); $sql =explode (";", $sql); for ($i =0; $i mysql_query ($sql [$i]); echo "Installation Successful"; ?> Copy Code

