m0n0lithic

Send one segment of registers from source to target (MySQL)

May 24th, 2012
249
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.51 KB | None | 0 0
  1. #!/usr/bin/php
  2. <?php
  3. $link1=mysql_connect("172.25.19.22","evilla","evilla2010");
  4. mysql_select_db("webmeteorologia",$link1);
  5. mysql_query("SET NAMES 'utf8'", $link1);
  6. // $res = mysql_query("SELECT idprediccionesdiarias,Img1,Img2 FROM prediccionesdiarias ORDER by idprediccionesdiarias");
  7. $link2=mysql_connect("172.25.40.7","evilla","evilla2010");
  8. mysql_select_db("webmeteorologia",$link2);
  9. mysql_query("SET NAMES 'utf8'", $link2);
  10. for ($count=8209; $count < 8289; $count++)
  11. {
  12. //while ($row = mysql_fetch_array($res, MYSQL_NUM))
  13. // {
  14.         $contador = $count+1;
  15.         $res = mysql_query("SELECT idprediccionesdiarias,Fecha,Prediccion,P1,P2,P3,Predictor,Img1,Img2 FROM prediccionesdiarias WHERE idprediccionesdiarias=".$contador,$link2);
  16.         $row = mysql_fetch_row($res);
  17.         echo $row[0]."- ";
  18.         if ($row[0] != "") {
  19.         $Img1 = mysql_escape_string($row[7]);
  20.         $Img2 = mysql_escape_string($row[8]);
  21.         mysql_query("INSERT INTO `prediccionesdiarias` (idprediccionesdiarias,`Fecha`,`Prediccion`,`P1`,`P2`,`P3`,`Predictor`,`Img1`,`Img2`) VALUES (".$row[0].",'".$row[1]."','".$row[2]."','".$row[3]."','".$row[4]."','".$row[5]."','".$row[6]."','".$Img1."','".$Img2."');",$link1);
  22.         }
  23.         // echo "INSERT INTO `prediccionesdiarias` (`idprediccionesdiarias`,`Fecha`,`Prediccion`,`P1`,`P2`,`P3`,`Predictor`,`Img1`,`Img2`) VALUES ('".$row[0]."','".$row[1]."','".$row[2]."','".$row[6]."');";
  24.         mysql_free_result($res);
  25. }
  26. mysql_close($link1);
  27. mysql_close($link2);
  28.  
  29. // var_dump($argv);
  30. ?>
Advertisement
Add Comment
Please, Sign In to add comment