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";
$c
Get the data you created
Remove comments
$c/--. *\n/iu "," ", $content);
Replace prefix
$c
$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);
}
The above describes the phpMyAdmin configuration php simple import phpmyadmin generated SQL file method, including the phpMyAdmin configuration aspects, I hope to be interested in PHP tutorial friends helpful.