HEX
Server: Apache
System: Linux iad1-shared-e1-19 6.6.49-grsec-jammy+ #10 SMP Thu Sep 12 23:23:08 UTC 2024 x86_64
User: austral3d (14892361)
PHP: 5.6.40
Disabled: NONE
Upload Files
File: /home/austral3d/fourdplan.com/php/actualizar_bd.php
<?php
//mysql_connect('sql.austral3d.com', 'austral3d', 'austral2015') or die('Could not connect: ' . mysql_error()); 
//mysql_select_db('fourdplan_datawarehouse') or die('Could not select database');

mysql_connect('localhost', 'root', '') or die('Could not connect: ' . mysql_error());	
mysql_select_db('fourdplan_datawarehouse') or die('Could not select database');
 	
$fecha = date("d") . "-" . date("m") . "-" . date("Y");

$consulta = mysql_query("select * from TablaProgramadoVsReal where fecha <= NOW()order by fecha desc");

$array = mysql_fetch_array($consulta);

//echo $array['id'];

//$actualizaDato = mysql_query("Update TablaProgramadoVsReal set ton_real = 0 where id = '".$array['id']."'");

mysql_select_db('fourdplan') or die('Could not select database');

$consultaA = mysql_query("select fecha_planificacion, fecha_preparacion_material,fecha_armado, fecha_soldadura, fecha_granallado, fecha_pintura, fecha_liberacion, fecha_despacho from instancia");


?>