What is the purpose of "Auto Populate Select Box" in PHP?

The purpose of "Auto Populate Select Box" in PHP is to dynamically populate a dropdown select box with options retrieved from a database or another data source. This allows for a more user-friendly and efficient way of selecting options without the need for manual input. 

<?php
// Connect to database
$pdo = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');

// Retrieve data from database
$stmt = $pdo->query('SELECT id, name FROM options');
$options = $stmt->fetchAll(PDO::FETCH_ASSOC);

// Populate select box
echo '<select name="options">';
foreach ($options as $option) {
    echo '<option value="' . $option['id'] . '">' . $option['name'] . '</option>';
}
echo '</select>';
?>

Keywords

PHP Auto Populate Select Box Form AJAX Database

Related Questions