A simple way to import phpMyAdmin generated SQL files in PHP

We know a lot of online download forums or personal blog programs have installed pages, in order to create such an installation program will need to use the SQL file creation database.

Valid only for phpMyAdmin exported SQL files
Copy the code code as follows:
$dbfile = "Test.sql";
$content =iconv ("UTF-8", "GB2312", file_get_contents ($dbfile));
Get the data you created
Remove 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];
Inserting data
foreach ($iarr as $c)
{
@mysql_query ($c, $link);
}

