#!/usr/bin/php
<?php
$link=mysql_connect("localhost","evilla","evilla2010");
mysql_select_db("webmeteorologia",$link);
for ($count = 1; $count <= 13; $count++) {
$sCount = sprintf("%02d", $count+1);
$Fecha = "2012-5-".$sCount;
$sCount= sprintf("%02d", $count);
$fMorning = "/var/www/spoa/nedwam/crb201205".$sCount."0700.png";
$fEvening = "/var/www/spoa/nedwam/crb201205".$sCount."1900.png";
echo $Fecha."\n".$fMorning."\n".$fEvening."\n";
$Img1_1 = @imagecreatefrompng($fMorning);
ob_start();
imagepng($Img1_1);
$Img1 = ob_get_contents();
ob_end_clean();
$Img1 = str_replace('##','##',mysql_escape_string($Img1));
$Img2_1 = @imagecreatefrompng($fEvening);
ob_start();
imagepng($Img2_1);
$Img2 = ob_get_contents();
ob_end_clean();
$Img2 = str_replace('##','##',mysql_escape_string($Img2));
mysql_query("SET NAMES 'utf8'", $link);
$result=mysql_query("UPDATE prediccionesdiarias SET Img1='".$Img1."', Img2='".$Img2."' WHERE Fecha='".$Fecha."' AND Prediccion='Altamar'",$link);
}
mysql_close($link);
// var_dump($argv);
?>
Comments