transfert entre 2 BdD local à internet => besoin d'aide - PHP - Programmation
Marsh Posté le 22-01-2006 à 23:13:37
Rare sont les hébergeurs qui permettent les connexions SQL externes ceci dit, tu as pensé à vérifier ce détail avant de criser ?
Marsh Posté le 23-01-2006 à 01:32:36
Reply
Marsh Posté le 22-01-2006 à 23:04:30
Voici mon code que j'execute à partir du serveur local easy php
$link1 = mysql_pconnect("localhost", "root","" );
$link2 = mysql_pconnect("sql.xxxxxxxx.xx", "logininternet","passinternet" );
mysql_select_db($db1 , $link1);
mysql_select_db($db2, $link2);
$result1= mysql_query($query1, $link1);
$result2= mysql_query($query2, $link2);
$result1 = mysql_query("SELECT * FROM moteur'" );
$num_rows = mysql_num_rows($result1);
if($result1) {
while($row = mysql_fetch_array($result1)) {
$categorie = $row["categorie"];
$match = $row["match"];
echo $row["url"];
print("<br>" );
$result2 = mysql_query("INSERT INTO `transfert` (`categorie`) VALUES ('$categorie')" );
}
}
mysql_close($link1);
mysql_close($link2);
...
et voici les erreurs renvoyées :
Warning: mysql_pconnect(): Can't connect to MySQL server on 'sql.xxxxxxxx.xx' (10061) in d:\program files\easyphp1-8\www\matrice\transfert.php on line 7
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in d:\program files\easyphp1-8\www\matrice\transfert.php on line 10
Notice: Undefined variable: query1 in d:\program files\easyphp1-8\www\matrice\transfert.php on line 12
Notice: Undefined variable: query2 in d:\program files\easyphp1-8\www\matrice\transfert.php on line 13
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in d:\program files\easyphp1-8\www\matrice\transfert.php on line 13
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in d:\program files\easyphp1-8\www\matrice\transfert.php on line 16
Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in d:\program files\easyphp1-8\www\matrice\transfert.php on line 33
et voici ma réaction...
Message édité par erwan83 le 22-01-2006 à 23:08:18
---------------
http://www.ypikay.com