Home >Backend Development >PHP Tutorial >A relatively simple method in php to import the sql file generated by phpmyadmin
We know that many forums or personal blog programs downloaded from the Internet have installation pages. To make such an installation program, you need to use a sql file to create a database.
Only valid for sql files exported by phpmyadmin
Copy code The code is as follows:
$dbfile="test.sql";
$content=iconv("UTF-8","GB2312",file_get_contents($dbfile));
//Get the created data
//Remove the comment
$content=preg_replace("/--.*n/iU","",$content);
//Replace the prefix
$content=str_replace("ct_", TABLE_PRE,$content);
$carr=array();
$iarr=array();
//Extract create
preg_match_all("/Create table .*(.*).*;/iUs",$content ,$carr);
$carr=$carr[0];
foreach($carr as $c)
{
@mysql_query($c,$link);
}
//Extract insert
preg_match_all("/ INSERT INTO .*(.*);/iUs",$content,$iarr);
$iarr=$iarr[0];
//Insert data
foreach($iarr as $c)
{
@mysql_query( $c,$link);
}