The date_format() function returns a date formatted according to the specified format. Let’s create a date_format() in where condition using codeigniter. if(!empty($this->input->get(‘start_date’))) { $this->db->where(‘DATE_FORMAT(products.created_datetime,”%Y-%m-%d”) >=’, date(‘Y-m-d’,strtotime($this->input->get(‘start_date’)))); }

Generates an insert string based on the data you supply, and runs the query. You can either pass an array or an object to the function. Note: All values are escaped automatically producing safer queries. Let’s create a inser() method…

Query grouping allows you to create groups of WHERE clauses by enclosing them in parentheses. This will allow you to create queries with complex WHERE clauses. Nested groups are supported. $this->db->select(‘*’)->from(‘tbl_user’) ->group_start() ->where(‘a’, ‘a’) ->or_group_start() ->where(‘b’, ‘b’) ->where(‘c’, ‘c’) ->group_end()…

The count_all() method returns the number of rows in a table satisfying the criteria specified in the WHERE clause. It sets the number of rows or non NULL column values. Permits you to determine the number of rows in a…

The count_all_results() method is used to get the number of rows in a MySQL result handle. Permits you to determine the number of rows in a particular Active Record query. Queries will accept Query Builder restrictors such as where(), or_where(),…

Codeigniter provides a limit() method clause that is used to specify the number of records to return. The limit() method makes it easy to code multi page results or pagination with SQL, and is very useful on large tables. Returning…

The order_by() method is used to sort the result-set in ascending or descending order. The first parameter contains the name of the column you would like to order by. The second parameter lets you set the direction of the result.…

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…