Blank list dropdown from mysql query into php

Question

When I am trying the code below, I get a blank dropdown. Is there anything wrong with this piece of code?

<?php
include ("Connect.php");

$db = new mysqli('localhost', $dbuser, $dbpass, $dbname);
?>
<div class="label">Select Customer Name:</div>
<select name="CustomerName">
<option value = "">---Select---</option>
<?php
$stmt = $db->prepare("SELECT `CustomerName` FROM `tafileuploadmappinghistory`");
$stmt->execute();
$stmt->bind_result($name);
while ($stmt->fetch()){
    echo "<option value='$name'></option>";
}
$stmt->close();
?>
</select>

Your missing text value in option element <option value='$name'>$value</option> — Aleksandar Rakic
– Aleksandar Rakic, Commented Oct 25, 2018 at 8:20

Hendrik Prinsloo · Accepted Answer · 2018-10-25 08:26:27Z

1

Just update this one line from

echo "<option value='$name'></option>";

to

echo "<option value='$name'>$name</option>";

answered Oct 25, 2018 at 8:26

Hendrik Prinsloo

3291 silver badge11 bronze badges

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

Comments

lucky · Accepted Answer · 2018-10-25 08:21:00Z

0

use this code in while loop for fetch your data

while($stmt->fetchAll()) {

 }

answered Oct 25, 2018 at 8:21

lucky

3282 gold badges4 silver badges18 bronze badges

Collectives™ on Stack Overflow

Blank list dropdown from mysql query into php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related