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
| <?php
$hostname = "localhost";
$username = "root";
$password = "Mm101010";
$dbname = "smartphone";
$connect = new PDO("mysql:host=".$hostname.";dbname=".$dbname, $username, $password);
$options= "";
$query = $connect -> prepare("SELECT * FROM employe");
$query -> execute (array ());
$rows = $query -> fetchAll(PDO::FETCH_ASSOC);
?>
<select name="employes">
<option
value="Choisi un nom">
</option>
<?php
foreach ($employe ->fetchall() as $employe):
?>
<option
value=<?php echo $employe ['Or_Affectation']; ?>>"<?php echo $employe ['nom']; ?>
</option>
<?php endforeach; ?>
</select>
foreach ($rows as $row)
{
$options = $row[5];
}
?> |
Partager