php网站怎么导入sql数据库,php 简单数据库导入程序[.sql文件]

function insert_file($file,$replace=''){

global $Charset;

$readfiles=read_file($file);

if($replace){

$readfiles=str_replace('$timestamp',"$timestamp",$readfiles);

}

$detail=explode("n",$readfiles);

$count=count($detail);

for($j=0;$j

$ck=substr($detail[$j],0,4);

if( ereg("#",$ck)||ereg("--",$ck) ){

continue;

}

$array[]=$detail[$j];

}

$read=implode("n",$array);

$sql=str_replace("r",'',$read);

$detail=explode(";n",$sql);

$count=count($detail);

for($i=0;$i

$sql=str_replace("r",'',$detail[$i]);

$sql=str_replace("n",'',$sql);

$sql=trim($sql);

if($sql){

if(eregi("CREATE TABLE",$sql)){

$mysqlV=mysql_get_server_info();

$sql=preg_replace("/DEFAULT CHARSET=([a-z0-9]+)/is","",$sql);

$sql=preg_replace("/TYPE=MyISAM/is","ENGINE=MyISAM",$sql);

if($mysqlV>'4.1'){

$sql=str_replace("ENGINE=MyISAM"," ENGINE=MyISAM DEFAULT CHARSET=$Charset ",$sql);

}

}

$query=mysql_query($sql);

if (!$query) die("数据库出错:$sql");

$check++;

}

}

return $check;

}

function read_file($filename,$method="rb"){

if($handle=@fopen($filename,$method)){

@flock($handle,LOCK_SH);

$filedata=@fread($handle,@filesize($filename));

@fclose($handle);

}

return $filedata;

}