OpenLampTech issue #27
New Section - The creative in us; PHP nonces; WordPress backup plugins; MySQL CTEs; Free eBook; Thank you for reading the OpenLampTech newsletter!
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 Published on the Digital Owl’s Prose Blog
This week on the Digital Owl's Prose developer blog, I published an article sharing a video I recorded for my Kofi shop. In this video, I cover how you can use MySQL recursive Common Table Expressions and built-in date functions to find every day in a calendar month based on just 1 date. Read, Determine All Calendar Days in a Month with MySQL, for more information.
New Freebie in my Kofi Shop 🏪
I'm adding more free MySQL content and resources to my Kofi shop. This week I uploaded a free 13-page PDF eBook, “CSV Import and Export with phpMyAdmin Guide”. Grab yours here ⬇️
Linux | Apache | MySQL/MariaDB | PHP
I have curated some fantastic reads for you this week. Let’s get to them!
How to Use MySQL CTE to Group by Year and Month with Gaps
Common Table Expressions (CTEs) are one of the gnarliest SQL features. I am one happy camper when I can use a version of MySQL that supports them (v8+). But, not so much when they aren't available.
My cheap cop-out here; learn how to use them.
You'll be glad you did. 🙂
Backup Plugin Battle: Which is the Best WordPress Backup Plugin in 2022?
By: Mike Davey
I use the free version of UpdraftPlus for my Digital Owl's Prose developer blog and am happy with it.
You will have a good idea of which WordPress backup plugin to use for your site after reading this comparison article.
How To Create A Simple Nonce in PHP
By: Simon Ugorji
Nonce stands for number used once.
This in-depth article covers creating a PHP class and methods to generate and validate a nonce. There is an interesting comment in the article about a security aspect of the idea behind the code as well.
Behind the Scenes: Solving deadlocks worth millions
By: Monark Dedakiya
There is so much for all of us to learn from others who share their struggles and mistakes.
It's frightening just how subtle some bugs are but can cause so many problems.
As you will read in this article, database deadlocks can be quite problematic.
How to Easily Add a Download Link in WordPress (3 Ways)
By: WPBeginner Editorial Staff
You may want to provide downloads from a WordPress page for any number of reasons. As a matter of fact, the built-in "WordPress way" seems like a solid option (and one I was unaware of). Two others are covered here as well.
PHP Array: A Gross Mistake
By: Anton Ukhanev
School is in session in this article for my novice pea-brained self. Interesting thoughts about what PHP arrays really are under the hood.
There is so much depth in this post, I have to revisit it again several times in the future to digest it all. I'm still learning, folks.
The Creat[ive][or] In Us
“#2 sings to me.”
“So many good ones I don't know which to choose.”
“I'm so guilty of misusing it.”
“Upgrading my landing pages pronto!”
How Can I Help You
📰 Get your brand, product, or service the attention it needs with affordable classified ad placement in the OpenLampTech newsletter.
Discover premium MySQL learning material over in my Kofi Shop today!
Additional creative endeavors
I’ve recently begun another email newsletter I’ve named, The Techpreneur Developer Newsletter. This newsletter is where I am writing (and building in public) about my goals, trials, and ambitions to become successful as a full-time creator and developer using technical writing, SQL, and PHP skills. The latest issue, Figuring things out..., is available for reading.
Sign-ups are much appreciated.
Thank you for reading. I hope you have a great rest of your week.
Visit my developer blog, Digital Owl’s Prose, where I write regularly on CodeIgniter, PHP, WordPress, and SQL.
Want to support this newsletter and my work? Drop some spare change in my Tip Jar.💰
Disclosure: Some of the services and product 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.