Fetching records from MySQL database with PHP to populate a drop down list

Question

im having trouble with my code. I'm trying to populate a drop down list from my database but the list is showing empty space instead of database entries. I would be very grateful if anyone could help me.

<?php
include("db_config.php");
$sql="SELECT * FROM brojevi";
$result=mysqli_query($connection,$sql);
echo "<select name=\"id\" size=\"1\">";
echo "<option value=\"choose\">-choose-</option>";
while($row=mysqli_fetch_array($result)){
unset($id,$broj);
$id=$row['id'];
$broj=$row['brojevi'];
echo "<option value=\"$id\">$broj</option>";
}
echo "</select>";
?>

Here is the table( its a simple one cause im just making this for practice )

 CREATE TABLE `brojevi` (
 `id` int(11) NOT NULL auto_increment,
 `broj` int(11) NOT NULL,
 PRIMARY KEY  (`id`)
 );

INSERT INTO `brojevi` (`id`, `broj`) VALUES
(1, 1),
(2, 2);

You should look into the MVC Design Pattern.

christopher
– christopher

2015-01-10 22:25:22 +00:00
Commented Jan 10, 2015 at 22:25 — christopher
– christopher, Commented Jan 10, 2015 at 22:25
How does the table look?

Daniel Persson
– Daniel Persson

2015-01-10 22:25:33 +00:00
Commented Jan 10, 2015 at 22:25 — Daniel Persson
– Daniel Persson, Commented Jan 10, 2015 at 22:25

user1897253 · Accepted Answer · 2015-01-10 22:28:41Z

1

You are messing up your single and double quotes. Try this:

<?php
include("db_config.php");
$sql="SELECT * FROM brojevi";
$result=mysqli_query($connection,$sql);
echo '<select name="dropdown" size="1">';
echo '<option value="choose">-choose-</option>';
while($row=mysqli_fetch_array($result)){
    $id = $row['id'];
    $broj = $row['brojevi'];
    echo '<option value="' . $id . '">' . $broj . '</option>';
}
echo '</select>';
?>

When using html tags inside your echo, try to use single quotes for the echo and double quotes for html stuff like values,id's,classes etc.

answered Jan 10, 2015 at 22:28

user1897253

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

Collectives™ on Stack Overflow

Fetching records from MySQL database with PHP to populate a drop down list

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related