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
| <?php
if(isset($_POST['test']) && $_POST['test'] =="ok" ){
$query1 = "SELECT ID_MEMBRE, ID_RUBRIQUE , NOM , PRENOM , RAISON_SOCIALE , VILLE ,COMMUNE ,QUARTIER , APOSTALE , TELFIXE , TELPORT , FAX , EMAIL , SITE_INTERNET , INFORMATION , A_PAYER FROM membre where id_membre <> 0 ";
//echo "toto".$query1;
if(isset($_POST['rub']) && $_POST['rub'] !="0" ){
$query1 = $query1." and id_rubrique = ".$_POST['rub'];
//echo " <br>totorub ".$query1;
}
if(isset($_POST['rs']) && $_POST['rs'] !="" ){
$query1 =$query1." and RAISON_SOCIALE like '%".$_POST['rs']."%' ";
}
if(isset($_POST['nom']) && $_POST['nom'] !="" ){
$query1 =$query1." and NOM like '%".$_POST['nom']."%' ";
}
if(isset($_POST['ville']) && $_POST['ville'] !="" ){
$query1 =$query1." and ville like '%".$_POST['ville']."%' ";
}
if(isset($_POST['COMMUNE']) && $_POST['commune'] !="" ){
$query1 =$query1." and commune like '%".$_POST['commune']."%' ";
}
$query1 = $query1." order by 1 ;";
}
//echo $query1;
$result1=mysql_query($query1);
while($tableau=mysql_fetch_array($result1))// la ligne qui pose pbe
{
$id = $tableau['ID_MEMBRE'];
$rub = $tableau['ID_RUBRIQUE'];
$nom = $tableau['NOM'];
$prenom = $tableau['PRENOM'];
$titre = $tableau['TITRE'];
$rs = $tableau['RAISON_SOCIALE'];
$ville = $tableau['VILLE'];
$commune = $tableau['COMMUNE'];
$quartier = $tableau['QUARTIER'];
$apostale = $tableau['APOSTALE'];
$telfixe = $tableau['TELFIXE'];
$telport = $tableau['TELPORT'];
$fax = $tableau['FAX'];
$email = $tableau['E_MAIL'];
$siteinternet = $tableau['SITE_INTERNET'];
$information = $tableau['INFORMATION'];
$choix = $tableau['CHOIX'];
/*
echo("<br/>"<table><tbody><tr><th>NOM :</th><td>".$nom."</td></tr> <tr><th>Prenom:</th><td>".$prenom."</td></tr> <tr><th>Commune :</th><td>".$commune."</td></tr> <tr><th>Quartier :</th><td>".$quartier."</td></tr> <tr><th>APostale :</th><td>".$apostale."</td></tr> <tr><th>TelFixe :</th><td>".$telfixe."</td></tr><tr><th>TelPort :</th><td>.$telport.</td></tr> <tr><th>Fax :</th><td>.$fax.</td></tr> </tbody></table>
*/
echo("<br/>".$nom." - ".$prenom." - ".$titre." - ".$ville." - ".$commune." - ".$quartier." - ".$apostale." - ".$telfixe." - ".$telport." - ".$fax." - ".$email." - ".$siteinternet." - ".$information." - ".$choix." - ".$rs." ( ".$rub." )");
}
?> |
Partager