[eluser]srajibtechno[/eluser]
ok..thank you...here is my modified code...for menu_model.php and menu_view.php
but it is not working properly...please check this and give me solution as possible..
menu_model.php (model file)
<?php
/** Model: Left Menu Model
* @author Syed Rajib Rahman , Date : 17-06-2008
* @copyright 2008
*/
class Menu_model extends Model
{
function Menu_model()
{
parent :: Model();
}
function menu_getall()
{
$this->load->database();
$this->db->select('main_menu');
$this->db->from('inbook_links');
$this->db->group_by("main_menu");
$GLOBALS['query'] = $this->db->get();
return $GLOBALS['query']->result();
}
function sub_menu_getall()
{
$this->load->database();
$sub_menu_array = array();
for ($i=0; $i<count($GLOBALS['query']); $i++)
{
for ($i=0; $i<count($GLOBALS['query']); $i++)
{
foreach ($GLOBALS['query'][$i] as $value)
{
array_push($sub_menu_array,$value);
}
}
}
for ($i=0;$i<count($sub_menu_array); $i++)
{
$this->db->select('sub_menu');
$this->db->from('inbook_links');
$this->db->where('main_menu',$sub_menu_array[$i]);
$query2 = $this->db->get();
return $query2->result();
}
//} //End Foreach
//} // End for
} //End sub_menu_getall()
} // End class
?>
menu.php (controller file)
<?php
/** Controller : Left Menu Controller
* @author Syed Rajib Rahman , Date : 17-06-2008
* @copyright 2008
*/
class Menu extends Controller
{
function Menu()
{
parent :: Controller();
}
function GetAll()
{
$this->load->model('menu_model');
$data=array();
$data['query']=$this->menu_model->menu_getall();
$data['query2']=$this->menu_model->sub_menu_getall();
// $data['query2']=$this->menu_model->menu_getall();
$this->load->view('menu_view_old',$data);
}
}
?>
menu_view.php (view file)
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<div class="mC">
<!-- Main Menu Start -->
<?php
$menuID = 1;
for ($i=0; $i<count($query); $i++)
{
foreach ($query[$i] as $value) { ?>
<div class="mH" onmouseover="toggleMenu('<?php echo 'menu'.$menuID; ?>')">
</div>
<div id="<?php echo 'menu'.$menuID; ?>" class="mL" style="display:none;">
<?php
foreach($query2 as $row2)
{
?>
<?
} ?>
</div>
<?php
}
$menuID++;
}
?>
</div>
</body>
</html>