OpenLampTech issue #36
PHP comparison operators; Get your website ready to win; MySQL ALTER TABLE; Let's play some SQL games; Installing WordPress in a subdirectory. Thank you for reading OpenLampTech!
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
Like I’m always saying, in today’s data landscape, you are going to process string and text data regularly. PHP has many many string functions built right into the language. Here are 7 of them you may not know about but should…
Continue reading the article, 7 PHP String Functions You Should Know and How To Use Them.
Recently Published in the OpenLampTech Publication
WordPress Wednesday #4 was published in the OpenLampTech publication this week.
There are several great WordPress-related articles I curated in this piece:
Linux | Apache | MySQL/MariaDB | PHP
I have curated some fantastic reads for you this week. Let’s get to them!
Difference between “ == “ and “ === “ operators
By: professional writer
This is a short, but valuable, article about one of the more important topics on comparisons in PHP (in my opinion).
==" tests only for value, "
===" tests for value and type equality.
I try to keep this in mind in any conditional tests I write in my code.
17 Ways to Get Your Website Ready to Win
By: Ash Allen
Ash Allen creates and shares some fantastic Laravel content.
In this article, we learn about several action items you can take to make your website the best it can be.
These are my favorites (that I definitely should work on myself):
Make Sure Your Website is Responsive
Reduce Clutter in Your Pages and Navigation
Invest in Better Photography and Images
3 SQL Games to Level up your SQL Knowledge
By: Vikas Rajput
Ready for some gaming!?! 🎮 🥌
Get your game hats on and test your knowledge with these SQL games.
I've not personally played them all myself but, I am a SQL fanatic (in a sense) and I love challenges and learning more and more SQL.
Needless to say, I'm excited about some SQL gaming.
The Darker Side of ALTER TABLE: A Guide
Learn valuable details and information about the
ALTER TABLE Data Definition Language (DDL) command in this fantastic article from Arctype.
I'll be the first to admit that I take
ALTER TABLE for granted.
However, after reading this article, I'm reminded of just what is going on behind the scenes of an
ALTER TABLE command.
Related: MySQL ALTER TABLE – Add Multiple Columns
Good stuff here, folks.
WEB STACK IMPLEMENTATION (LAMP STACK) IN AWS
By: Emmanuel Akanji
#php #mysql #lamp #linux #apache
This article has a great introductory piece on what the LAMP stack is and how each individual component contributes to the overall whole of the stack.
We then learn how to deploy the LAMP stack to an AWS EC2 instance.
Similar: What is the LAMP stack?
18 Tips to Optimize Your Laravel Database Queries
By: Srinath Reddy
The application database is integral and a necessity but can quickly become the bottleneck for any number of reasons. We should always make the queries as efficient as possible.
In this article, see examples of how to optimize your Laravel Queries.
I like these common tips:
Select only the columns you need.
Avoid unnecessary queries.
Index frequently queried columns.
The Ultimate Guide to Installing WordPress in a Subdirectory
By: Iain Poulson
If you don’t want WordPress installed in the web root directory, it is possible to install the CMS in a subdirectory.
However, there are some pros and cons to installing WordPress in a subdirectory and this article covers them and has step-by-step instructions on how to do it.
Why Do Developers Prefer Linux?
By: Joseph Mania
I realize that this isn't a one size fits all type of thing.
But, if I'm being honest, I am in the Linux camp. And have been for a few years now.
I use Windows in my (somewhat) non-developer day job because that's what we get and use.
But, when I'm on my time working on my stuff, Linux all the way.
I'll admit, I used to enjoy installing and playing around with different distros whereas now, I just want something that works that I can blog and code on with no fuss.
So, it's Linux Mint for me.
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
Jack of All Trades, Master of Some
"Turns out, it's not so bad of a thing."
Beating Imposter Syndrome. With a bat, if you must.
"I'm swinging for the fences."
100 Resources for the Future that Freelance Writers, Content Writers, and Copywriters NEED
"We can all literally write our own future."
How to set up on-page SEO for your SubStack Articles the FREE and EASY way!
"Boosting your Substack's growth."
How to Create a Subdomain in cPanel
"I had to learn this here recently."
Thank you for reading OpenLampTech. This post is public so feel free to share it.
Cool PHP Tweet
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!
Some inspirational ‘Thank You’ cards are in this Etsy Shop.
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.