php - 使用php从选择元素中选择选项

Question

我有一个数据库字段country，我想查询并从选择元素中选择该国家/地区选项。有没有办法在不添加的情况下做到这一点:

if (query->country == "<some country>"){echo "selected"} 

在每个选项标签中？因为有数百个国家/地区可供选择。这是代码的一个小示例。谢谢。

$query = $query->fetch_object();

// which ever country is held in the variable `$query->country` should be selected

echo"<select>
       <option>Afghanistan</option>
       ......
       ......
       <option>Zimbabwe</option>
     </select>"; 

Answer 1

您的服务器上没有所有国家/地区的列表吗？

$countries = ["Afghanistan", ... , "Zimbabwe"];

你可以这样做:

$selection = "Some country";

echo "<select>";

foreach($countries as $country)
{
    if($country == $selection)
        echo "<option selected>" . $country . "</option>";
    else
        echo "<option>" . $country . "</option>";
}

echo "</select>";