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
|
if (isset($_POST['nom'])) {
$colnom_rsEtudiantAND = (get_magic_quotes_gpc()) ? $_POST['nom'] : addslashes($_POST['nom']);
}
if (!($_POST['nom'])) {
$colnom_rsEtudiantAND = "%";
}
if (isset($_POST['prenom'])) {
$colprenom_rsEtudiantAND = (get_magic_quotes_gpc()) ? $_POST['prenom'] : addslashes($_POST['prenom']);
}
if (!($_POST['prenom'])) {
$colprenom_rsEtudiantAND = "%";
}
if (isset($_POST['promotion'])) {
$colpromotion_rsEtudiantAND = (get_magic_quotes_gpc()) ? $_POST['promotion'] : addslashes($_POST['promotion']);
}
if (!($_POST['promotion'])) {
$colpromotion_rsEtudiantAND = "%";
}
if (!$_POST['nom'] AND !$_POST['prenom'] AND !$_POST['promotion']) {
$colnom_rsEtudiantAND = "";
$colprenom_rsEtudiantAND = "";
$colpromotion_rsEtudiantAND = "";
}
mysql_select_db($database_ConnexionStages, $ConnexionStages);
$query_rsEtudiantAND = sprintf("SELECT etudiant.nom, etudiant.prenom, etudiant.promotion, etudiant.ID FROM etudiant WHERE etudiant.nom LIKE '%s' AND etudiant.prenom LIKE '%s' AND etudiant.promotion LIKE '%s' ORDER BY etudiant.nom", $colnom_rsEtudiantAND,$colprenom_rsEtudiantAND,$colpromotion_rsEtudiantAND);
$rsEtudiantAND = mysql_query($query_rsEtudiantAND, $ConnexionStages) or die(mysql_error());
$row_rsEtudiantAND = mysql_fetch_assoc($rsEtudiantAND);
$totalRows_rsEtudiantAND = mysql_num_rows($rsEtudiantAND); |
Partager