萬盛學電腦網

 萬盛學電腦網 >> 網絡編程 >> php編程 >> php 簡單數據庫導入程序[.sql文件]

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

copyright © 萬盛學電腦網 all rights reserved