PHP echo in selection list with multiple selection options

Question

I'm having a bit of struggle putting together a selection list in HTML where the options or values are being retrieved from a table in the database. I get the following result:

As you can see this is not my intention, I rather have all options in 1 Selection List, with multiple options clickable.

This is my HTML Code (Bootstrap Framework):

<div class="container-fluid well well-lg">

     <?php while ($itemsrow = $query->fetch()) : ?>

<div class="form-group">

      <label for="sel1">Select list:</label>

<select class="form-control" id="sel1">

         <option><?php echo $itemsrow['Beschrijving']; ?></option>

The PHP Logic:

$conn = Db::getInstance();
$query = $conn->prepare("SELECT * FROM items WHERE user_id = $userID");
$query->execute();

Thanks in advance!

M. Eriksson · Accepted Answer · 2017-05-06 13:38:09Z

3

Currently, you're creating new elements inside the loop so yes, you will get a new select per iteration.

You should only keep the <option>-elements inside the loop:

<div class="container-fluid well well-lg">
    <div class="form-group">
        <label for="sel1">Select list:</label>

            <select class="form-control" id="sel1">

            <?php while ($itemsrow = $query->fetch()) : ?>  

                <option><?php echo $itemsrow['Beschrijving']; ?></option>

            <?php endwhile; ?>

answered May 6, 2017 at 13:38

M. Eriksson

13.7k4 gold badges31 silver badges42 bronze badges

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

2 Comments

Moya Over a year ago

lol thanks, I feel a bit stupid but thanks for replying so quickly!

M. Eriksson Over a year ago

@Moya - No worries. Just remember to check one of the answers as correct so the question gets closed.

M Melnikov · Accepted Answer · 2017-05-06 13:37:36Z

1

You should put your loop into <select> tag

<select class="form-control" id="sel1">
    <?php while ($itemsrow = $query->fetch()) : ?>
        <option><?php echo $itemsrow['Beschrijving']; ?></option>

answered May 6, 2017 at 13:37

M Melnikov

833 bronze badges

1 Comment

Moya Over a year ago

lol thanks, I feel a bit stupid but thanks for replying so quickly!

Collectives™ on Stack Overflow

PHP echo in selection list with multiple selection options

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related