How can PHP beginners effectively utilize while loops to fetch and display data from a database in a select field?

To fetch and display data from a database in a select field using while loops in PHP, beginners can query the database to retrieve the data, then use a while loop to iterate over the results and populate the select field options with the fetched data. 

<?php
// Connect to the database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Check connection
if (!$connection) {
    die("Connection failed: " . mysqli_connect_error());
}

// Query to fetch data from database
$query = "SELECT id, name FROM table_name";
$result = mysqli_query($connection, $query);

// Display select field with fetched data
echo "<select>";
while ($row = mysqli_fetch_assoc($result)) {
    echo "<option value='" . $row['id'] . "'>" . $row['name'] . "</option>";
}
echo "</select>";

// Close database connection
mysqli_close($connection);
?>

Keywords

PHP while loop database fetch data select field

Related Questions