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 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
| <?php
//Connexion a la base de donnée
connectMaBase();
// on crée la requête SQL
$sql = 'SELECT *,DATE_FORMAT(`DATE`,\'%d-%m-%Y\') AS date_fr FROM `intervention` WHERE 1=1 ';
if (!empty($_POST['tech']))
$sql.= " AND `Nom` LIKE '".mysql_real_escape_string($_POST['tech'])."' ";
if (!empty($_POST['machine']))
$sql.= " AND `Machine` LIKE '".mysql_real_escape_string($_POST['machine'])."' ";
if (!empty($_POST['technique']))
$sql.= " AND `Technique` LIKE '".mysql_real_escape_string($_POST['technique'])."' ";
if (!empty($_POST['LouK']))
$sql.= " AND `Traitement` LIKE '".mysql_real_escape_string($_POST['LouK'])."' ";
if (!empty($_POST['Colleuse']))
$sql.= " AND `Traitement` LIKE '".mysql_real_escape_string($_POST['Colleuse'])."' ";
if (!empty($_POST['mecanique']))
$sql.= " AND `Traitement` LIKE '".mysql_real_escape_string($_POST['mecanique'])."' ";
if (!empty($_POST['dosage']))
$sql.= " AND `Traitement` LIKE '".mysql_real_escape_string($_POST['dosage'])."' ";
if (!empty($_POST['date'])) {
$date = $_POST['date'];
$date = explode("-", $date);
$newsdate=$date[2].'-'.$date[1].'-'.$date[0];
echo $newsdate;
$sql.= " AND `DATE` LIKE '".mysql_real_escape_string($newsdate)."' "; }
// on envoie la requête
$req = mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
while($result = mysql_fetch_array($req)) {
if ($result['Nom'] == "") {
$result['Nom'] = "Non Specifie" ;
}
if ($result['Machine'] == "") {
$result['Machine'] = "Non Specifie" ;
}
if($result['Technique'] == "") {
$result['Technique'] = "Non Specifie" ;
}
if($result['Traitement'] == "") {
$result['Traitement'] = "Non Specifie" ;
}
if($result['Commentaire'] == "") {
$result['Commentaire'] = "Non Specifie" ;
}
echo '<TR>' ;
echo'<TD>'.$result['Nom'].'</TD>';
echo'<TD>'.$result['Machine'].'</TD> ';
echo'<TD>'.$result['Technique'].'</TD> ';
echo'<TD>'.$result['Traitement'].'</TD> ';
echo'<TD></TD> ';
echo'<TD></TD> ';
echo'<TD></TD> ';
echo'<TD>'.$result['Commentaire'].'</TD> ';
echo'<TD>'.$result['date_fr'].'</TD> ';
echo'<TD>'.$result['Heure'].'</TD>';
echo'</TR> ';
} |