Small script that demonstrates how to populate a drop down list or menu with data retrieved from a database using PHP and MYSQL. Below I copy / pasted a sample data that I’m use as well as the MYSQL statement to query the database.
Drop down list
<form method="" name="testForm" id="testForm">
<label>drop down select </label>
<select name="user_list" >
<?php
foreach($get_userList as $user) {
echo '<option value=' . $user['index'] . '>' . $user['FirstName']." " .
$user['FirstName'] .'</option>';
}
?>
</select>
</form>
Database query
Try {
$stmt = $pdo->query('SELECT * FROM tb_testing');
$get_userList = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
catch(PDOException $e) {
echo $e->getMessage().'Unable to access table';
}
Sample data:
Array
(
[0] => Array
(
[user] => 1
[FirstName] => Trevor
[LastName] => Day
[Phone] => 1-392-702-0719
)
[1] => Array
(
[user] => 2
[FirstName] => Grady
[LastName] => Bradford
[Phone] => 1-815-569-6815
)
[2] => Array
(
[user] => 3
[FirstName] => Elmo
[LastName] => Willis
[Phone] => 1-192-945-6652
)
[3] => Array
(
[user] => 4
[FirstName] => September
[LastName] => Russo
[Phone] => 1-609-342-2362
)
[4] => Array
(
[user] => 5
[FirstName] => Sara
[LastName] => Mercado
[Phone] => 1-648-419-7298
)
good work.
ReplyDelete