从数据库编辑时如何填充单选按钮或下拉框？

Question

I know this is a similar question to one already asked, but I was hoping for a different answers to a problem. I have a form where you can upload new articles to a database all fine works ace, wonderful, brill. The form uses a drop down menu for the type of article, I have news, gossip, travel, performances and others in my drop down box. When you upload to the db it's only going to add the selected item let's say, in this case, News.

I need the user to be able edit their articles, so I need to populate the drop down box with the selected item. I think it's a bit of a pain in the BUM to set up a database table with each of the drop items and an ID for them. Is there away of setting the selected item as value in the db, and then just using a if statement or something to populate the rest of the drop down box?

Hope that makes sense. I also thought use of a radio buttons could be a solution however I cant get that to set the selected button with the value in the db.

Answer 1

You could do something like this:

// array of available options
$available = array('news'=>'News', 'gosip'=>'Gosip', 'travel'=>'Travel', 'performances'=>'Performance');
// selected option value
$selected = 'news';
echo '<select name="article-type">';
foreach ($available as $val => $label) {
    echo '<option value="'.htmlspecialchars($val).'"';
    if ($val == $selected) {
        echo ' selected="selected"';
    }
    echo '>'.htmlspecialchars($label).'</option>';
}
echo '</select>';