1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
| <?php
$date = date("d/m/Y");
$heure = date("H:i");
Print("Nous sommes le $date et il est $heure");
$iddate=$date;
?>
<br><a href="abs_index.php">Accueil</a> <br>
<br><a href="toutesabsbis2dates.php">Afficher TOUTES les ABSENCES !</a> <br>
<form action="toutesabsbis2dates.php" method="post"><br>
<input type="text" name="motclef" value="<?php echo $_REQUEST['$motclef%']; ?>"><br>
<input type="text" name="date1" value="<?php echo $_REQUEST['$date1']; ?>">
<input type="text" name="date2" value="<?php echo $_REQUEST['$date2']; ?>">
<input type="submit" value="Rechercher une ABSENCE sur une DATE (format xx/xx/xxxx) ou sur le NOM (3 premières lettres) OU sur le Numéro ABSENCE">
</form>
<?php
if (isset($motclef))
{
$dateA = $date1;
$anneeA = substr($dateA, 6, 4);
$moisA = substr($dateA, 3, 2);
$jourA = substr($dateA, 0, 2);
echo $jourA . '-' . $moisA . '-' . $anneeA;
echo $anneeA . '/' . $moisA . '/' . $jourA;
$date3=$anneeA . '/' . $moisA . '/' . $jourA;
$dateB = $date2;
$anneeB = substr($dateB, 6, 4);
$moisB = substr($dateB, 3, 2);
$jourB = substr($dateB, 0, 2);
echo $jourB . '-' . $moisB . '-' . $anneeB;
echo $anneeB . '/' . $moisB . '/' . $jourB;
$date4=$anneeB . '/' . $moisB . '/' . $jourB;
$clause = " AND QUAND1 BETWEEN DATE_FORMAT('" . mysql_real_escape($_POST['date1']) . "','%d/%m/%Y') AND DATE_FORMAT('" . mysql_real_escape($_POST['date2']) . "','%d/%m/%Y')";
//$clause = " AND (QUAND1 between '$date3' and '$date4' or elenom like '$motclef%' or Numero='$motclef')";
}
//SELECT * FROM ges_abs WHERE `QUAND1` BETWEEN '2009-09-02' AND '2009-09-12' ORDER BY `elenom` ASC code:$clause = " AND (QUAND1 between '$date3' and '$date4' or elenom like '$motclef%' or Numero='$motclef')";
$orderby = " ORDER BY elenom";
//$sql = "SELECT * FROM ges_abs where JUST1='N' " . $clause . $orderby;
$sql = "SELECT * FROM ges_abs WHERE JUSTIFICATION ='N' " . $clause . $orderby;
$resultat = mysql_query ($sql);
$date=$motclef;
echo "<br>";
echo $date;
echo "<br>";
echo $sql;
while ($eleve = mysql_fetch_array ($resultat))
{
?> |
Partager