<?
include "connect.php";


//on supprime les messages périmés de la page d'accueil
// bandeau rouge, news, admin
mysql_query("delete from msgAccueil where validite < '".date("Y-m-d")."'");

// bandeau menu
mysql_query("delete from menu where dateMenu < '".date("Y-m-d")."'");

// documents périmés
$result=mysql_query("select emplctPhysique from document where datePerime < '".date("Y-m-d")."' and definitif=1");
while ($ligne=mysql_fetch_row($result))
unlink($ligne[0]);
mysql_query("delete from document where datePerime < '".date("Y-m-d")."' and definitif=1");

//Suppression evenement
mysql_query("Delete from evenement where datef<'".date("Y-m-d")."'");

//recherche du message PSIAT du jour
//on contrôle l'existence du msg dans la session
if (isset($_COOKIE["psiat"])==false)
{
$psiat=mysql_query("SELECT * FROM psiat where derniereDate='".date('Y-m-d')."' order by nbreLecture asc");
if ($lignePSIAT=mysql_fetch_row($psiat)) //il y a un résultat pour la date d'aujourd'hui
{
setcookie("psiat", $lignePSIAT[1], time()+(3600*12));
}
else
{
//il n'y a pas de résultat pour la date d'aujourd'ui
$psiat=mysql_query("SELECT * FROM psiat order by nbreLecture,texteRegle asc");
//on sélectionne le premier enregistrement qui a été le moins lu
$lignePSIAT=mysql_fetch_row($psiat);
setcookie("psiat", $lignePSIAT[1], time()+(3600*12));
mysql_query("UPDATE psiat set nbreLecture=".($lignePSIAT[2]+1)." ,derniereDate='".date('Y-m-d')."' where numRegle='".$lignePSIAT[0]."'");
}
}
?>

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\Portail4\BD\nettoyageBase.php on line 14

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\Portail4\BD\nettoyageBase.php on line 26

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\Portail4\BD\nettoyageBase.php on line 35

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\Portail4\BD\nettoyageBase.php:14) in C:\xampp\htdocs\Portail4\BD\nettoyageBase.php on line 36

/7 documents périmés
$result=mysql_query("select emplctPhysique from document where datePerime < '".date("Y-m-d")."' and definitif=1");
while ($ligne=mysql_fetch_row($result))
unlink($ligne[0]);
mysql_query("delete from document where datePerime < '".date("Y-m-d")."' and definitif=1");

$la_date = date("Y-m-d");
$requete = "select emplctPhysique from document where datePerime < $la_date and definitif=1";
print "$requete";
$result = mysql_query($requete);
if ($result === false)
{
      echo mysql_error; 
}
else
{
     while ($ligne=mysql_fetch_row($result))
     {
           $nom_fic = $ligne[0];
           unlink($nom_fic);
      }
}