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:
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
In-depth guides
Deep-dive articles
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
#php
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
match()
expression.Named parameters
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)
#mysql
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:
AND
andOR
logical operatorsIS NULL
andIS NOT NULL
IN()
String and numeric data filtering
✔️ WordPress Custom Taxonomies: How and Why to Create Them
By: DAVID HAYES (WPShout)
#wordpress
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 LIMIT
and OFFSET
clauses.
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 LIMIT
and OFFSET
pagination along with Cursor-based pagination and where using Deferred Joins with LIMIT
and OFFSET
may be a better option.
Be sure and read this one, folks.
✔️ Poorman’s MySQL table audit information
By: LEFRED
#mysql
This is a fantastic article utilizing MySQL invisible columns and triggers as a workaround for data change capture within the same table.
Since 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 SELECT
list.
Valuable information I'm just learning from this informative blog post.
✔️ WP_Query: Understand it, Love it!
By: FRED MEYER (WPShout)
#php #wordpress
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
Support OpenLampTech, my blog, and my work with a coffee if you would like.☕
Extra stuff…
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.
Take care.
Joshua Otwell
Visit my blog Digital Owl’s Prose, where I write regularly on CodeIgniter, PHP, and SQL. I’m also active on Medium, LinkedIn, Twitter, and Instagram.
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.