How to I fetch Drop Down Items from Database into PHP select drop down form field

Question

Please how do i populate select dropdown list directly from Database table colunm?

Looking forward to your answers. Thanks

<?php 
include('header.php');
include('server.php');//DB Connection
?>

<div class="form-group">
 <label>Select Center</label>
            <?php
                echo "<select class='form-control' name='center'>";
                $result = mysqli_query("SELECT center_name FROM center");

while ($row = mysqli_fetch_assoc($result)) {
                    unset($center);
                    $center = $row['center']; 
                    echo '<option value="'.$center.'"></option>';

                    }

                    echo "</select>";
            ?>
</div>
<div>
<button type="submit" class="btn btn-primary btn-block" name="submit" value="submit">Submit</button>

Your column name in SQL is `center_name` but you're using `$row['center']` in your loop — WillardSolutions, Aug 15 '18 at 12:56
The center_name is the column field name in DB. Could it really be??? Let me change that. Thanks for quick response. — Laolu Aladejana, Aug 15 '18 at 12:58

Zain Farooq · Answer 1 · 2018-08-15T13:56:41.627

1

You have used column name center_name but under loop you put center as array key

Change

$center = $row['center'];

to

$center = $row['center_name'];

And you have set option values but you forgot to add your php variable inside option tag

echo '<option value="'.$center.'">'. $center .'</option>';

edited Aug 15 '18 at 13:56

answered Aug 15 '18 at 12:57

Zain Farooq

2,956
3
20
42

I have changed the Key from 'center' to 'center_name', Yet, still didn't run. More help please!!! – Laolu Aladejana Aug 15 '18 at 13:09
This is the variable declare. I don't know maybe something could wrong there. $centerError =""; $center = ""; – Laolu Aladejana Aug 15 '18 at 13:12
@Laolu Aladejana I have updated my answer. You can check – Zain Farooq Aug 15 '18 at 13:59

score 0 · Answer 2 · answered Aug 15 '18 at 15:04

Thanks all. I resolved the issue by viewing the HTML sourescode through the browser and discovered an error message in the viewsource on browser which did not display to me.

The solution was that i just passed the Database connection as $con as second parameter into the mysqli_query() and that solved the problem.

Thanks all. <div class="form-group"> <label>Select Center</label> <select class='form-control' name='center_name'><br /> <b>Warning</b>: mysqli_query() expects at least 2 parameters, 1 given in <b>C:\xampp\htdocs\soap\create_user.php</b> on line <b>141</b><br /> <br /> <b>Warning</b>: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, null given in <b>C:\xampp\htdocs\soap\create_user.php</b> on line <b>143</b><br /> </select> </div> <div>

How to I fetch Drop Down Items from Database into PHP select drop down form field

2 Answers2