query-builder Examples and Free Source Code

How to get child data from one table per parent in another table and display as a two-tiered list wi...

php codeigniter model-view-controller parent-child query-builder

Passing a string of WHERE conditions to CodeIgniter's get_where() method renders an invalid quer...

php mysql codeigniter where-clause query-builder

SELECT query WHERE NOT IN a subquery using CodeIgniter's Query Builder methods...

php codeigniter subquery query-builder where-in

SELECT rows from the database WHERE date is in the current week with CodeIgniter's Query Builder...

php date codeigniter query-builder date-range

Codeigniter - How to get records from database where one fields value is more than another?...

php mysql codeigniter where-clause query-builder

CodeIgniter Query Builder WHERE a column value is greater than another column value...

php codeigniter where-clause comparison query-builder

SQL join in CodeIgniter with Active Record...

php codeigniter join one-to-many query-builder

Show data codeigniter from joining table...

php codeigniter model-view-controller codeigniter-3 query-builder

Get unlimited row count and paginated results from the database using CodeIgniter...

php codeigniter pagination codeigniter-3 query-builder

How to avoid repeating rows when JOINing a one-to-many table with Codeigniter query builder...

php codeigniter join one-to-many query-builder

Explain this CodeIgniter Query Builder script which calls: select(), where(), join(), order_by(), an...

php mysql codeigniter join query-builder

How to do a NATURAL JOIN with multiple tables using CodeIgniter Query Builder...

php mysql codeigniter query-builder natural-join

Mentioning the same table in CodeIgniter's from() and get() query builder methods incorrectly sh...

php mysql codeigniter join query-builder

Call to undefined method CI_DB_mysqli_driver::groupBy()...

php codeigniter group-by codeigniter-3 query-builder

How to SELECT all data from a database table with CodeIgniter's query builder methods...

php codeigniter select query-builder

How to find out if an UPDATE query was successfully executed...

php codeigniter sql-update query-builder rows-affected

How to return a single column value from a single row of a CodeIgniter query...

php codeigniter select query-builder resultset

Return both query result and num rows...

php codeigniter query-builder resultset counting

Pass the number of qualifying rows from the model to the view in CodeIgniter...

php codeigniter model-view-controller query-builder counting

Single quotes in DATE_FORMAT() within a CodeIgniter select() call using single quotes emits a parse ...

php codeigniter query-builder quoting parse-error

CodeIgniter JOINed tables returning results which should be disqualified by WHERE condition...

php codeigniter join where-clause query-builder

Codeigniter SELECT query with multiple join() method calls results in duplicated rows...

php codeigniter join duplicates query-builder

How to GROUP BY an aliased CONCAT() value using CodeIgniter's query builder...

php codeigniter aggregate-functions alias query-builder

How to avoid repeating parent rows when JOINing a one-to-many table with Codeigniter query builder...

php codeigniter join aggregate-functions query-builder

Adding a CodeIgniter join() method call to a working query builder script emits an error...

php mysql codeigniter join query-builder

How to SUM a column's values withing a date range with CodeIgniter's query builder...

php codeigniter sum query-builder

How to join tow times the same table?...

php codeigniter join query-builder name-collision

Codeigniter how to echo more than one INNER JOIN from same table...

php codeigniter inner-join query-builder name-collision

Codeigniter MySQL a Join Query with a column name collision in the results...

php mysql codeigniter query-builder name-collision

How to fetch multiple values from a database using multiple ids with CodeIgniter...

php codeigniter select codeigniter-3 query-builder