PHP;"> PHP header("content-type:text/html;charset=utf-8"); error_reporting(E_ALL); set_time_limit(0); $file='./test.sql'; $data=file($file);

echo "

";

//print_r($data);

$data_new=array();

$tmp=array();

foreach ($data as $line) {

$line=trim($line);

if(strlen($line)==0){

continue;

}

if(substr($line,2)=='--'){

continue;

}

if(substr($line,2)=='/*'){

continue;

}

$tmp[]=$line;

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

$query=implode('',$tmp);

$tmp=array();

$data_new[]=$query;

}

}
$MysqLi=new MysqLi('localhost','root','test');

if($MysqLi->connect_errno){

exit('数据库连接失败！');

}

$MysqLi->query("set names utf8");
$error=array();

foreach($data_new as $sql){

$MysqLi->query($sql);

$r=$MysqLi->error;

if($r) $error[]=$r;

}

print_r($r);
/*
MysqL>ALTER TABLE tbl2 DISABLE KEYS;

Query OK,0 rows affected (0.00 sec)
MysqL>INSERT INTO tbl2 SELECT * FROM tbl1;

Query OK,2000000 row affected (36.30 sec)

Records: 2000000 Duplicates: 0 Warnings: 0
MysqL>ALTER TABLE tbl2 ENABLE KEYS;

Query OK,0 rows affected (44.55 sec)
*/

PHP;"> $rate_info = file("$table.txt"); print $n_s = chop($rate_info[0]); for($start=1;$start { $value=""; for ($i=$start;$i<($start+$n_s-1);$i++) { $tmp = str_replace("&&jimmy&&"," ",chop($rate_info[$i])); $value .= "'".addslashes($tmp)."',"; } $tmp = str_replace("&&jimmy&&",chop($rate_info[$start+$n_s-1])); $value .= "'".$tmp."'"; $query = "insert into $table values (".$value.")"; print mysql_error(); mysql_query($query); print $start." "; } print "ostart"; ?>