php sql文件,PHP运行SQL脚本文件

header("Content-Type: text/html;charset=utf-8");

function populate_db( $DBname, $DBPrefix, $sqlfile ) {

global $errors;

@mysql_select_db($DBname);

mysql_query("SET NAMES utf8");

$mqr = @get_magic_quotes_runtime();

@set_magic_quotes_runtime(0);

$query = fread(fopen($sqlfile, "r"), filesize($sqlfile));

@set_magic_quotes_runtime($mqr);

$pieces = split_sql($query);

for ($i=0; $i

$pieces[$i] = trim($pieces[$i]);

if(!empty($pieces[$i]) && $pieces[$i] != "#") {

$pieces[$i] = str_replace( "#__", $DBPrefix, $pieces[$i]);

if (!$result = @mysql_query ($pieces[$i])) {

$errors[] = array ( mysql_error(), $pieces[$i] );

}

}

}

}

function split_sql($sql) {

$sql = trim($sql);

$sql = ereg_replace("\n#[^\n]*\n", "\n", $sql);

$buffer = array();

$ret = array();

$in_string = false;

for($i=0; $i

if($sql[$i] == ";" && !$in_string) {

$ret[] = substr($sql, 0, $i);

$sql = substr($sql, $i + 1);

$i = 0;

}

if($in_string && ($sql[$i] == $in_string) && $buffer[1] != "\\") {

$in_string = false;

}

elseif(!$in_string && ($sql[$i] == '"' || $sql[$i] == "'") && (!isset($buffer[0]) || $buffer[0] != "\\")) {

$in_string = $sql[$i];

}

if(isset($buffer[1])) {

$buffer[0] = $buffer[1];

}

$buffer[1] = $sql[$i];

}

if(!empty($sql)) {

$ret[] = $sql;

}

return($ret);

}

$lnk = mysql_connect('localhost','root','password')

or die ('连接失败'.mysql_error());

if (!mysql_select_db('dbname',$lnk)){

exit();

}

populate_db( 'dbname','','abc.sql' );

?>