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
|
<?php
$db2 = mysql_connect("localhost", "root", "");
if (!$db2)
{
echo "erreur: " . mysql_error();
exit;
}
if (!mysql_select_db("crm_fr",$db2))
{
echo "erreur: " . mysql_error();
exit;
}
$sql = "SELECT * FROM noms";
?>
<table>
<tr><td>
<form class="form" method="post" enctype="multipart/form-data" >
<select name="nr" style="background-color:red;color:#FFFFFF;margin: 10px 0px 0px 0px;" onchange="submit();">
<option class="noprint">Sélectionnez le numéro:</option>
<?php
$result=mysql_query($sql);
if (!$result)
{
echo "Impossible d'exécuter la requête ($sql) " . mysql_error();
exit;
}
if (mysql_num_rows($result) == 0) {
echo "Aucune ligne trouvée";
exit;
}
while ($record = mysql_fetch_array($result))
{
echo '<option>'.$record['NR'].'</option>';
}
echo "</select></form></td></tr></table>";
if (isset($_POST['nr'])) {
$sql = 'SELECT * FROM pharmacies WHERE NR = "'.$_POST['nr'].'"';
$req = mysql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
while ($donnees=mysql_fetch_array($req))
{
echo "<table class='conditionstable'>
<tr>
<td>".$donnees['Customer']."</td>
</tr>
<tr>
<td>APB: ".$donnees['NR']."</td>
</tr>
</table>
";
}}
else {
echo '';
}
?> |
Partager