codeigniter Examples and Free Source Code

Get the sum of a column for the logged-in user with CodeIgniter's query builder...

php codeigniter session sum query-builder

How to execute a SELECT SUM() query using CodeIgniter's query builder methods...

php codeigniter select sum query-builder

SUM() values from a single column using CodeIgniter's query builder...

php mysql codeigniter sum query-builder

SELECT SUM() of column values from qualifying rows using CodeIgniter's query builder...

php mysql codeigniter sum query-builder

Select and count record from database using codeigniter active query method...

php codeigniter join count query-builder

SELECT COUNTs of specific column values from qualifying rows in a JOINed table using CodeIgniter&#39...

php codeigniter join aggregate-functions query-builder

CodeIgniter Check if database is wrong...

php mysql database codeigniter configuration

Using group_start with codeigniter. Need OR instead of AND...

php codeigniter where-clause query-builder logical-grouping

( (Where and Where) OR (Where and Where) ) CodeIgniter...

php mysql codeigniter query-builder logical-grouping

How to check if a parenthetical group is open in CodeIgniter's query builder - group_start() was...

php mysql codeigniter query-builder logical-grouping

ORDER BY a column DESC except swap the first and second rows in CodeIgniter...

php mysql codeigniter sql-order-by

ORDER BY a column with CodeIgniter...

php mysql sorting codeigniter sql-order-by

ORDER BY a specific value in a column using CodeIgniter's query builder...

php codeigniter comparison sql-order-by query-builder

CodeIgniter: CRUD order_by error...

php mysql codeigniter crud

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

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

"Call to undefined method CI_DB_mysql_result::order_by()" when chaining CodeIgniter's ...

php codeigniter query-builder

Convert SELECT query with GROUP BY and ORDER BY COUNT(*) to CodeIgniter's active record...

php mysql codeigniter sql-order-by query-builder

SELECT WHERE a group of OR IN () conditions AND a group of OR LIKE conditions using CodeIgniter'...

php codeigniter where-clause sql-like where-in

SELECT query with WHERE, WHERE IN, LIKE, AND, and OR expressions using CodeIgniter's query build...

php codeigniter where-clause query-builder logical-grouping

Passing an associative array to CodeIgniter's where_not_in() is not rendering the WHERE NOT IN e...

php codeigniter codeigniter-3 notin codeigniter-query-builder

SELECT rows from a table WHERE the id is not found in a second table using CodeIgniter's query b...

php codeigniter query-builder notin anti-join

How to append a LIMIT clause to a raw MySQL query in CodeIgniter...

php mysql codeigniter limit

codeigniter order by desc not working properly for more then 2 or 3 digits...

php mysql codeigniter sql-order-by natural-sort

SELECT all rows FROM multiple tables in one trip to the database using CodeIgniter's query build...

php mysql codeigniter codeigniter-3 query-builder

How to remove duplicate values from GROUP_CONCAT() in CodeIgniter's select()...

php mysql codeigniter query-builder group-concat

GROUP BY column prefix and COUNT() per group with CodeIgniter's query builder...

php codeigniter group-by query-builder counting

Writing a SUBSTRING() call in CodeIgniter's select() method renders SQL with corrupted quotes...

php codeigniter select query-builder quoting

CodeIgniter query builder with multiple OR LIKE conditions on a single column and other separated AN...

php codeigniter where-clause query-builder logical-grouping

CodeIgniter query WHERE clause with enclosed OR conditions and AND other conditions...

php codeigniter where-clause query-builder logical-grouping

SELECT rows with specific combinations of values in two columns using CodeIgniter's query builde...

php codeigniter where-clause query-builder logical-grouping