Input PHP Variable into HTML Select Tag

Question

I have a php variable ($list) that is a list of values separated by commas. I am trying to figure out how to convert or input this variable into a HTML select tag. Here is what I have so far:

$dbquery = @$db->query('SELECT * FROM Company');
while ($queryText = $dbquery->fetchArray()){
  $array[]=$queryText['Company_Name'];
}
//the next batch of code, which is not included, converts the $array[] into a variable named $list//  
//the values for $list are: Company1, Company2, Company3, Company4...//

//HTML select tag//
echo '<select name="testSelect" id="testId">';
echo '<option value="'.$list.'">'.$list;
echo '</option></select>';

I understand that I would need a loop like a "while" or a "for" to list the values within $list, but I am not sure of the exact syntax. Can anyone assist me with this?

Thanks,

DFM

Philippe Gerber · Accepted Answer · 2009-12-09 17:18:45Z

3

You'll need an option element for every list item (company name).

<select name="testSelect" id="testId">
    <?php foreach ($array as $companyName): ?>
        <option value="<?php echo $companyName; ?>"><?php echo $companyName; ?></option>
    <?php endforeach; ?>
</select>

answered Dec 9, 2009 at 17:18

Philippe Gerber

17.9k6 gold badges47 silver badges40 bronze badges

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

1 Comment

Blair McMillan Over a year ago

This does what you are after, although it skips the $list step (you don't need to create the $list variable unless you are using it somewhere else in your code as well.

robjmills · Accepted Answer · 2009-12-09 17:23:10Z

2

You need to explode() the list into an array (if you can't use $array directly for some reason) then do:

$listArray = explode(', ', $list);
echo '<select name="testSelect" id="testId">';
foreach ($listArray as $item)
    echo '<option value="'.htmlspecialchars($item).'">'. htmlspecialchars($item) . "</option>\n";
echo '</select>';

edited Dec 9, 2009 at 17:23

robjmills

18.6k16 gold badges81 silver badges124 bronze badges

answered Dec 9, 2009 at 17:19

Greg

323k55 gold badges378 silver badges338 bronze badges

Comments

Matti Virkkunen · Accepted Answer · 2009-12-09 17:20:51Z

0

Why are you converting the array into a comma separated list in the first place? Once you have an array you can do

foreach ($company in $list) {
    echo '<option value="' . htmlspecialchars($company) . '">' . htmlspecialchars($company) . '</option>';
}

to output your options. If you for some reason really need to have the comma separated list step, you can always use explode(',', $list) to convert it back to an array.

answered Dec 9, 2009 at 17:20

Matti Virkkunen

65.4k9 gold badges139 silver badges162 bronze badges

Comments

Tim · Accepted Answer · 2009-12-09 17:28:52Z

0

You could use something like explode() to put the list of stuff into an array, then loop through that.. something like:

$myArray = explode(",", $list);

echo "<select name=\"testSelect\" id=\"testId\">\n";
for($i = 0; $i < count($myArray); $i++) {
    // add each option to select list..
    echo "<option>" . $myArray[$i] . "</option>\n";
}
echo "</option>\n";

Comments

Dor · Accepted Answer · 2009-12-09 17:53:15Z

0

See implode()

You can simulate the implode() function with a loop and string concatenation.

For example:

$out = '';
$append = ', ';

for($arr as $v)
{
  $out .= $v.$append;
}

$out = substr($out, 0, (-1) * strlen($append));

edited Dec 9, 2009 at 17:53

answered Dec 9, 2009 at 17:20

Dor

7,5225 gold badges36 silver badges47 bronze badges

Collectives™ on Stack Overflow

Input PHP Variable into HTML Select Tag

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related