codeigniter tutorial Archives - Page 2 of 2

We have created html table listing using codeigniter and mysql database in previous codeigniter tutorial.We will add advanced feature in this table like any other table grid plugin.We will follow following steps to add pagination features. I am using codeigniter pagination library for paging and url library for anchor tag.CI is providing many useful library classes that help to add beautiful features with in finger tips. How to add Pagination in HTML table Listing One of them is pagination class that use to set pagination parameters like no of records to show per page, next, prev icons, uri segment etc.We need to add pagination and url library into controller constructor method. $this->load->helper('url'); $this->load->library("pagination"); Modify index() controller method that will configure pagination parameters like below, public function index() { $data array(); $data 'Home'; $config array(); $config base_url().'home/index'; $config $this->employee->record_count(); $config 10; $config 3; $config ''; $config ''; $config '« First'; $config ''; $config ''; $config 'Last »'; $config ''; $config ''; $config 'Next →'; $config ''; $config ''; $config '← Previous'; $config ''; $config ''; $config ''; $config ''; $config ''; $config ''; $page ($this->uri->segment(3)) ? $this->uri->segment(3) : 0; $data $this->employee->get_employees($config, $page); $this->pagination->initialize($config); $data $this->pagination->create_links(); $this->template->load('default_layout', 'contents' , 'home', $data); } Modify getemployee() model method and passed limit parameters for pagination, function get_employees($limit, $start, $id0) { if(empty($id)){ $this->db->limit($limit, $start); $query $this->db->get('employee'); if ($query->num_rows() > 0) { foreach ($query->result() as $row) { $data $row; } return $data; } return false; } else { $query $this->db->get_where('employee', array('id' > $id)); return $query->row_array(); } } public function record_count() { return $this->db->count_all("employee"); } Now we will add pagination link on the bottom of table listing into home.php view file. How to add sorting in HTML table listing Using codeigniter and MySQL We have already added table listing with pagination, now we will add sorting on table column.I am creating single column sorting on table listing server side. Step 1: We will change index() action method in home.php controller file.We will add two more parameters in uri for field_name and orderBy parameters. $data array( 'employee_name' > 'Name', 'employee_salary' > 'Salary', 'employee_age' > 'Age' ); $config 5; $data $this->uri->segment(3, 'employee_name'); $orderBy $this->uri->segment(4, "desc"); if($orderBy "asc") $data "desc"; else $data "asc"; $config base_url().'home/index/'.$data.'/'.$orderBy.'/'; $data $this->employee->get_employees($config, $offset, $data, $data); Step 2: We need to modify employee_m.php model file and passed $sortfield and $orderBy parameters for sorting records. function get_employees($per_page, $offset, $sortfield, $orderBy, $id0) { if(empty($id)){ //echo $per_page.'fff'.$offset.'fff'.$sortfield.'fff'.$orderBy; $this->db->order_by("$sortfield", "$orderBy"); $this->db->limit($per_page,$offset); $query $this->db->get('employee'); if ($query->num_rows() > 0) { foreach ($query->result() as $row) { $data $row; } return $data; } return false; } else { $query $this->db->get_where('employee', array('id' > $id)); return $query->row_array(); } } Step 3: We will add anchor tab on table header column.I am using anchor() helper method to create anchor tag with in th tag. We will refreshed table listing and found that th has been converted into anchor link, onclick of anchor th we will sort order of particular column field. CodeIgniter listing with Searching We will implement last phase of this tutorial.We will add searching functionality of table listing. Created a search input box that will take search string as a input and added a submit button for submit search string to controller method.I am using uri parameters for search string however you can pass using query string with pagination. Step 1: We will create search input form which will have a submit button and input element in home.php view file.

codeigniter tutorial

Simple Example of CodeIgniter Custom Layout

Categories