This tutorial shows you how to write not like query in codeigniter. This method is identical to like(), except that it generates NOT LIKE statements. Let’s create a not_like method in codeigniter $this->db->not_like(‘title’, ‘php’); // WHERE `title` NOT LIKE ‘%php%…

This tutorial shows you how to write or like query in codeigniter. This method is identical to the one above, except that multiple instances are joined by OR. Let’s create a or_like method in codeigniter $this->db->like(‘title’, ‘match’); $this->db->or_like(‘body’, $match); //…

This tutorial shows you how to write like query in codeigniter. Like clause is used in ‘SELECT Query’ to search for the matching pattern in columns. The operator is part of the where clause and employs wildcard character (%) to…

In this article we will see how to implement multiple forms array with jQuery and JavaScript code asynchronously by Ajax. Now, when you simply submit your form the normal way, your browser takes care of sending HTML input arrays with…

Now, when you simply submit your form the normal way, your browser takes care of sending HTML input arrays with ease and you can begin to segment your data on your server. This was an interesting complication that I ran…

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

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

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…