php数据怎么导入mysql答辩_php导入数据到mysql实现代码

// name of the file

$filename = 'churc.sql';

// mysql host

$mysql_host = 'localhost';

// mysql username

$mysql_username = 'root';

// mysql password

$mysql_password = '';

// database name

$mysql_database = 'dump';

// connect to mysql server

mysql_connect($mysql_host, $mysql_username, $mysql_password) or die('error connecting to mysql server: ' . mysql_error());

// select database

mysql_select_db($mysql_database) or die('error selecting mysql database: ' . mysql_error());

// temporary variable, used to store current query

$templine = '';

// read in entire file

$lines = file($filename);

// loop through each line

foreach ($lines as $line)

{

// skip it if it's a comment (脚本学堂 www.jbxue.com 编辑整理)

if (substr($line, 0, 2) == '--' || $line == '')

continue;

// add this line to the current segment

$templine .= $line;

// if it has a semicolon at the end, it's the end of the query

if (substr(trim($line), -1, 1) == ';')

{

// perform the query

mysql_query($templine) or print('error performing query \'' . $templine . '\': ' . mysql_error() . '
');

// reset temp variable to empty

$templine = '';

}

}

echo "tables imported successfully";

?>