1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| <?php
$link = mysql_connect("xxx.xxx.xxx.xxx", "login", "psswd") or die("Impossible de se connecter : " . mysql_error());
mysql_select_db("MasterHM") or die("Impossible de se connecter : " .mysql_error());
$query = "SELECT * FROM site";
$result = mysql_query($query) or die("Query failed");
while ($ligne=mysql_fetch_array($result))
{
$tab1[$ligne["id"]]=$ligne["champ1"];
$tab2[$ligne["id"]]=$ligne["champ2"];
$tab3[$ligne["id"]]=$ligne["champ3"];
}
mysql_close($link);
$link = mysql_connect("xxx.xxx.xxx.xxx", "login", "psswd")
or die("Impossible de se connecter : " . mysql_error());
mysql_select_db("testPHP") or die("Impossible de se connecter : " .mysql_error());
foreach ($tab1 as $key => $value)
{
$query = "INSERT INTO site values(\"$key\",\"$value\",\"$tab2[$key]\",\"$tab3[$key]\")";
$result = mysql_query($query) or die("Query failed :" . mysql_error());
mysql_close($link);
?> |
Partager