OpenLampTech

Share this post
OpenLampTech issue #23
openlamptech.substack.com

OpenLampTech issue #23

MySQL WHERE clause; WordPress SeedProd plugin; WP_Query; MySQL invisible columns; Deferred Joins; Custom taxonomies in WordPress. Thanks for reading!

Joshua Otwell
Apr 22
Share this post
OpenLampTech issue #23
openlamptech.substack.com

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

  • In-depth guides

  • Deep-dive articles

  • Instructional and learning video shorts.

MySQL Content!


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.

➡️ Read this post…

✔️ 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 and OR logical operators

  • IS NULL and IS NOT NULL

  • IN()

  • String and numeric data filtering

➡️ Read this post…

✔️ 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.

➡️ Read this post…



✔️ 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.

➡️ Read this post…

✔️ 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.

➡️ Read this 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.

➡️ Read this post…


Useful PHP Tweet

Twitter avatar for @doekenorgDoeke Norg 🇺🇦 @doekenorg
PHP-tip 💡: When working with large arrays of entities / objects, it may be beneficial to use array_slice instead of array chuck. While it is a bit more verbose, it prevents duplication of the array, which in turn prevents extra memory usage.
Image

April 19th 2022

19 Retweets54 Likes

Support OpenLampTech, my blog, and my work with a coffee if you would like.☕


Extra stuff…

  • Developer Relations Career Insights From 7 Industry Leaders

  • How to use AnswerThePublic

  • Being an Imposter

  • How I built my tech startup as a solo developer

  • 5 open source tools for developing on the cloud

  • How to write effective marketing emails


Did you enjoy this issue of OpenLampTech? Please share it with others so that they can enjoy the content as well. Thank you!!!

Share


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.

Share OpenLampTech


Want to support this newsletter and my work? Drop some spare change in my Tip Jar.💰

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.

Share this post
OpenLampTech issue #23
openlamptech.substack.com
Comments

Create your profile

0 subscriptions will be displayed on your profile (edit)

Skip for now

Only paid subscribers can comment on this post

Already a paid subscriber? Sign in

Check your email

For your security, we need to re-authenticate you.

Click the link we sent to , or click here to sign in.

TopNewCommunity

No posts

Ready for more?

© 2022 Joshua Otwell
Privacy ∙ Terms ∙ Collection notice
Publish on Substack Get the app
Substack is the home for great writing