OpenLampTech

Share this post

OpenLampTech issue #27

openlamptech.substack.com

Discover more from OpenLampTech

The LAMP stack and the PHP technologies and frameworks it runs. Code, content, and community for developers.
Continue reading
Sign in

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!

Joshua Otwell
May 20, 2022
3
Share this post

OpenLampTech issue #27

openlamptech.substack.com
2
Share

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 ⬇️

Free eBook


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

By: Constantin

#mysql

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. πŸ™‚

➑️ Read this article…

Backup Plugin Battle: Which is the Best WordPress Backup Plugin in 2022?

By: Mike Davey

#wordpress

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.

➑️ Read this article…

How To Create A Simple Nonce in PHP

By: Simon Ugorji

#php

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.

➑️ Read this article…

Behind the Scenes: Solving deadlocks worth millions

By: Monark Dedakiya

#mysql

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.

➑️ Read this article…

How to Easily Add a Download Link in WordPress (3 Ways)

By: WPBeginner Editorial Staff

#wordpress

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.

➑️ Read this article…

PHP Array: A Gross Mistake

By: Anton Ukhanev

#php

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.

➑️ Read this article…



The Creat[ive][or] In Us

20 Web Design Examples for Startups

β€œ#2 sings to me.”

60+ Best Free WordPress Themes – A Complete List (2022)

β€œSo many good ones I don't know which to choose.”

How to Use (or Not Use) a Hyphen

β€œI'm so guilty of misusing it.”

A Landing Page With These 9 Ingredients Will (Damn Near) Print Money

β€œUpgrading my landing pages pronto!”


Thank you for reading OpenLampTech. This post is public so feel free to share it.

Share


How Can I Help You

  • Support OpenLampTech, my blog, and my work with a coffee if you would like.β˜•

  • πŸ“° 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.

Take care.

Joshua Otwell

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.πŸ’°

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.

3
Share this post

OpenLampTech issue #27

openlamptech.substack.com
2
Share
2 Comments
Share this discussion

OpenLampTech issue #27

openlamptech.substack.com
πŸ…ŸπŸ…πŸ…€πŸ…› πŸ…œπŸ…πŸ…’πŸ…šπŸ…ž
Writes Deplatformable Newsletter
May 20, 2022

Good stuff Joshua. I like the fact that you get your links from a lot of different places!

Expand full comment
Reply
Share
1 reply by Joshua Otwell
1 more comment...
Top
New
Community

No posts

Ready for more?

Β© 2023 Joshua Otwell
Privacy βˆ™ Terms βˆ™ Collection notice
Start WritingGet the app
Substack is the home for great writing