activerecord Examples and Free Source Code

Convert SQL containing a subquery and multiple OR WHERE conditions to CodeIgniter's active recor...

php sql codeigniter activerecord query-builder

Reserved names with ActiveRecord models...

ruby-on-rails ruby-on-rails-3 activerecord ruby-on-rails-3.2 active-record-query

How do I order by lower-cased field on an aliased association without manually specifying a join?...

ruby-on-rails activerecord ruby-on-rails-7 arel

Convert a SELECT query containing two WHERE conditions to CodeIgniter's active record syntax...

php mysql codeigniter activerecord query-builder

CodeIgniter SELECT query to find rows with qualifying sets of column values in a JOINed table...

php mysql codeigniter activerecord logical-grouping

Can I add comments to a table or column using ActiveRecord Migrations?...

ruby-on-rails activerecord rails-migrations

How to count results per group in CodeIgniter?...

php codeigniter activerecord counting

Count number of query results in a CodeIgniter application...

php mysql codeigniter activerecord count

Convert raw MySQL containing a JOIN on identical column names and a WHERE and ORDER BY clause to Cod...

php mysql codeigniter activerecord query-builder

Convert raw UPDATE SQL containing CASE statements in the SET clause into CodeIgniter query builder m...

php mysql codeigniter activerecord query-builder

Get records from a database table which relate to qualifying rows in another table using CodeIgniter...

php mysql codeigniter activerecord query-builder

Return a flat array of column values from a CodeIgniter active record query...

php arrays codeigniter activerecord array-column

Codeigniter's `where` and `or_where`...

php mysql codeigniter activerecord

PHP paging show page indicator...

php mysql activerecord pagination indicator

Convert SELECT query containing equals comparison and 3 OR LIKE conditions to CodeIgniter active rec...

php codeigniter activerecord query-builder logical-grouping

Convert this SQL containing comma-JOINs related by identical column names to CodeIgniter active reco...

php codeigniter join activerecord query-builder

MySQL, Rails ActiveRecord date grouping and timezones...

mysql ruby-on-rails ruby activerecord timezone

ruby raised another command is already in progress...

ruby postgresql activerecord psql pg

Convert SQL containing GROUP BY and SUM() to active record in CodeIgniter...

php sql codeigniter activerecord query-builder

CodeIgniter SELECT query on table with JOIN and WHERE IN a subquery...

php mysql codeigniter activerecord query-builder

Apply greater than operator or less than operator in a CodeIgniter where() method call...

php codeigniter activerecord where-clause query-builder

Add WHERE clause condition starting with CASE using CodeIgniter's query builder methods...

php mysql codeigniter activerecord query-builder

How to revert/undo local changes to an Activerecord object?...

ruby-on-rails ruby activerecord

JOIN parent table to a many-to-many table using CodeIgniter query building methods...

php mysql codeigniter activerecord query-builder

Codeigniter query to search for any word in user-supplied phrase...

php codeigniter activerecord sql-like query-builder

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

php codeigniter activerecord sql-like query-builder

CodeIgniter query to get user's highest permission level...

php arrays codeigniter activerecord

How to access row values of an array populated by CodeIgniter's result_array()...

php arrays codeigniter activerecord resultset

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