query-builder Examples and Free Source Code

How to SELECT unique rows using CodeIgniter's query builder...

php codeigniter duplicates distinct query-builder

get data from multiple tables in codeigniter?...

php mysql codeigniter query-builder sub-array

JOIN tables with one-to-one and one-to-many relationships with CodeIgniter...

php codeigniter join query-builder codeigniter-2

"Call to a member function num_rows() on a non-object" emitted when calling num_rows() on ...

php codeigniter query-builder codeigniter-2 resultset

LEFT JOIN model codeigniter...

php codeigniter left-join query-builder

Is there any way to remove where clause from query using logic?...

php codeigniter conditional-statements codeigniter-3 query-builder

Codeigniter search with multiple fields...

php codeigniter codeigniter-3 query-builder sql-like

How to use CONVERT() in a CodeIgniter order_by() query builder method call without corrupting the re...

php codeigniter sql-order-by query-builder mysql-function

In CodeIgniter, how do I retrieve a sql query and order it by either ascending or descending order a...

php sql codeigniter query-builder

How chain an order_by() call to a CodeIgniter query built fully by get_where()...

php codeigniter sql-order-by query-builder method-chaining

ORDER BY year component of date value using CodeIgniter's query builder...

php codeigniter sql-order-by codeigniter-3 query-builder

CodeIgniter query builder containing LEFT JOIN and GROUP BY not returning all results...

php codeigniter join query-builder group-concat

SELECT rows WHERE a string is found in a serialized column value using CodeIgniter's query build...

php regex codeigniter serialization query-builder

SELECT query with WHERE clause containing CONCAT() and REGEXP using CodeIgniter's query builder...

php codeigniter concatenation where-clause query-builder

How to convert raw SELECT SQL containing JOIN on shared column name to CodeIgniter's query build...

php codeigniter join query-builder

Convert SELECT query with JOIN on subquery containing MAX() to CodeIgniter's query builder...

php codeigniter subquery query-builder codeigniter-2

Column 'wine_id' in field list is ambiguous Error and cant work out why...

php mysql codeigniter query-builder ambiguous

Passing an integer value as the second parameter of CodeIgniter's update() generates unintended ...

php mysql codeigniter sql-update query-builder

How to apply a WHERE condition to a CodeIgniter query built with count_all()...

php mysql codeigniter count query-builder

How to JOIN three tables with CodeIgniter's query builder...

php codeigniter join select query-builder

Calling CodeIgniter's get() after query() emits MySQL error 1096 - No tables used...

php mysql codeigniter select query-builder

Group by query not working fine According me...

php sql codeigniter group-by query-builder

CodeIgniter SQL query - how to sum values for each month?...

php mysql codeigniter group-by query-builder

How to retrieve all descendant categories in a parent-child table using CodeIgniter's query buil...

php mysql codeigniter parent-child query-builder

How to JOIN related tables using CodeIgniter's query builder...

php codeigniter join query-builder codeigniter-2

Create subarrays in the result set from JOINed data using CodeIgniter's query builder...

php codeigniter grouping query-builder sub-array

How to give one query result to another query in where condition using codeiginter?...

php codeigniter join query-builder

SELECT rows which have specified pairs of column values using CodeIgniter's query builder...

php mysql codeigniter select query-builder

order_by() and limit() called after update() are rendered in a subsequently built query in CodeIgini...

php mysql codeigniter sql-order-by query-builder

How to use CodeIgniter's query builder methods to make an UPDATE query with a JOIN...

php codeigniter join sql-update query-builder