<?php require_once('Connections/connection.php'); ?> <?php $colname_Recordset1 = "1"; if (isset($_POST['type'])) { $colname_Recordset1 = (get_magic_quotes_gpc()) ? $_POST['type'] : addslashes($_POST['type']); } mysql_select_db($database_connection, $connection); $query_Recordset1 = sprintf("SELECT * FROM administrateur WHERE type LIKE '%%%s%%'", $colname_Recordset1); $Recordset1 = mysql_query($query_Recordset1, $connection) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title> LA RECHERCHE DES ATS </title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <style type="text/css"> <!-- .style1 {color: #330033} .style2 {color: #000000} body { background-image: url(); background-color: #CCFFFF; } .style3 { color: #330033; font-style: italic; font-weight: bold; } --> </style> </head> Pour réeinitialiser la recherche des ATS cliquer[impats1.html ICI] <?php if ($totalRows_Recordset1 > 0) { // Show if recordset not empty ?> <?php } // Show if recordset not empty ?> <?php if ($totalRows_Recordset1 == 0) { // Show if recordset empty ?> <form name="form1" method="post" action=""> Aucun ATS <?php echo $_POST['type']; ?> existe! </form> <?php } // Show if recordset empty ?> Nom, Prenom, Grade, Type, Action, <?php do { ?> ---- <?php echo $row_Recordset1['nom']; ?>, <?php echo $row_Recordset1['prenom']; ?>, <?php echo $row_Recordset1['grade']; ?>, <?php echo $row_Recordset1['type']; ?>, Afficher/Imprimer, <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?> </html> <?php mysql_free_result($Recordset1); ?>
$query_Recordset1 = sprintf("SELECT * FROM administrateur WHERE type LIKE '%%%s%%'", $colname_Recordset1);
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question