query-builder Examples and Free Source Code

CodeIgniter query to search multiple columns for each word of an input string...

php codeigniter activerecord sql-like query-builder

CodeIgniter OR LIKE query to search multiple columns for each word of a user-supplied string...

php mysql codeigniter sql-like query-builder

CodeIgniter query to SELECT vacant rooms from JOINed rooms and reservations tables during a range of...

php mysql date codeigniter query-builder

Get JOINed data associated with latest record using CodeIgniter query building methods...

php sql codeigniter subquery query-builder

Build CodeIgniter query from the results of another query...

php mysql codeigniter query-builder where-in

how to use array in where clause in Codeigniter...

php codeigniter where-clause query-builder where-in

CodeIgniter query to search a datetime column by submitted year, month or day value...

php datetime codeigniter activerecord query-builder

SELECT rows WHERE a single value is found in one of multiple columns using CodeIgniter's query b...

php codeigniter activerecord where-clause query-builder

WHERE clause with two conditions separated by OR using CodeIgniter's query building methods...

php codeigniter activerecord where-clause query-builder

how to use multiple or_where on same field in codeigniter...

php codeigniter where-clause query-builder logical-grouping

How to CodeIgniter's where_in() and get_where() methods...

php mysql codeigniter where-clause query-builder

How to implement row constructor syntax using CodeIgniter's where_in() query building method...

php mysql codeigniter query-builder where-in

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

php codeigniter activerecord query-builder in-subquery

Pass an array of diverse WHERE conditions as an array from the Controller to the Model in a CodeIgni...

php codeigniter where-clause codeigniter-3 query-builder

Convert raw SQL with comma-JOINed tables to use CodeIgniter's query builder methods...

php codeigniter join activerecord query-builder

UNION query using CodeIgniter query builder methods...

php mysql codeigniter union query-builder

Translate raw SELECT SQL with two comma-JOINed tables to CodeIgniter's query builder syntax...

php sql codeigniter join query-builder

SELECT COUNT of records in a second table per record in a first table using CodeIgniter query builde...

php mysql codeigniter activerecord query-builder

CodeIgniter query WHERE clause with enclosed OR LIKE conditions and other non-LIKE conditions...

php codeigniter activerecord codeigniter-3 query-builder

Create multiple OR LIKE conditions on the same column using CodeIgniter query building methods...

php sql codeigniter sql-like query-builder

Enclose portions of WHERE clause conditions in parentheses with CodeIgniter query builder methods...

php codeigniter activerecord query-builder logical-grouping

CodeIgniter active record SELECT query with JOIN and WHERE IN subquery...

php codeigniter join subquery query-builder

Return count of qualifying rows from a SELECT query with a JOIN using CodeIgniter...

php mysql codeigniter count query-builder

"No tables used" error in CodeIgniter when calling query(), then get()...

php codeigniter select activerecord query-builder

What does using false as the second parameter of CodeIgniter's select() method do?...

php codeigniter select escaping query-builder

Conditionally add an OR WHERE IN () condition using CodeIgniter's query building methods...

php sql codeigniter where-clause query-builder

CodeIgniter SELECT query with WHERE clause containing equals, IN, and LIKE as well as AND and OR is ...

php codeigniter where-clause query-builder logical-grouping

CodeIgniter's where_in() method finds no matches using a comma-separated string of values...

php codeigniter select query-builder where-in

SELECT WHERE IN subquery using CodeIgniter's where_in() method...

php codeigniter query-builder where-in in-subquery

Can where_in() be called more than once in a single CodeIgniter active record?...

php codeigniter activerecord query-builder where-in