The or_where_in methods allows you to specify multiple values in a WHERE clause. Generates a WHERE field IN (‘item’, ‘item’) SQL query joined with OR if appropriate. Let’s create a or_where_in method in codeigniter $id= array(’10’, ’20’, ’30’); $this->db->or_where_in(‘id’, $id);…

The where_in methods allows you to specify multiple values in a WHERE clause. Generates a WHERE field IN (‘item’, ‘item’) SQL query joined with AND if appropriate Let’s create a where_in method in codeigniter $id = array(‘1′, ’15’, ’20’); $this->db->where_in(‘id’,…

The LEFT JOIN is sometimes called as LEFT OUTER JOIN and is performed on two database tables – the first table (on the left side) is referred as LEFT TABLE and and the second (on the right side) one as…

This tutorial will help you to learn join query using php codeigniter. Table joins are essential part in application development while displaying the records from multiple tables. Let’s create a join method in codeigniter $this->db->select(‘tbl_order.*,tbl_user.fullname’); $this->db->from(‘tbl_order’); $this->db->join(‘tbl_user’, ‘tbl_user.id = tbl_order.user_id’);…

As shown earlier, the FROM portion of your query can be specified in the $this->db->get() function, so use whichever method you prefer. Let’s create a $this->db->from() method in codeigniter $this->db->select(‘username, password, admin’); $this->db->from(‘tbl_user’); $query = $this->db->get();

Codeigniter provides select_sum method to get sum value in mysql table column. Writes a “SELECT SUM(field)” portion for your query. As with select_max(), You can optionally include a second parameter to rename the resulting field. Let’s create a select_sum method…

Codeigniter provides select_avg method to get average value in mysql table column. Writes a “SELECT AVG(field)” portion for your query. As with select_max(), You can optionally include a second parameter to rename the resulting field. Let’s create a select_avg method…

Codeigniter provides select_min method to get minimum value in mysql table column. Writes a “SELECT MIN(field)” portion for your query. As with select_max(), You can optionally include a second parameter to rename the resulting field. Let’s create a select_min method…

In this topics we will discuss how can we make data retrive by using Ajax with Codeigniter framework. In this system we will use DataTables Jquery plugin for display data in tabular format. Here we will implement DataTables server side…

How to remove index.php in codeigniter In this tutorial we are going to learn how to remove index.php from URL using .htaccess file in CodeIgniter. htaccess is the shortened used for Hypertext Access. using this file you can do many…