【www.gdgbn.com--php与数据库】

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<$count;$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<$count;$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;
}

本文来源：http://www.gdgbn.com/jiaocheng/20897/