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?
虽然我已经研究过，但我找不到任何解决办法。 我需要将数据库值（“Default”）作为下拉列表的预选值。
＆lt; select name =“listCustomer”id =“listCustomer “＆gt;
＆lt;？php
$ sql = mysqli_query（$ connection，”SELECT customer_name FROM customers“）;
while（$ row = mysqli_fetch_array（$ sql，MYSQLI_ASSOC））{
echo”＆lt; option value = \“”。$ row ['customer_name']。“\”＆gt;“ 。 $ row ['customer_name']。 “＆lt; / option＆gt;”;}
？＆gt;
＆lt; / select＆gt;
您可以帮我解决这个问题吗？ \ n
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>';
This can be accomplished using an if statement on the customer_name
$sql = mysqli_query($connection,"SELECT customer_name FROM customers");
while ($row = mysqli_fetch_array($sql,MYSQLI_ASSOC)){
if($row["customer_name"] === "Default"){
echo "<option value=\"" . $row['customer_name'] . "\" selected>" . $row['customer_name'] . "</option>";
} else {
echo "<option value=\"" . $row['customer_name'] . "\">" . $row['customer_name'] . "</option>";
}
}
?>
Note the selected tag on the first echo.
$query="SELECT customer_name FROM customers";
$result = @mysql_query ($query);
echo "<select name=customer_name value=' '>";
while($drop=@mysql_fetch_array($result)){
echo "<option value=$drop[customer_name]>$drop[customer_name]</option>";
}
echo "</select>";