OpenLampTech issue #23
MySQL WHERE clause; WordPress SeedProd plugin; WP_Query; MySQL invisible columns; Deferred Joins; Custom taxonomies in WordPress. Thanks for reading!
Hey glad to have you here! 👍
If someone shared this newsletter with you and you are not yet subscribed, please use the Subscribe button below and join:
Receive a free copy of my eBook, “10 MySQL Tips For Everyone” when you subscribe to the weekly OpenLampTech newsletter!
Recently from the Digital Owl’s Prose Blog
Over on the Digitial Owl's Prose developer blog this week, I have an article covering another of my curiosities I'm working towards; learning WordPress. While I absolutely want to dig into the PHP and MySQL code of WordPress, I am dipping my toes in the world of page builders and have been building out some sample landing/squeeze pages with the SeedProd plugin. Read and see more in the post, Building Landing Pages With SeedProd.
A Message From This Week's Sponsor
This week's OpenLampTech newsletter sponsor is, me!
Help support this newsletter and my content by visiting the sponsor below. Thank you! 🙏
Join the "MySQL Learning Tier" membership over in my Kofi Shop for exclusive premium content in the form of:
Blog posts unpublished elsewhere
Instructional and learning video shorts.
I have curated some fantastic reads for you this week. Let’s get to them!
This Week’s Picks
✔️ Modern PHP
By: Dimitrios Lytras
This blog post has several handy code snippets which the author shares as examples of modern PHP features. I definitely appreciate this article as a bookmark for future reference as I'm still (and will always be) learning PHP.
A few features (of many) that caught my attention are:
The null coalescing assignment operator
I'm really digging this one, everybody.
✔️ WHERE Condition in MySQL with 16 Different Query Examples
By: DbForge Team (devart site)
Here is a fantastic primer for the MySQL
WHERE clause. The
WHERE clause helps us target and filter specific rows of data based on search conditions. A few examples this article covers are:
IS NOT NULL
String and numeric data filtering
✔️ WordPress Custom Taxonomies: How and Why to Create Them
By: DAVID HAYES (WPShout)
The WPShout website has some of the best WordPress content in my opinion and their material was the first I actually got into and began reading in earnest.
The author differentiates WordPress categories and tags (the 2 default taxonomies) so we have a better understanding of what a taxonomy is and why you may need a custom one.
Two key takeaways I learned are:
Categories are hierarchical taxonomies, being members of their parent taxonomies.
Tags are flat taxonomies, being equal and not members of other tags.
A solid resource to learn how to create a custom taxonomy.
✔️ Efficient Pagination Using Deferred Joins
By: Aaron Francis
#php #mysql #laravel
This well-written article addresses the web page pagination cycle. Being a MySQL developer and user, I'm absolutely familiar with the
However, Deferred Joins are new to me and I'm stoked to be learning about them with this blog post. The author explains the pros and cons of both
OFFSET pagination along with Cursor-based pagination and where using Deferred Joins with
OFFSET may be a better option.
Be sure and read this one, folks.
✔️ Poorman’s MySQL table audit information
This is a fantastic article utilizing MySQL invisible columns and triggers as a workaround for data change capture within the same table.
SELECT * is used quite often against the target table, invisible columns are a good choice in this particular case because they are only visible in the query results when specifically named in the
Valuable information I'm just learning from this informative blog post.
✔️ WP_Query: Understand it, Love it!
By: FRED MEYER (WPShout)
This blog post provides a high-level overview of
WP_Query in WordPress. Example code and commentary cover a simple example of
WP_Query along with additional internal links to other WPShout existing content.
This article is a good one to bookmark for future reference while learning about this key WordPress system.
Useful PHP Tweet
Did you enjoy this issue of OpenLampTech? Please share it with others so that they can enjoy the content as well. Thank you!!!
Thank you for reading. I hope you have a great rest of your week.
Want to support this newsletter and my work? Drop some spare change in my Tip Jar.💰
Disclosure: Some of the services and products links in this email are affiliate links. At no additional cost to you, should you make a purchase by clicking through one of them, I will receive a commission.