PHP foreach循环中如何用三元运算符设置下拉框选中值（从MySQL取值）

Hey there! Let's get that dropdown selection working with your MySQL-stored time value. The core issue here is comparing each generated time option against the value you fetched from the database, and using a ternary operator to toggle the selected attribute when they match.

Step 1: Fetch the Selected Time from MySQL #

First, make sure you've correctly retrieved the time value from your database. Double-check the format matches what you're generating for your dropdown options (e.g., H:i for 24-hour time like "09:30"):

// Example: Fetch from your MySQL query result
// Replace 'time_column' with your actual database column name
$selected_time = $database_row['time_column'];

// If your DB stores time with seconds (like "09:30:00"), convert it to match your options:
// $selected_time = date('H:i', strtotime($selected_time));

Step 2: Generate Your 30-Minute Interval Time Options #

Here's a reliable way to create those time slots (adjust start/end times as needed):

$start = strtotime('00:00');
$end = strtotime('23:30');
$time_slots = [];

while ($start <= $end) {
    $time_slots[] = date('H:i', $start);
    $start += 1800; // Add 30 minutes (1800 seconds)
}

Step 3: Build the Dropdown with Selected State #

Now use a foreach loop with the ternary operator to set the selected attribute when the current slot matches your database value:

<select name="appointment_time">
    <?php foreach ($time_slots as $slot): ?>
        <option 
            value="<?= $slot ?>" 
            <?= ($slot === $selected_time) ? 'selected' : '' ?>
        >
            <?= $slot ?>
        </option>
    <?php endforeach; ?>
</select>

Key Things to Double-Check #

• Format Consistency: Make sure $selected_time and each $slot use the exact same format (e.g., both "14:30" or both "2:30 PM" if using 12-hour time). Mismatched formats will break the comparison.
• Strict Comparison: Use === instead of == to avoid accidental matches from type coercion (e.g., a string vs. an integer).
• Variable Scope: Ensure $selected_time is accessible within the scope of your foreach loop (not trapped inside a function or if block where it can't be reached).

That should do it! When the page loads, the dropdown will automatically select the time stored in your MySQL database.

内容的提问来源于stack exchange，提问作者Dexter