A relatively simple way to import the sql file generated by phpmyadmin in php_PHP tutorial

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 comments
$ content=preg_replace("/--.*n/iU","",$content);
//Replace 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);
}

http://www.bkjia.com/PHPjc/323751.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/323751.htmlTechArticleWe know that many forums or personal blog programs downloaded online have installation pages, so we need to make such an installation program. You need to use sql files to create the database. Only export to phpmyadmin...