How to Pre-select a Dropdown Option Using PHP and Database Values?

Selecting an Item in a Dropdown using PHP

In HTML, you can use the selected attribute to specify the pre-selected option in a dropdown. To achieve this using PHP, you need to dynamically set the selected attribute based on the value stored in the database.

The provided HTML code attempts to use the selected attribute by assigning a PHP variable, but it's not written correctly. To fix it:

<select>
  <option value="January" <?php print($row['month'] == 'January' ? 'selected' : ''); ?>>January</option>
  <option value="February" <?php print($row['month'] == 'February' ? 'selected' : ''); ?>>February</option>
  <option value="March" <?php print($row['month'] == 'March' ? 'selected' : ''); ?>>March</option>
  <option value="April" <?php print($row['month'] == 'April' ? 'selected' : ''); ?>>April</option>
</select>

This code uses a ternary operator to conditionally assign the selected attribute to the correct option. By comparing the database value with each possible month, it ensures that the corresponding option is pre-selected.

Alternatively, you can use an array of values and loop through it to generate the dropdown:

$months = ['January', 'February', 'March', 'April'];

echo '<select>';
foreach ($months as $month) {
  echo '<option value="' . $month . '" ' . ($row['month'] == $month ? 'selected' : '') . '>' . $month . '</option>';
}
echo '</select>';

This approach allows for greater flexibility in case you need to add or remove months in the future.

The above is the detailed content of How to Pre-select a Dropdown Option Using PHP and Database Values?. For more information, please follow other related articles on the PHP Chinese website!