OpenLampTech issue #35
MySQL JOINs; Linux su vs sudo; Manage WordPress with Git and Composer; PHP Logical Operators; Thank you for reading the OpenLampTech publication newsletter!!!
Hey hey glad to have you here reading OpenLampTech! 👍
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
Visit the blog's rendition here: What is the LAMP stack? OpenLampTech Repost.
Recently Published in the OpenLampTech Publication
The OpenLampTech publication shared the WordPress Wednesday #3 article for July 13th, 2022.
Check it out:
Linux | Apache | MySQL/MariaDB | PHP
I have curated some fantastic reads for you this week. Let’s get to them!
Managing Your WordPress Site With Git and Composer
By: Ross Wintle
These are 2 programs that I absolutely have to step up my game with. I know there is more to Git than
git pull and
git push. Same with Composer.
This article covers managing WordPress with both Git and Composer.
I really like these 2 passages from the article:
"Version control systems like Git are a huge help to developers, allowing collaboration on a level that wouldn’t be possible without them."
"Version control gives you the freedom to experiment, while always leaving you with the option of turning back the clock if you don’t like the results."
This is a meaty article so bookmark and reference as needed.
Linux su vs sudo: what's the difference?
By: David Both
I've used both of these commands at various times across my many personal Linux installs and never really knew the difference between them. I know they both get the job done (authentication in a sense for users lacking the privileges).
As it turns out, there is a difference between
sudo and this article explains it well.
Here is a fly-by look:
sudo- more temporary time access to needed privileges.
su- no time constraints on the escalated privilege level.
Understanding MySQL Joins
By: Neeraj Kushwsha
We have to use JOINs in SQL. There really is no way around it when working with a normalized database and the data is spread across multiple tables.
Many times, it comes down to using the correct
JOIN type in order to get all the right data for a particular query.
This article shares examples of the 3 MySQL
My favorite Laravel development environment, with Docker, Nginx, PHP-FPM Xdebug in VSCode
Here is a fantastic article for Laravel developers looking for a detailed plan to set up a sound development environment. I've not personally used any of this software, so they're all new to me.
However, I can see the benefits of having a reproducible (or familiar at the very least) dev environment and definitely want to settle on one of my own someday.
SRP: Single Responsibility Principle
By: Ben Kachoud
The Single Responsibility Principle is the first in the SOLID Design Principles for Object Oriented Programming (OOP) and says every class should have a single responsibility.
In this article, we see an example in PHP of how to implement the Single Responsibility Principle for a shopping cart type of implementation.
Understanding PHP Operators of Logic, or || and && and ! a lot more
By: David Hayes
Boolean logic controls application flow and is essential in both understanding and implementation.
While the examples in this article are in WordPress, the overarching concept is not WordPress-specific.
I absolutely love this passage from the article:
"At the risk of oversimplifying, in WordPress we simply store specific data, and then build simple little machine (called “WordPress themes”) to display that data to specific people in specific way under specific conditions."
Replace Nested If Else Statement with Array
By: Tim Oye
I know I've written some ugly nested
else statements myself. In this article, the author covers using arrays and returning early to mitigate having many nested
The null coalescing operator (
??) is used as well and it is such a handy PHP operator.
I discover many articles I read and share in the OpenLampTech newsletter on Medium. With a membership, you can read unlimited articles on the platform. Consider using my sign-up link to become a member, and at no extra cost to you, I will receive a portion of your membership fees which helps me continue publishing the OpenLampTech newsletter.
The Creat[ive][or] In Us
"Everyone signs accordingly."
"Build a foundation."
"All it takes is one to spark."
"We are all writing online."
"No shortage of thoughts from me."
Thank you for reading OpenLampTech. This post is public so feel free to share it.
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!
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.