hi guys, i have a problem when i must to change my php script into codeigniter.
here my controller…
…
$menu[‘menu1’] = $this->studio_model->tampil_menu();
$menu[‘menu2’] = $this->studio_model->tampil_menu();
$menu[‘menu3’] = $this->studio_model->tampil_menu();
$menu[‘submenu1’] = $this->studio_model->tampil_menu();
$menu[‘submenu2’] = $this->studio_model->tampil_menu();
$menu[‘submenu3’] = $this->studio_model->tampil_menu();
$this->load->view(‘sepakbola’,$menu);
…
here my model…
…
$menu1 = $this->db->get_where(‘menu’,array(‘id_menu’=>1));
$sql_menu1 = $menu1->row();
return $sql_menu1;
$menu2 = $this->db->get_where(‘menu’,array(‘id_menu’=>2));
$sql_menu2 = $menu2->row();
return $sql_menu2;
$menu3 = $this->db->get_where(‘menu’,array(‘id_menu’=>3));
$sql_menu3 = $menu3->row();
return $sql_menu3;
$submenu1 = $this->db->get_where(‘submenu’,array(‘id_menu’=>1),3);
return $submenu1;
$submenu2 = $this->db->get_where(‘submenu’,array(‘id_menu’=>2),3);
return $submenu2;
$submenu3 = $this->db->get_where(‘submenu’,array(‘id_menu’=>3),3);
return $submenu3;
…
the problem is when i must make dropdown menu that connected with database in codeigniter, i’m still confuse so much, this is my error dropdown menu in view…
<div id=“css_dropdown_verticale” style=“margin-left:10px; margin-top:20px;”>
<ul>
<li><a href=“<?=base_url();?>/index.php/studio”><?=$sql_menu1->nama_menu?> >></a>
<ul>
<?
foreach ($submenu1 as $sql_submenu1) {
?>
<li><a href=“index.php?id_submenu=<?=$sql_submenu1[‘id_submenu’]?>”><?=$sql_submenu1[‘nama_submenu’]?></a></li>
<?
}
?>
</ul>
</li>
<li><a href=“<?=base_url();?>/index.php/studio”><?=$sql_menu2[‘nama_menu’]?> >></a>
<ul>
<?
foreach ($submenu2 as $sql_submenu2) {
?>
<li><a href=“index.php?id_submenu=<?=$sql_submenu2[‘id_submenu’]?>”><?=$sql_submenu2[‘nama_submenu’]?></a></li>
<?
}
?>
</ul>
</li>
<li><a href=“<?=base_url();?>/index.php/studio”><?=$sql_submenu3[‘nama_menu’]?> >></a>
<ul>
<?
foreach($submenu3 as $sql_submenu3){
?>
<li><a href=“index.php?id_submenu=<?=$sql_submenu3[‘id_submenu’]?>”><?=$sql_submenu3[‘nama_submenu’]?></a></li>
<?
}
?>
</ul>
</li>
</ul>
</div>
please help me guys, how to fix it in codeigniter code…