[eluser]Unknown[/eluser]
I want to create tabbed panel with pagination for each tab.
i am facing problem while passing arrays to views and pagination variable pointing to either first or last variable that is previous value.
Code:
//code for controller
public function postedevents()
{
$this->load->helper('url');
$this->load->library('pagination');
$config['base_url']=base_url().'index.php./events/index';
//$config['total_rows']=$this->db->count-all('Events');
$config['per_page']=5;
$config['full_tag_open']='<p>';
$config['full_tag_close']='</p>';
$this->pagination->initialize($config);
$this->load->model('EventData');
$pevents=array();
$pevents['eventp']=$this->eventdata->postevent($config['per_page'],$this->uri->segment(3));
$this->load->view('event',$pevents);
}
public function view()
{
//parent::__construct();
$this->load->helper('url');
$this->load->library('pagination');
//$this->load->postedevents();
$config['base_url'] = base_url() .'index.php/events/index';
$config['total_rows'] = $this->db->count_all('events');
$config['per_page'] = '5';
$config['full_tag_open'] = '<p>';
$config['full_tag_close'] = '</p>';
$this->pagination->initialize($config);
$this->load->model('eventdata');
$events=array();
$events['eventi']=$this->eventdata->viewevents($config['per_page'],$this->uri->segment(3));
$this->load->library('pagination');
$this->load->view('event',$events);
}
Code:
function viewevents($num, $offset)
{
$this->db->select('EventTitle,EventDescription,Category,EventType,StartDate,Place,Venue,Address,City,State,Country,PostalCode');
$this->db->order_by('StartDate');
$sql=$this->db->get('events',$num, $offset);
$this->db->limit(5);
if($sql->num_rows()>0)
{
foreach($sql->result() as $etdata)
{
$eventdata[]=$etdata;
}
return $eventdata;
}
else
{
return false;
}
}
function postevent($pnum,$poffset)
{
$this->db->select('EventTitle,EventDescription,Category,EventType,StartDate,Place,Venue,Address,City,State,Country,PostalCode');
$this->db->where('User_IdUser',2);
$psql=$this->db->get('Events',$pnum,$poffset);
if($psql->num_rows()>0)
{
foreach($psql->result() as $pedata)
{
$postdata[]=$pedata;
}
return $postdata;
}
else
{
return false;
}
}
how to fix it?
also can anybody tell me can i do this in my view
$this->load->view('tab1');
$this->load->view('tab2');
that is can i load view in my view file