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:

  
$query = $xoopsDB->query(' SELECT * FROM ' . $xoopsDB->prefix('xoops_table')); 
while ($row = $xoopsDB->fetchArray($query)) 
{ 
$sel = $row['field1']; 
$id =$row['field2']; 
echo "$id'>$seln"; 
} 
?>

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]."
"; 
//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:

  
 
$query = $xoopsDB->query(' SELECT * FROM ' . $xoopsDB->prefix('xoops_table')); 
 
while ($row = $xoopsDB->fetchArray($query)) 
{ 
$sel = $row['field1']; 
$id =$row['field2']; 
echo "$id'>$seln"; 
} 
?>

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]."
"; 
//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:	Nov 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Did you know ?

A large number of XOOPS sites that are hacked are because the owner failed to set the correct file system permissions on critical XOOPS files and folders.

More details...

Random question

What is the difference between all the categories in the notification Options block of the forum module (Thread, Forum, Global)?

Answer here!

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