PHP with dropdown selection

Question

I have list of items in my dropdown. Now I wish to select item according to database value. Suppose I have list of cities their are nearly 300 cities. I have city value as new jersey in my record. Now while editing form checking each options is not possible for 300 options. Like

<option value="A" <? if ($a="A") echo "selected"; ?> >A</option>
<option value="B" <? if ($a="B") echo "selected"; ?> >B</option>
<option value="C" <? if ($a="C") echo "selected"; ?> >C</option>
<option value="D" <? if ($a="D") echo "selected"; ?> >D</option>
<option value="E" <? if ($a="E") echo "selected"; ?> >E</option>
<option value="F" <? if ($a="F") echo "selected"; ?> >F</option>
<option value="G" <? if ($a="G") echo "selected"; ?> >G</option>
<option value="H" <? if ($a="H") echo "selected"; ?> >H</option>

Isn't any way to minimise for 300 records. Can't I write short code for this?

** NOTE My options values are not stored in array.**

How are you building the options dynamically via a for loop ? — aziz punjani
– aziz punjani, Commented Oct 17, 2011 at 15:48

hair raisin · Accepted Answer · 2011-10-17 15:51:45Z

4

suppose your values are stored in an array called $options, you could write something like this:

foreach($options as $option)
{
  echo "<option value=\"$option\"";
  if($option == $a)
  {
    echo ' selected="selected"';
  }
  echo ">$option</option>";
}

answered Oct 17, 2011 at 15:51

hair raisin

2,62817 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

hair raisin Over a year ago

@RahulSingh If your values come from a pre-defined range, such as A-Z, then you could replace $options with the range() function mentioned in @GhazanfarMir's answer

hair raisin Over a year ago

if your values do not originate from a range, you could pre-load your options array like this: $options = array('myval1', 'myval2', ...);

user973254 · Accepted Answer · 2011-10-17 15:48:32Z

0

you should use loops for output

like

$result = mysql_query('select id, city from cities');
while($row = mysql_fetch_assoc($result)) {
    echo '<option value=' . $row['id'] . (($row['city'] == 'new jersey') ? 'selected' : '') . " >" . $row['city'] . '</option>';
}

answered Oct 17, 2011 at 15:48

user973254

2 Comments

Rahul Singh Over a year ago

Why don't you understand my option values are stored in array?

user973254 Over a year ago

you got nice answer above from hair raisin, use it

Ghazanfar Mir · Accepted Answer · 2011-10-17 15:49:05Z

0

Try range function in php:

<?php foreach (range('A', 'Z') as $letter){?>
   <option value="<?php echo $letter?>" <? if ($a==$letter) echo "selected='selected'"; ?> ><?php echo $letter?></option>
<?php }?>

Change the range accordingly. You could use this function with integers too.

answered Oct 17, 2011 at 15:49

Ghazanfar Mir

3,5412 gold badges28 silver badges42 bronze badges

3 Comments

Rahul Singh Over a year ago

That means for alphabetical series A-Z first I have to store these values in $letter thinking it as array?

Ghazanfar Mir Over a year ago

No.. range() function will loop from A-Z storing one letter at a time on each iteration.

Rahul Singh Over a year ago

but wha would be if I HAVE names in options,, like Ghazanfar,rahul than how will it range/.

Collectives™ on Stack Overflow

PHP with dropdown selection

3 Answers 3

2 Comments

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related