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
| <form s method="POST" name='recherche' >
Saisissez l'adresse
<input type="text" border="1" name="recherche" size="20" value="<?=((isset($_POST['recherche']))?$_POST['recherche']:"");?>">
<input type="submit" value="rechercher" >
</form>
<?
if (((isset($_POST['recherche']))?($_POST['recherche']!=""):"")) { $recup=$_POST['recherche'];
$r_cpt_result = mysql_query("select COUNT(*) FROM ressource where adresse like '%".$recup."%'");
$t_cpt_result = mysql_fetch_array($r_cpt_result);
echo "nombre de résultat=".$t_cpt_result['COUNT(*)'];
if ($t_cpt_result['COUNT(*)']>0) {
$res=mysql_query("select * FROM ressource where adresse like '%".$recup."%'");
WHILE ($t = mysql_fetch_array($res)) {
echo '<table>';
echo "<tr>
<td> ADRESSE IP : ",$t["adresse"],"<br>";
echo "NOM: ",$t["nom"],"<br>";
echo "PRENOM: ";
$r_lt_name= mysql_query("select * FROM `lt` where ind = ".$t["prenom"]);
WHILE ($t_lt_name = mysql_fetch_array($r_lt_name)) {
echo $t_lt_name['prenom'];
}
echo "<br>";
echo "</td> </tr> </table>";
}//fin du while
} // fin du if ($t_cpt_result['COUNT(*)']>0) }
?> |