duanniubeng2265 2016-11-20 13:12
浏览 464
已采纳

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

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?

  • 写回答

3条回答 默认 最新

  • doudun1934 2016-11-20 13:15
    关注

    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>';
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?