# PHP: How to show data from database in a listbox

**URL:** <https://forum.kirupa.com/t/php-how-to-show-data-from-database-in-a-listbox/260747>\
**Category:** programming\
**Created:** [May 19, 2008, 3:30pm UTC](https://forum.kirupa.com/t/php-how-to-show-data-from-database-in-a-listbox/260747 "2008-05-19T15:30:58Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![RubenDoliveira](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/rubendoliveira/32/3905_2.png) [@RubenDoliveira](https://forum.kirupa.com/u/RubenDoliveira)\
**Post date:** [May 19, 2008, 3:30pm UTC](https://forum.kirupa.com/t/php-how-to-show-data-from-database-in-a-listbox/260747/1 "2008-05-19T15:30:58Z")

</div>

Hi everyone,

Firstly, I’m new to PHP.

I’m making an online store (backend and frontend) and I’m stucked in a probably simple detail. I have the products insert page done and working, and now I need to insert a product in a specific category and that’s my problem.

I have a lisbox where I want to show a list with all my categories. How do I show a category from a database in a listbox ?

Thanks in advance.

---

<div class="post-metadata">

**Author:** ![uuvbbz](https://avatars.discourse-cdn.com/v4/letter/u/b2d939/32.png) [@uuvbbz](https://forum.kirupa.com/u/uuvbbz)\
**Post date:** [May 19, 2008, 5:07pm UTC](https://forum.kirupa.com/t/php-how-to-show-data-from-database-in-a-listbox/260747/2 "2008-05-19T17:07:51Z")

</div>

[⊙ ⊙ say:good…[url=http://www.portrait2000.com]portarit2000](http://www.portrait2000.com)

---

<div class="post-metadata">

**Author:** ![kdd](https://avatars.discourse-cdn.com/v4/letter/k/ecb155/32.png) [@kdd](https://forum.kirupa.com/u/kdd)\
**Post date:** [May 20, 2008, 7:28am UTC](https://forum.kirupa.com/t/php-how-to-show-data-from-database-in-a-listbox/260747/3 "2008-05-20T07:28:05Z")

</div>

Hmmm. How did I miss this question?

Anyways, I’m assuming you have all the “items” in you table.  
I’ll give you pseudo code, as I’m not exactly sure what your set up is.

```php

do db connect, table select, and run the query to select items from the table, and get a $result resource.

echo "<select>";
for each item in your $result,
fetch item
and echo "<option>" . $item["itemName"] . "</option>";
end for
echo "</select>";

```

Hope this helps. 🙂

---

<div class="post-metadata">

**Author:** ![RubenDoliveira](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/rubendoliveira/32/3905_2.png) [@RubenDoliveira](https://forum.kirupa.com/u/RubenDoliveira)\
**Post date:** [May 20, 2008, 1:16pm UTC](https://forum.kirupa.com/t/php-how-to-show-data-from-database-in-a-listbox/260747/4 "2008-05-20T13:16:07Z")

</div>

Thanks a lot kdd. I’m going to try it now.

Cheers.

---

<div class="post-metadata">

**Author:** ![RubenDoliveira](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/rubendoliveira/32/3905_2.png) [@RubenDoliveira](https://forum.kirupa.com/u/RubenDoliveira)\
**Post date:** [May 20, 2008, 1:40pm UTC](https://forum.kirupa.com/t/php-how-to-show-data-from-database-in-a-listbox/260747/5 "2008-05-20T13:40:55Z")

</div>

It works 🙂

ThankS:D

---

<div class="post-metadata">

**Author:** ![Charleh](https://avatars.discourse-cdn.com/v4/letter/c/a9a28c/32.png) [@Charleh](https://forum.kirupa.com/u/Charleh)\
**Post date:** [May 20, 2008, 3:26pm UTC](https://forum.kirupa.com/t/php-how-to-show-data-from-database-in-a-listbox/260747/6 "2008-05-20T15:26:41Z")

</div>

Don’t forget you can always add the items underlying id or something as the ‘value’ attribute of each option - just modify the line to the following

```auto

and echo "<option value='" . $item["itemID"] . "'>" . $item["itemName"] . "</option>";

```

---

<div class="post-metadata">

**Author:** ![kdd](https://avatars.discourse-cdn.com/v4/letter/k/ecb155/32.png) [@kdd](https://forum.kirupa.com/u/kdd)\
**Post date:** [May 20, 2008, 4:52pm UTC](https://forum.kirupa.com/t/php-how-to-show-data-from-database-in-a-listbox/260747/7 "2008-05-20T16:52:58Z")

</div>

^ Yeah, I left that part out as an exercise to the reader. :pleased: haha