re recherche : <form method="post" action="stock.php"> </form>
if (isset($_POST['bouton']) && isset($_POST['search'])) {comme ça la requete mysql et le traitement de cette requete ne s'effectueront que si tu as cliqué et remplis le champ !
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionVotre recherche : <form method="post" action="stock.php"> </form> <?php $serveur = mysql_connect("127.0.0.1","root","****"); mysql_select_db('société', $serveur); if ( ! $serveur ) die ("connexion impossible"); if (isset($_POST['bouton']) && !empty($_POST['search'])) { $button = $_POST['bouton']; $recherche = $_POST['search']; $sql = "SELECT * FROM `stock` WHERE 'Item' LIKE '%". $recherche ."%'" ; $resultat = mysql_query($sql); while ($data = mysql_fetch_array($resultat)) { echo " <center> "; echo $data['Item']; echo ", "; echo $data['Description']; echo ", ---- "; echo $data['Quantity']; echo ", "; echo $data['Price']; echo ", ---- "; echo $data['Currency']; echo " </center> "; } } ?>
if (isset($_POST['bouton']) && !empty($_POST['search'])) { $button = $_POST['bouton']; $recherche = $_POST['search'];
if (isset($_POST['bouton']) && !empty( trim($_POST['search']) ))
while ($data = mysql_fetch_array($resultat)) { echo " <center> "; ... echo " </center> "; }
echo " <center>"; echo "\"; while ($data = mysql_fetch_array($resultat)) { echo\"---- "; ... echo ", \"; } echo" </center> "; }
if (isset($_POST['bouton']) && !empty( trim($_POST['search']) )) {
if (isset($_POST['bouton']) && isset($_POST['search'])) { if(!empty(trim($_POST['search'])) { $recherche = $_POST['search']; } else { exit(); }
if (isset($_POST['bouton']) && isset($_POST['search'])) { $temp = trim($_POST['search']); if(!empty($temp) && $temp != '' ) { $recherche = $_POST['search']; $recherche = strips_tag($recherche); } else { exit(); }