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

Question

I have a database field country which I want to query and select that country option from a select element. Is there any way to do this without adding:

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

in every single option tag? As there are hundreds of country options. Here is a little example of the code. Thank you.

$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

Don't you have a list of all countries on your server?

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

You could do something like this:

$selection = "Some country";

echo "<select>";

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

echo "</select>";