HTML form <select> data from database not correctly displayed

Question

            <?php 

        $mysqli = new mysqli("localhost", "root", "", "voorraad");

        $result = $mysqli->query("SELECT leverancier from leverancier");


        echo "<select id='leverancier' name='leverancier' style='width: 30%', color='black'>";
        while ($row = mysqli_fetch_array($result)) {
            echo "<option value='" . $row['leverancier'] ."'></option>";
        }
        echo "</select>";

        ?>

This is the code that I am using, the data is correctly loaded in the <select> menu, but the problem is that it is not visible. Here you can see the problem, the 20 records in the database are loaded, but not visible, I can select them, and save them in the database. But there are not visible.

option value you have put but you forget to put the option name. — Vishnu Sharma
– Vishnu Sharma, Commented Apr 4, 2016 at 11:45
replace this line echo "<option value='" . $row['leverancier'] ."'>" . $row['leverancier'] ."</option>"; — Manjeet Barnala
– Manjeet Barnala, Commented Apr 4, 2016 at 12:05

SuperDJ · Accepted Answer · 2016-04-04 11:45:11Z

3

Change:

echo "<option value='" . $row['leverancier'] ."'></option>";

To

echo "<option value='" . $row['leverancier'] ."'>'" . $row['leverancier'] ."'</option>";

You simply forgot to give the option a name.

answered Apr 4, 2016 at 11:45

SuperDJ

7,69911 gold badges45 silver badges80 bronze badges

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

3 Comments

SmashingJummy Over a year ago

Thanks dude! It's working now! Looking at this problem for almost 2 hours!

SuperDJ Over a year ago

No problem, something like this might happen again a few more times

SuperDJ Over a year ago

@SmashingJummy if you can check this as the answer this question can be closed

Collectives™ on Stack Overflow

HTML form <select> data from database not correctly displayed

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related