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…

Image by  …

Hey all good folks! I’ve published another issue of your favorite newsletter, OpenLamp.tech, the newsletter for PHP/MySQL developers. This issue (like all the rest) is loaded with fantastic curated content. Enjoy and do share with others!

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. Since coffee is my favorite drink, you can even buy me one if you would like!

I enjoy writing and curating the OpenLamp.tech newsletter. If you would like to support my efforts and you are finding value in the weekly publication, please share this post or an issue with someone you think would value the content as well.

The Newsletter for PHP and MySQL Developers

In this week’s issue, we have …

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:

• A huge list of 52 SQL optimization strategies.
• Installing WordPress on Oracle Linux.
• A look at PHP’s isset() language construct.
• Fixing the “too many redirects” error in WordPress.

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

Over the weekend I’ve published another issue of OpenLamp.tech, the newsletter for PHP/MySQL developers. There is plenty of great curated content for you so dive right in and enjoy!

If you’re a PHP/MySQL developer, this free weekly newsletter is for you.

I’ve curated some great reads for you this week from around the web. Stories you can enjoy in this issue are:

• Distance querying with MySQL geospatial functions in Laravel
• Cursors and for loops in MySQL stored procedures
• Great YouTube channel/video recommendations for learning PHP

Don’t wait on me each week to repost here. Sign up and have each issue delivered directly to your inbox so you don’t miss any.

The monthly deep-dive featured issue releases on the last Friday …

Issue #3 of OpenLamp.tech, the newsletter for PHP/MySQL developers, is now available. This is the deep-dive/featured piece edition, 5 MySQL String Functions You Should Know, and you don’t want to miss it…

Image by Harish Sharma from Pixabay 

Deep Dive – Feature Edition

On a monthly basis, in addition to the weekly curated content, OpenLamp.tech …

I recently learned how to use MySQL to generate MySQL statements for several admin-type Data Definition Language (DDL) SQL queries I needed to execute on the server. For many DBA’s this is likely nothing new and in fact, is a well-used tool in their kit. However, I mostly focus on developer-related tasks, so it is a fresh-in-my-mind learning experience. Continue reading for more information…

Some backstory for context

I’ve recently been porting over an existing vanilla PHP application to CodeIgniter 4. One of the new features is bootstrapping all of the necessary MySQL CREATE TABLE statements dynamically based on information parsed from a .fxl file (which is close kin to a .xml file structure-wise).

Each CREATE TABLE statement is complete with FOREIGN KEY constraint clauses to ensure data integrity between linking …

Hey friends over the weekend (Friday actually) I’ve published another issue of my weekly newsletter, OpenLamp.tech. Continue reading for more information…

This issue is full of great curated reads as well as a specific question I’ve asked readers and the community. Looking for some suggestions on planned migrations for upgrades to my WordPress site.

The Newsletter for PHP and MySQL Developers

In this weeks newsletter, there’s information on:

Here’s the full issue for you to read. You can always subscribe (it’s free) and have the weekly issue of OpenLamp.tech delivered directly to your inbox. Just think, no more waiting for me to post it here each Monday.

Visit the sign-up form below to …

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 …

Over the weekend, I’ve published the 1st issue of my new weekly free newsletter, OpenLamp.tech. I’m so excited about this newsletter. Read on to learn more…

What is the OpenLamp.tech newsletter

OpenLamp.tech is a free newsletter unlike any other that I’m aware of. If it existed, I would be reading it.

Instead, I created it. Let me explain…

Image by Mahesh Patel from Pixabay

Developer, Writer, …

CSV or SQL? SQL or CSV? How about together? Without a doubt, CSV’s are one of the most common and familiar data interchange formats. Importing and exporting CSV data into or out of an SQL database is a staple process in most every data workflow. I’ve written numerous blog posts on both importing and exporting CSV data in an SQL environment. In this post, I am including all of these specific posts (as of the time of writing) in one easy-to-read and centralized location…

Image by xresch from  …