CodeIgniter Forums
From database to form_dropdown list - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: From database to form_dropdown list (/showthread.php?tid=4029)

From database to form_dropdown list - El Forum - 11-03-2007

[eluser]piker[/eluser]
How to convert database query to
options i form_dropdown list ?

I always get array of array

I have
in controller
Code:
$data['options'] = $this->db->get('table');
$this->load->view('welcome_message',$data);


in views
Code:
<html>

<form>
<?=form_dropdown('bleble',$options);?>
</form>

</html>

Thanks
piker

From database to form_dropdown list - El Forum - 11-03-2007

[eluser]gtech[/eluser]
Not sure what your database table contains.
Say you database table had a column tableid and tabledata you could try:

Code:
$dbres = $this->db->get('table');
$ddmenu = array();
foreach ($dbres->result_array() as $tablerow) {
  $ddmenu[$tablerow['tableid']] = $tablerow['tabledata'];
}
$data['options'] = $ddmenu;

$this->load->view('welcome_message',$data);

or


Code:
$dbres = $this->db->get('table');
$ddmenu = array();
foreach ($dbres->result_array() as $tablerow) {
  $ddmenu[] = $tablerow['tabledata'];
}
$data['options'] = $ddmenu;
$this->load->view('welcome_message',$data);


From database to form_dropdown list - El Forum - 11-05-2007

[eluser]piker[/eluser]
It work !
Thanks

piker