CodeIgniter 4 Query Helper getLastQuery() method – MySQL Prototyping

I’m resharing a post I first published over on my Medium account for interested readers here. As you know, SQL is my passion and sweet spot. But, I also have an affinity for PHP and CodeIgniter. Continue reading and learn how I prototype Query Builder patterns in CodeIgniter 4…

(more…)

CodeIgniter 4 Query Builder set() function with update()

CodeIgniter 4 Query Builder class has an update() function used to process UPDATE Data Manipulation Language (DML) commands. Using update() as a standalone function call is perfectly valid. However, there is also a set() function used for setting column values as you would with the SET keyword in an SQL UPDATE statement. Used in conjunction with the Query Builder where() function, you can easily UPDATE column values for an individual row or multiple rows. Continue reading for more information…

(more…)

CodeIgniter 4 anchor() URL Helper function

Here as of late, I’m leaning on every piece of built-in functionally of the CodeIgniter 4 framework I can. One I’ve been using a great deal is the anchor() URL helper function. Continue reading to learn more about this function…

(more…)

Enable File Attachment with CodeIgniter 4 form helper

The CodeIgniter 4 PHP framework has many built-in helper libraries. One of them I use a great deal is the form helper. In this post, I’ll cover using specific form helper library methods for file attachment uploads…

(more…)