This tutorial shows you how to write having query in codeigniter. This methods permits you to write the HAVING portion of your query. There are 2 possible syntaxes, 1 argument or 2. Let’s create a having method in codeigniter $this->db->having(‘user_id…

This tutorial shows you how to write distinct query in codeigniter. This method is identical to the Adds the “DISTINCT” keyword to a query. Let’s create a distinct method in codeigniter $this->db->distinct(); $this->db->get(‘table’); // Produces: SELECT DISTINCT * FROM table

This tutorial shows you how to write or not like query in codeigniter. This method is identical to not_like(), except that multiple instances are joined by OR. Let’s create a or_not_like method in codeigniter $this->db->like(‘title’, ‘php’); $this->db->or_not_like(‘body’, ‘article’); // WHERE…

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’,…