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:
Recently Published on the Digital Owl’s Prose Blog
This week over on the Digital Owl's Prose developer blog, I reshared the original OpenLampTech publication piece, What is the LAMP stack, with readers.
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
#wordpress #php
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
#linux
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 su
and 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
#mysql
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 JOIN
types: INNER
, OUTER
, and CROSS
.
My favorite Laravel development environment, with Docker, Nginx, PHP-FPM Xdebug in VSCode
By: Fabio
#php #laravel
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
#php
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
#php #wordpress
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
#php
I know I've written some ugly nested if
/else
statements myself. In this article, the author covers using arrays and returning early to mitigate having many nested if
/else
statements.
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
How to create an airtight contract for your creator business
"Everyone signs accordingly."
Popular Tech Stack for Startups in 2022
"Build a foundation."
40 One-Sentence Creativity Tips
"All it takes is one to spark."
"We are all writing online."
Success is Created One Thought at a Time
"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
Support OpenLampTech, my blog, and my work with a coffee if you 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!
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.💰
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.