m0n0lithic

dumpear imagenes png a una bd/tabla mysql

May 14th, 2012
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.19 KB | None | 0 0
  1. #!/usr/bin/php
  2. <?php
  3. $link=mysql_connect("localhost","evilla","evilla2010");
  4. mysql_select_db("webmeteorologia",$link);
  5.  
  6. for ($count = 1; $count <= 13; $count++) {
  7.         $sCount = sprintf("%02d", $count+1);
  8.         $Fecha = "2012-5-".$sCount;
  9.         $sCount= sprintf("%02d", $count);
  10.         $fMorning = "/var/www/spoa/nedwam/crb201205".$sCount."0700.png";
  11.         $fEvening = "/var/www/spoa/nedwam/crb201205".$sCount."1900.png";
  12.         echo $Fecha."\n".$fMorning."\n".$fEvening."\n";
  13.         $Img1_1 = @imagecreatefrompng($fMorning);
  14.         ob_start();
  15.         imagepng($Img1_1);
  16.         $Img1 = ob_get_contents();
  17.         ob_end_clean();
  18.         $Img1 = str_replace('##','##',mysql_escape_string($Img1));
  19.         $Img2_1 = @imagecreatefrompng($fEvening);
  20.         ob_start();
  21.         imagepng($Img2_1);
  22.         $Img2 = ob_get_contents();
  23.         ob_end_clean();
  24.         $Img2 = str_replace('##','##',mysql_escape_string($Img2));
  25.         mysql_query("SET NAMES 'utf8'", $link);
  26.         $result=mysql_query("UPDATE prediccionesdiarias SET Img1='".$Img1."', Img2='".$Img2."' WHERE Fecha='".$Fecha."' AND Prediccion='Altamar'",$link);
  27.  
  28. }
  29.  
  30. mysql_close($link);
  31.  
  32. // var_dump($argv);
  33. ?>
Add Comment
Please, Sign In to add comment