MySQL数据库中预先选择的下拉列表值

Question

Though I have researched, I couldn't find any solution for this. I need to get the database value ("Default") as the pre-selected value of the drop down list.

<select name="listCustomer" id="listCustomer">
    <?php 
    $sql = mysqli_query($connection,"SELECT customer_name FROM customers");
    while ($row = mysqli_fetch_array($sql,MYSQLI_ASSOC)){
    echo "<option value=\"" .   $row['customer_name'] . "\">" . $row['customer_name'] . "</option>";}
    ?>
</select>

Can you please help me on this?

Answer 1

Just create a variable before the echo, something like:

$selected = ((strtolower($row['customer_name']) == 'default') ? 'selected' : '');

then change the echo to this:

echo '<option '.$selected.' value="'.$row['customer_name'].'">'.$row['customer_name'].'</option>';