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

OpenLampTech issue #33 – Substack Repost

The publication is growing and we are sharing the good stuff in this OpenLampTech newsletter issue. Developer interviews, a curated WordPress resource, and the LAMP stack coverage you expect are all coming at ya in issue #33…

(more…)

CodeIgniter 4 Query Builder where() function and parameter structure with MySQL

In SQL, the WHERE clause filters rows returned by the FROM clause table in SELECT queries using one or more search condition filters. Oftentimes, in application development, we accept user input values which in turn, are the WHERE clause conditional filters against the table columns. In this post, I am covering the CodeIgniter 4 where() function and parameter binding for safer filtering in SELECT queries. Continue reading and see examples in MySQL…

(more…)