UNION and UNION ALL set operators return the combined rows from 1 or more SELECT queries. CodeIgniter 4 Query Builder now supports UNION and UNION ALL queries with the $builder->union() and $builder->unionAll() methods respectively. Learn how to create these types of queries in this article.

This article and many to follow, are part of a series of articles I am writing and sharing as I learn new concepts when I learn them. I think of it as a duty in sharing the things I learn as a self-taught developer. We all need to support one another as we continue to learn and grow. #buildinpublic #learninpublic #indiehackers #developer

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 …

Now that OpenLampTech is one year old, I have a point to prove. That I can consistently provide the MySQL, PHP, and LAMP stack communities with a valuable newsletter publication. Challenge accepted. This week’s issue is full of great content so give it a read!

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 #53, we have some fantastic content covering:

• WordPress Hooks, actions, and filters
• MySQL performance tips
• SQL TRANSACTION and Isolation Levels
• Top Linux mistakes and how to avoid them
• And much more …

The OpenLampTech developer newsletter is one year old! I honestly don’t know where the past year went. Obviously, I had my nose buried in some fantastic content since OpenLampTech publishes mostly curated newsletters.

I tell you though, don’t think it isn’t a challenge adding your own thoughts and commentary to someone else’s great content because it definitely is.

I plan to continue publishing curated content in OpenLampTech but, also cover tech reporting and news-related topics that are within the MySQL, PHP, and LAMP stack ecosystems.

There seems to always be plenty to talk about in these areas so a shortage of topics won’t be the issue (I don’t think).

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when …

Unbelievably, the OpenLampTech developer newsletter is one year old. Thank you so much for reading and making it possible! I appreciate each and every one of you.

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 this week’s OpenLampTech issue #52, we have articles covering:

• MySQL ordering with NULL
• 7 WordPress tips for professionals
• MySQL GUI clients for Linux
• Working with WordPress custom tables
• And much much more

Want to support the OpenLampTech …

This week’s OpenLampTech newsletter has a great mix of round-up posts for you across the PHP and MySQL backend web space. In just 1 more week, we are 1 year old! How nuts is that?!? Enjoy this week’s publication and share with others.

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 #51, we are looking at content covering:

• WordPress keeps the lights on
• PHP Readonly classes
• Overview of the LOMP stack
• Headless Drupal in the CMS space
• And much much more

A free …

Writing a weekly newsletter is hard, dedicated work. But, I enjoy reading each week’s edition myself and I hope you do as well. OpenLampTech issue #49 is ready for you. Enjoy this week’s content!

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 #49, we have content covering:

• Laravel Eloquent tips
• 13 Linux distros from scratch
• Improve your WordPress site’s performance
• Most popular databases for PHP
• And much much more

A free weekly subscription helps support the …

It’s hard to believe that OpenLampTech tech will be 1 year in the making and 4 more editions from now. Insane! Here’s this week’s edition with the best PHP, MySQL, and LAMP stack media I curated. Thanks for reading

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 #48, we are looking at articles covering:

• Preventing race conditions in databases
• Sending emails with CodeIgniter
• Use VIEWS in your Laravel application
• Server-side jQuery Datatables with PHP
• MySQL JSON data type
…

Welcome to this week’s OpenLampTech newsletter. I have many great articles curated for you this week. Thank you for reading and please share the publication with others.

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 #47, we are looking at articles covering:

• MySQL Spatial data types
• Build a blog backend with Laravel
• 10 Linux command-line operators
• MySQL row locking
• And much more

Want to support the OpenLampTech publication? Easy enough.

Head on over to …

Anyone operating a blog, newsletter, or other creative side hustle knows there are a lot of moving pieces involved behind the scenes. Keeping the cadence going not only requires commitment and skills, but also various tools and software…

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.

At the time of writing, the OpenLampTech developer newsletter is entering its 10th straight month of publishing so I thought it was time to share a ‘Tools of the Trade – …

We are bringing you another issue of OpenLampTech this week with many great curated articles. Enjoy those you like most and please share the publication with others. Thank you so much for reading!

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.

This week in OpenLampTech, we have articles covering:

• MySQL UUIDs
• PHP implode() and explode() functions
• LAMP stack on MySQL HeatWave
• WordPress custom single post template
• And much much more

Head over to the OpenLampTech …