Ce script ne fonctionne pas et impossible de savoir ce qui cloche alors que la connexion a la BDD et ok
J'ai suivie plusieurs pistes mais la je ne comprend pas
Merci pour votre aide
<?php
error_reporting(E_ALL|E_STRICT);
$user = "xxxx";
$password = "xxxxxx";
$database = "xxxxxx";
$host = "xxxx";
$date = gmdate("Y-m-d");
$del = gmdate("Y-m-d", mktime(0,0,0,date("m"),date("d")-370,date("Y")));
echo "Suppression des expedition anterieures au $del";
mysql_connect($host, $user, $password);
$ok = mysql_db_query ($database, "delete from histo where date < '$del' " );
mysql_close();
$fp = fopen("upload/netexp.txt", "r");
while (!feof ($fp))
{
$enr = fgets($fp, 256);
$forcli = substr($enr, 0, 6);
$fordate = substr($enr, 7, 10);
$forrecep = substr($enr, 18, 6);
$forind = substr($enr, 25, 2);
$desti1 = substr($enr, 28, 9);
$desti2 = substr($enr, 77, 15);
$fordesti = "$desti1"."$desti2";
$fordept = substr($enr, 38, 2);
$forville = substr($enr, 41, 15);
$forcol = substr($enr, 57, 4);
$forsit = " ";
$ford2 = " ";
$forret = " ";
$forurl=" ";
$forref = substr($enr, 99, 16);
$cha1 = " 'codecli' , 'date' , 'recep' , 'indice' , ";
$cha2 = " 'desti' , 'dept' , 'ville' , 'nbcolis' , 'situation' , ";
$cha3 = " 'datesituation' , 'dateretour' , 'reference' , 'urlemarge' " ;
$champs = " $cha1 $cha2 $cha3 ";
$val1 =" '$forcli', '$fordate', '$forrecep', '$forind', " ;
$val2 =" '$fordesti', '$fordept', '$forville', '$forcol', " ;
$val3 =" '$forsit', '$ford2', '$forret' , '$forref' , '$forurl' " ;
$val = " $val1 $val2 $val3 " ;
$forcode = substr ($enr, 116, 1);
$si1 = " date = '$fordate' and recep = '$forrecep' and indice = '$forind' ";
mysql_connect($host, $user, $password);
$result = mysql_db_query ($database, "select * from histo where $si1 ");
$nb = mysql_num_rows($result);
if ($nb <> 0 )
{echo " $nb-" ;
$del = mysql_db_query ($database, "delete from histo where $si1 ");}
mysql_close();
echo " $forcode $forcli $forrecep ";
if ( $forcode == "C" )
{ mysql_connect($host, $user, $password);
$ok = mysql_db_query ($database, "insert into histo values ( $val ) ");
echo " creation de $forcode $forcli $forrecep ";
mysql_close(); }
}
fclose($fp);
?>