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 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>resultats</title>
</head>
</head>
<body>
<?php
include('include/connection.php');
$raison = $_GET['raison_sociale'];
$dirige = $_GET['dirigeant'];
$adresse = $_GET['adresse'];
$cp = $_GET['cp'];
$region = $_GET['region'];
$ville = $_GET['ville'];
$telephone = $_GET['tel'];
$telecopie = $_GET['telecopie'];
$email = $_GET['email'];
$email2 = $_GET['email2'];
$code_naf = $_GET['code_naf'];
$libelle_naf = $_GET['libelle_naf'];
$rubrique_professionnelle = $_GET['rubrique_professionnelle'];
echo "<b><br />
Raison sociale = $raison <br />
dirigeant = $dirige \n </b> <br/>";
$requete = "
SELECT raison_sociale, dirigeant, adresse, cp, region, ville, tel, telecopie, email, email2, code_naf, libelle_naf, rubrique_professionnelle
FROM liste
WHERE `raison_sociale` LIKE '%$raison%'
OR dirigeant LIKE '%$dirige%'
OR adresse LIKE '%$adresse%'
OR cp LIKE '%$cp%'
OR region LIKE '%$region%'
OR ville LIKE '%$ville%'
OR tel LIKE '%$telephone%'
OR telecopie LIKE '%$telecopie%'
OR email LIKE '%$email%'
OR email2 LIKE '%$email2%'
OR code_naf LIKE '%$code_naf%'
OR libelle_naf LIKE '%$libelle_naf%'
OR rubrique_professionnelle LIKE '%$rubrique_professionnelle%'";
//echo $requete, $requete2;
$connexion = mysql_pconnect (localhost,Lucas,bonomi);
mysql_select_db (lucas, $connexion);
$resultat = mysql_query ($requete, $connexion) OR die("<br />
Erreur SQL : $query<br/>".mysql_error());
while ( ($clients = mysql_fetch_array ($resultat)))
{
?>
<td><?php echo $clients['ID']; ?></td>
<td><?php echo $clients['raison_sociale'];?></td>
<td><?php echo $clients['dirigeant']; ?></td>
<td><?php echo $clients['adresse']; ?></td>
<td><?php echo $clients['cp']; ?></td>
<td><?php echo $clients['ville']; ?></td>
<td><?php echo $clients['tel']; ?></td>
<td><?php echo $clients['telecopie']; ?></td>
<td><?php echo $clients['email']; ?></td>
<td><?php echo $clients['email2']; ?></td>
<td><?php echo $clients['code_naf']; ?></td>
<td><?php echo $clients['libelle_naf']; ?></td>
<td><?php echo $clients['rubrique_professionnelle']; ?></td>
<br />
<?php } ?><br /><br />
<?php echo $requete ?>
</body>
</html> |
Partager