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
| //------------------- Connection à la base de données -------------------------
$serveur = mysql_connect('localhost', 'root', '');
mysql_select_db('biomediqa');
// ------------------------------------------ Choix de l'utilisateur -------------------------------
print "<Form action='Page_principale.php' method = 'POST'>";
print "<fieldset>";
$query = "SELECT ID, user_name FROM users Order by user_name";
$res = mysql_query($query);
print "<b><Font Size = 5><legend> Sélectionner l'utilisateur </legend>".'<BR>'.'<BR>';
print "<Select name ='liste_utilisateurs' onchange ='submit()'>";
while ($ligne = mysql_fetch_row($res))
{
IF ($ligne[0]==$_POST['liste_utilisateurs']) print "<Option value = '$ligne[0]' selected> $ligne[1]</Option>";
else print "<Option value = '$ligne[0]' > $ligne[1] </Option>";
}
print "</Select>";
$query = "SELECT ID, user_name, title, department FROM users WHERE ID ='".$_POST['liste_utilisateurs']."' ";
$res = mysql_query($query);
print "<TABLE border =0>";
$ligne = mysql_fetch_row($res);
print "<TR><TD> ID </TD> <TD> </TD> <TD> <b>$ligne[0] </TD></TR>
<TR><TD> user name </TD> <TD> </TD> <TD> <b>$ligne[1] </TD></TR>
<TR><TD> title </TD> <TD> </TD> <TD> <b>$ligne[2] </TD></TR>
<TR><TD> department </TD> <TD> </TD> <TD> <b>$ligne[3] </TD></TR>";
print "</TABLE>";
print "</fieldset>"; |
Partager