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.
Image by Clker-Free-Vector-Images from Pixabay …
[Read more]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…
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
In OpenLampTech issue #33, we have great content covering:
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…
Get tailored articles with Refind delivered each day in your inbox. Refind is part of my daily reading habit. Make it part of yours by using my referral link. At no additional cost to you, I will be eligible for a premium subscription with more sign-ups from my link. “The essence of the web, every morning in your inbox. Subscribe for free“
Self-Promotion:
If you …
[Read more]Hey hey! I’ve published another issue of OpenLamp.tech, the newsletter for PHP/MySQL developers over the weekend. Come and enjoy the great content!!!
As always, I’ve curated some great reads this week for us all. I’d love it if you could help spread the word by sharing these posts with others who will value the newsletter as well.
Interested?
The Newsletter for PHP and MySQL Developers
We have a range of posts in this week’s issue covering:
Don’t wait on me to repost here each Monday. That’s 3 whole days you are waiting to read OpenLamp.tech and you don’t want to do that right? …
[Read more]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…
Image by Dariusz Sankowski from Pixabay
Disclaimer: I originally published these articles first over on …
[Read more]I recently learned of some odd behavior using MySQL BETWEEN operator queries, filtering by a DATETIME column. I wrote about this over on Medium so I am sharing the post for any readers here who are interested…
Image by _Alicja_ from Pixabay
Self-Promotion:
If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit …
[Read more]
During many decision-making phases in programming code
(conditional logic), there are times execution depends on
several different factors. Multiple conditional tests
are powerful and constraining, oftentimes requiring more than one
test to be passed in order for program flow to proceed. For MySQL
(and standard SQL in general) the CASE expression is
used for IF/THEN/ELSE
conditional logic. The post, MySQL Simple CASE Expression – with
examples, covered Simple CASE queries which
are essentially equality tests. MySQL Simple CASE is
but one variant of 2, with the other being a MySQL
Searched CASE Expression. A MySQL Searched
CASE Expression can have multiple
conditional tests in each WHEN …
Programming logic is foundational in any application or piece of
software. Without it, software wouldn’t really do much of
anything. Everything happens off of choice. In the end, some
truthy or falsy value is what makes stuff work.
For IF/THEN/ELSE logic in
standard SQL, there is the CASE expression. There
are 2 variations of the CASE Expression: Simple and
Searched. In this post, I cover the Simple MySQL
CASE expression with example queries…
Image by Nika Akin from …
[Read more]
Be it running reports or displaying data in some other
visualization, SQL SELECT column expressions should
be meaningful and understandable. To provide those valuable query
results, SQL Developers, use a multitude of available functions,
adjacent columns, or other means not readily apparent to
end-users. All that being said, the column names often suffer the
most as far as readability is concerned, taking on long function
call names or other combined expressions. But, as luck would be
on our side, there is an easy fix and that is aliasing columns
using the AS keyword. Although AS is
optional – in this particular context – I err on the side of
readability and use it when aliasing SELECT column
expressions.
Any of you who read my blog posts here regularly know I am passionate about SQL, PHP, and Back-end Development. I consider writing an integral part of my brand and growth. Continue reading and learn more about what’s on my mind lately with writing and code…
Image by Arek Socha from Pixabay
Self-Promotion:
If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. …
[Read more]
