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…)CodeIgniter 4
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…)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…)Free Medium Series – CodeIgniter 4 CRUD with MySQL
Generally, most all web applications are going to follow the elements of CRUD: Create, Read, Update, and Delete. CodeIgniter 4 is a powerful PHP web development framework that provides a rapid development environment. The CodeIgniter 4 Models come enriched with built-in CRUD functionality, which is covered in this compilation of Medium posts…
(more…)