1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| <?php
$hostname = "127.0.0.1";
$username = "root";
$password = "";
$database = "mabase";
$interne = mysql_pconnect($hostname, $username, $password) or die(mysql_error());
mysql_select_db($database, $interne);
$filename = "votrefichier.sql"; //votre fichier texte
$file = fopen($filename, "r");
$sql = fread($file, filesize($filename));
fclose($file);
$inst = explode(";", $sql);
$n = count($inst);
for($i=0;$i<$n;$i++){
if(trim($inst[$i])!=""){
echo "Instruction $i : ";
mysql_query($inst[$i], $interne) or die(mysql_error());
echo "OK.<br>";
}
}
mysql_close();
?> |
Partager