function search_for($recherche, $recherche2, $recherche3) { $sql = 'SELECT * FROM `facture` WHERE `Customer Name` LIKE \'%'. $recherche .'%\' OR Item LIKE \'%'. $recherche2 .'%\' OR `Customer Number` LIKE \'%'. $recherche3 .'%\'' ; $resultat = mysql_query($sql) or die(' Req :' .$sql .''. mysql_error()); $nbr_resultat=mysql_num_rows($resultat); if($nbr_resultat==0) { ?> Aucun résultat trouvé pour "<?php echo $recherche." ".$recherche2." ".$recherche3; ?>" <?php } else { echo " "; echo "\"; echo ('---- customer Name |</td>Invoice Number |, Item |, Quantity |, Item Description |, , Sales Order Number |, Fonctional Amount |, Currency |'); while ($data = mysql_fetch_array($resultat)) { echo"----, \"; echo $data['Customer Name'].'</td>'.', '; echo $data['Invoice Number'].', '.', '; echo $data['Item'].', '.', '; echo $data['Quantity Invoiced'].', '.', '; echo $data['Item Description'].', '.', '.', '; echo $data['Sales Order Number'].', '.', '; echo $data['Functional Amount'].', '.', '; echo $data['Currency']; echo ", \"; } { echo " "; } } } ?>
function search_for($recherche, $recherche2, $recherche3) { $or= ""; if($recherche!="") { $recherche=" `Customer Name` LIKE \'%". $recherche ."%\'"; } else { $recherche=""; } if($recherche2!="") { if($recherche!="") { $or=" OR "; } $recherche2=$or." `Item` LIKE \'%". $recherche2 ."%\'"; } else { $recherche2=""; } if($recherche3!="") { if($recherche2!="") { $or=" OR "; } $recherche3=$or." `Customer Number` LIKE \'%". $recherche3 ."%\'"; } else { $recherche3=""; } $sql = "SELECT * FROM facture WHERE ". $recherche . $recherche2 . $recherche3; $resultat = mysql_query($sql) or die(' Req :' .$sql .''. mysql_error()); $nbr_resultat=mysql_num_rows($resultat); if($nbr_resultat==0) { ?> Aucun résultat trouvé pour "<?php echo $recherche." ".$recherche2." ".$recherche3; ?>" <?php } else { echo " "; echo "\"; echo ('---- customer Name |</td>Invoice Number |, Item |, Quantity |, Item Description |, , Sales Order Number |, Fonctional Amount |, Currency |'); while ($data = mysql_fetch_array($resultat)) { echo"----, \"; echo $data['Customer Name'].'</td>'.', '; echo $data['Invoice Number'].', '.', '; echo $data['Item'].', '.', '; echo $data['Quantity Invoiced'].', '.', '; echo $data['Item Description'].', '.', '.', '; echo $data['Sales Order Number'].', '.', '; echo $data['Functional Amount'].', '.', '; echo $data['Currency']; echo ", \"; } { echo " "; } } } ?>
function search_for($recherche, $recherche2, $recherche3) { $or= ""; if($recherche!="") { $crtitere1=" `Customer Name` LIKE \'%". $recherche ."%\'"; } else { $crtitere1=""; } if($recherche2!="") { if($recherche!="") { $or=" OR "; } $crtitere2=$or." `Item` LIKE \'%". $recherche2 ."%\'"; } else { $crtitere2=""; } if($recherche3!="") { if($recherche2!="") { $or=" OR "; } $crtitere3=$or." `Customer Number` LIKE \'%". $recherche3 ."%\'"; } else { $crtitere3=""; } $sql = "SELECT * FROM facture WHERE ".$crtitere1.$crtitere2.$crtitere3; $resultat = mysql_query($sql) or die(' Req :' .$sql .''. mysql_error()); $nbr_resultat=mysql_num_rows($resultat); if($nbr_resultat==0) { ?> Aucun résultat trouvé pour "<?php echo $recherche." ".$recherche2." ".$recherche3; ?>" <?php } else { echo " "; echo "\"; echo ('---- customer Name |</td>Invoice Number |, Item |, Quantity |, Item Description |, , Sales Order Number |, Fonctional Amount |, Currency |'); while ($data = mysql_fetch_array($resultat)) { echo"----, \"; echo $data['Customer Name'].'</td>'.', '; echo $data['Invoice Number'].', '.', '; echo $data['Item'].', '.', '; echo $data['Quantity Invoiced'].', '.', '; echo $data['Item Description'].', '.', '.', '; echo $data['Sales Order Number'].', '.', '; echo $data['Functional Amount'].', '.', '; echo $data['Currency']; echo ", \"; } { echo " "; } } } ?>
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question$crtitere1=" `Customer Name` LIKE '%". $recherche ."%'"; $crtitere2=$or." `Item` LIKE '%". $recherche2 ."%'"; $crtitere3=$or." `Customer Number` LIKE '%". $recherche3 ."%'";
if($recherche3!="") { if($recherche2!="" || $recherche!="") { $or=" OR "; } $crtitere3=$or." `Customer Number` LIKE \'%". $recherche3 ."%\'"; }
<form name= "form1" method="post" action=""> client Produit : Numéro de commande : </form> <?php $serveur = mysql_connect("127.0.0.1","root",""); if(!mysql_select_db('societe', $serveur)); if(isset($_POST['texte']) OR isset($_POST['texte2']) OR isset($_POST['texte3'])) { $temp = $_POST['texte']; $temp2 = $_POST['texte2']; $temp3 = $_POST['texte3']; } else { $temp = ''; $temp2 = ''; $temp3 = ''; } if((!empty($temp) && $temp != '') OR (!empty($temp2) && $temp2 != '') OR (!empty($temp3) && $temp3 != '')) { $recherche = $temp; $recherche2 = $temp2; $recherche3 = $temp3; $recherche = strip_tags($recherche); $recherche2 = strip_tags($recherche2); $recherche3 = strip_tags($recherche3); search_for($recherche, $recherche2, $recherche3); } else { echo('merci de rentrer un critère'); } function search_for($recherche, $recherche2, $recherche3) { $or=""; if($recherche!="") { $crtitere1=" `Customer Name` LIKE '%". $recherche ."%'"; } else { $crtitere1=""; } if($recherche2!="") { if($recherche!="") { $or=" AND "; } $crtitere2=$or." `Item` LIKE '%". $recherche2 ."%'"; } else { $crtitere2=""; } if($recherche3!="") { if($recherche2!="" || $recherche!="") { $or=" AND "; } $crtitere3=$or." `Customer Number` LIKE '%". $recherche3 ."%'"; } else { $crtitere3=""; } $sql = 'SELECT * FROM `facture` WHERE' .$crtitere1.$crtitere2.$crtitere3; $resultat = mysql_query($sql) or die(' Req :' .$sql .''. mysql_error()); $nbr_resultat=mysql_num_rows($resultat); if($nbr_resultat==0) { ?> Aucun résultat trouvé pour "<?php echo $recherche." ".$recherche2." ".$recherche3; ?>" <?php } else { echo " "; echo "\"; echo ('---- customer Name |</td>Invoice Number |, Item |, Quantity |, Item Description |, , Sales Order Number |, Fonctional Amount |, Currency |'); while ($data = mysql_fetch_array($resultat)) { echo"----, \"; echo $data['Customer Name'].'</td>'.', '; echo $data['Invoice Number'].', '.', '; echo $data['Item'].', '.', '; echo $data['Quantity Invoiced'].', '.', '; echo $data['Item Description'].', '.', '.', '; echo $data['Sales Order Number'].', '.', '; echo $data['Functional Amount'].', '.', '; echo $data['Currency']; echo ", \"; } { echo " "; } } } ?>