MySQL GROUP BY WITH ROLLUP – Substack Repost

I recently took some time to explore the MySQL GROUP BY WITH ROLLUP modifier. As a self-starter, I’m always unknowingly studying SQL concepts that I soon need for a query requirement. Call it luck or premonition, doesn’t matter to me. I’ll take these small wins thanks to my curiosity…

(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…)

5 Truths I’ve Come To Realize As a Self-taught Developer – Premium Content 🔒

When I began my self-taught developer journey back in 2016 (I go more in-depth in this RTC interview), little did I know – at that time – learning the tech side of things would be the easy part. Here are 5 hard truths I’ve come to realize, personally, on this never-ending journey…

(more…)

MySQL NULL value transformation with COALESCE() – Medium repost

Being mindful of NULL values is a good practice. NULLs can slip up on you and give you a heck of a time (especially in calculations) if you aren’t careful. In this post, we will see examples of NULL transformation with the MySQL COALESCE() function.

(more…)

OpenLampTech issue #16 – Substack Repost

Honestly, if no one ever read the OpenLampTech newsletter, that’s fine because I always do! Hey everyone, here is your dose of PHP/MySQL content to help you learn, grow, and maintain your sanity for the week. Enjoy!

(more…)