CodeIgniter 4 Query Builder union() and unionAll() methods

UNION and UNION ALL set operators return the combined rows from 1 or more SELECT queries. CodeIgniter 4 Query Builder now supports UNION and UNION ALL queries with the $builder->union() and $builder->unionAll() methods respectively. Learn how to create these types of queries in this article.

This article and many to follow, are part of a series of articles I am writing and sharing as I learn new concepts when I learn them. I think of it as a duty in sharing the things I learn as a self-taught developer. We all need to support one another as we continue to learn and grow. #buildinpublic #learninpublic #indiehackers #developer

(more…)

Create CodeIgniter 4 Models With Command Line Generators

I’m all about saving time wherever I can in coding projects. In CodeIgniter 4, there are some handy commands you can use and save a lot of time setting up base file scaffolding: Command Line Generators (CLG). I recently explored using CLGs for Model scaffolding and was impressed with the time savings.

(more…)

CodeIgniter 4 Query Parameter Binding with examples in MySQL

As powerful and useful as the CodeIgniter 4 Query Builder class methods and functions are, there are times when you need to hand-craft your own queries. Perhaps they are complex. Or, you would just rather write the raw SQL. Learn how to safely use the input you need – typically as part of the WHERE clause conditional(s) – using 2 different parameter binding variations with examples in MySQL.

(more…)

CodeIgniter 4 Query Builder join() Method Explained

The CodeIgniter 4 Query Builder class provides ORM-like functionality for Database operations in the framework. As developers, we know SQL JOINs are foundational and oftentimes required in order to retrieve the correct data. The Query Builder class has a dedicated join() method you can use when constructing queries where JOINs are necessary. Continue reading and learn how to use the CodeIgniter 4 Query Builder join() method…

(more…)

Counting with countAll() and countAllResults() in CodeIgniter 4

Getting a count of table or query rows in CodeIgniter 4 is quite easy using either of the Query Builder countAll() or countAllResults() functions. Continue reading to see examples of each…

(more…)