activerecord Examples and Free Source Code

SELECT query to check if logged-in user has positive column value using CodeIgniter...

php mysql codeigniter model-view-controller activerecord

UNION query with codeigniter's active record pattern...

php mysql codeigniter activerecord union

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

php mysql codeigniter activerecord query-builder

Ambiguous column name error in CodeIgniter query with dynamic columns and tables...

php sql codeigniter activerecord ambiguous

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

php codeigniter activerecord codeigniter-3 query-builder

ActiveRecord query for unassociated has_many through records...

ruby-on-rails ruby activerecord

How to write a parameterized WHERE IN (?) condition using CodeIgniter's query() method?...

php sql codeigniter activerecord where-in

How to create MULTIPLE LIKE query for the same column in codeigniter?...

php mysql codeigniter activerecord sql-like

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

php codeigniter activerecord query-builder logical-grouping

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

php codeigniter select activerecord query-builder

Automated quoting in CodeIgniter select() method is corrupting SELECT clause...

php mysql codeigniter activerecord escaping

Insert multiple rows at once with CodeIgniter's active record method...

php sql codeigniter activerecord insert-query

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

php codeigniter activerecord query-builder where-in

CodeIgniter UPDATE query with multiple SET assignments and multiple WHERE conditions...

php codeigniter activerecord sql-update query-builder

CodeIgniter get_where() column IS NOT NULL...

php codeigniter activerecord query-builder notnull

Handling Conditional `belongs_to` Associations with Different Foreign Key Types in Rails...

ruby-on-rails ruby activerecord polymorphism psql

Codeigniter query to correctly encapsulate AND and OR conditions in a WHERE clause...

php codeigniter activerecord query-builder logical-grouping

Value quoting isn't applied when calling CodeIgniter's having() method...

php codeigniter activerecord query-builder having

What is the purpose of the CodeIgniter's get() active record method?...

php codeigniter methods activerecord query-builder

CodeIgniter active record query to return rows where a column value is LIKE one of potentially multi...

php arrays codeigniter activerecord sql-like

$side parameter of CodeIgniter 2.1.0's like() method added "both" wildcards despite be...

php codeigniter activerecord sql-like codeigniter-2

CodeIgniter active record query with multiple OR LIKE conditions and AND WHERE conditions...

php mysql codeigniter activerecord sql-like

Rails: select unique values from a column...

ruby-on-rails activerecord

Codeigniter active record update query to conditionally increment a column value...

php mysql codeigniter activerecord increment

Grouping WHERE clause logic with CodeIgniter active record query...

php codeigniter activerecord query-builder logical-grouping

CodeIgniter active record query to return a column value from a single row otherwise a default value...

php sql codeigniter activerecord query-builder

Select all columns from a CodeIgniter active record query with two joins...

php mysql codeigniter activerecord query-builder

CodeIgniter query to return the row count with multiple where conditions...

php mysql codeigniter activerecord query-builder

CodeIgniter select() method with two parameters only returns one column in result set...

php mysql codeigniter activerecord query-builder

Write query with JOINs, GROUP BY, and SUM()s using CodeIgniter's query building methods...

php mysql codeigniter activerecord query-builder