Welcome Guest, Not a member yet? Register   Sign In
From database to form_dropdown list
#1

[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
#2

[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);
#3

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

piker




Theme © iAndrew 2016 - Forum software by © MyBB