XOOPS FAQ - System Processes - How do I populate a dropdown box from a xoops table?

Create a standard html form then add the following code:


<SELECT name="dropdown[]" size="10" multiple id="select">

<?php

$query = $xoopsDB->query(' SELECT * FROM ' . $xoopsDB->prefix('xoops_table'));

while ($row = $xoopsDB->fetchArray($query))

{

$sel = $row['field1'];

$id =$row['field2'];

echo "<OPTION VALUE='$id'>$sel</OPTION>n";

}

?>

</SELECT>

This will create a var called $dropdown which is an array. To read through the results you can use this:


$count=count($dropdown);

for ($i=0; $i<$count; $i++) {

echo "result: ".$dropdown[$i]."<br>";

//do something else with each selected option.

}

IN case you don't want the select box to be multiselect, replace this:


<SELECT name="dropdown[]" size="10" multiple id="select">

with this:


<SELECT name="dropdown" size="10" id="select">

4 Comment(s)

The comments are owned by the author. We aren't responsible for their content.

Interesting

script_fu Published 11/01/2005 1:58 Friend of XOOPS Joined 12/27/2002 Comments 1494

Can you elaborate a lil more on this feature? What I have in mind is setting up an automotive type form.

Example

First tab would be

Name:
Address:
City:
State:
Country:
Phone:

Second tab would be
Year:
2006
2005
2004

Make:
Chev
Dodge
Ford

Model:
Caprice
Impala
Nova

Parts Needed:

Ect. Ect.

Third tab would be Shipping instructions or something...

Have a look here at this center block design.
http://www.bahut.com/
I would like to set up a form system the same way. Would it be hard to pass the data all the way to the end of the tabs then submit the form.

I would love to pull the cats from an XOOPS table.

I hope this makes sence...

Re: Interesting

JulioNC Published 11/01/2005 2:17 Quite a regular Joined 10/08/2004 Comments 239

Quote:

A Propos - Tous droits réservés à Bahut.com © 2005 - XOOPS Ghost Reloaded - Contact

http://www.bahut.com/
Xoops Ghost Reloaded

Please fix this page

MadFish Published 10/29/2007 8:18 Friend of XOOPS Joined 09/27/2003 Comments 1056

I think this page is broken? 2 of the code examples are not displaying correctly?

Think the idea was to write this..

culex Published 10/19/2009 19:23 Updated 10/19/2009 19:29 Module Developer Joined 09/23/2004 Comments 711

Create a standard html form then add the following code:


<SELECT name="dropdown[]" size="10" multiple id="select">

<?php



$query = $xoopsDB->query(' SELECT * FROM ' . $xoopsDB->prefix('xoops_table'));



while ($row = $xoopsDB->fetchArray($query))

{

$sel = $row['field1'];

$id =$row['field2'];

echo "<OPTION VALUE='$id'>$sel</OPTION>n";

}

?>

</SELECT>

This will create a var called $dropdown which is an array. To read through the results you can use this:


$count=count($dropdown);

for ($i=0; $i<$count; $i++) {

echo "result: ".$dropdown[$i]."<br>";

//do something else with each selected option.

}

IN case you don't want the select box to be multiselect, replace this:


<SELECT name="dropdown[]" size="10" multiple id="select">

with this:


<SELECT name="dropdown" size="10" id="select">

Login

Username

Password

Remember me

Search

Advanced Search

Donat-O-Meter

Stats
Goal:	$100.00
Due Date:	Apr 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Did you know ?

XOOPS is free software, but you can still make money with XOOPS.

More details...

Random question

How to set a block underneath a module?

Answer here!

How do I populate a dropdown box from a xoops table?