OpenLampTech issue #100
Access PHP variables | MariaDB's future | More Awesome Motive acquisitions | SQL join flavors. OpenLampTech is a media and content source for PHP, MySQL, and the LAMP stack.
Thank you for reading the OpenLampTech developer newsletter!
If someone awesome shared this newsletter with you and you are not yet subscribed, please use the Subscribe button below and join:
OpenLampTech has sponsorship opportunities for your brand, product, or service in the weekly newsletter. As an independent publication, collaboration is very affordable. Inquire by email at openlamptech@substack.com for more information on how you can reach the OpenLampTech readership.
OpenLampTech continues to be a sounding board for developers and their stories. I've published another fantastic developer interview this week with Kyle Galbraith.
Read it here:
[#Affiliate]
The DNS course for developers
Who is this course for?
This course is for you if you want to gain mastery over DNS.
It assumes you have a basic understanding of how the internet works, but you don't need to be an expert. This course assumes no prior networking experience and involves no programming.
If you've worked on DNS full-time for over a year, this course is probably not for you. Otherwise, you'll learn a lot! If you invest in your knowledge today, you'll benefit for the rest of your career.
All commentary is by me unless otherwise quoted.
How to get a variable to a PHP file from another PHP file?
This article highlights 3 different ways you can get a PHP variable from one file - and access it - in another PHP file. We think about include
and require
. But, there are other ways as well. One of these I forgot about until I read this piece. [Medium]
The Financial Future of An Essential Open-Source Data Provider Hangs In the Balance (October 5th, 2023)
I don't know enough about any of the stuff going on with MariaDB to even add any relatable context here so I'll keep my trap shut about that. I hope MariaDB makes it. Whatever that looks like. Be it as is or acquired by another company. There are tons of applications that run on the backbone of MariaDB. [RealClearMarkets]
MariaDB plc Enters Into $26.5 Million Financing Agreement (October 10th, 2023)
According to this article, MariaDB is restructuring its board of directors with many of them resigning. More juicy details in this piece about the future of MariaDB. MariaDB powers some big-name company's data and is installed on many Linux distros. I have a feeling MariaDB is soon to be acquired. [businesswire]
Stellar Repair for MySQL – This Tool Fixes Corrupt MySQL Databases
Here's to hoping that your website or application never needs this tool. But, chances are, at some point a database table will become corrupt or fail. Stellar Repair for MySQL gives you that fighting chance to fix (and hopefully recover) your MySQL database. [WinBuzzer]
Meet the man whose software empowers millions worldwide: Syed Balkhi
Okay. I may fall out of favor here. And I do mean this with the utmost respect. But, isn't Awesome Motive (AM) like the mafia of WordPress? I mean, Mr. Syed Balkhi and the company are one mammoth of a juggernaut in WordPress. Ignore them at your peril. They are "owning it" in some of the most popular and useful categories of WordPress plugins. Good for them. I use a lot of (the free) AM products myself. [The Express Tribune]
Why use declare(strict_types=1) in PHP – Fast tips
(Note: I first discovered this article originally shared in my buddy Reuben Walker's fantastic Symfony Station newsletter. Shoutout for the great content Reuben always publishes.)
Since PHP is a loosely typed language, you may want to force strictly typed behavior such as that found in Java and C++. This PHP directive will enact strict type-checking for function and method variables along with the PHP file's code block. [inspector]
An SQL JOIN
is a staple of the query language. If you're working with (and you should be) normalized data, you're going to have to use a JOIN
at some point. However, all JOIN
s aren't created equal, and knowing their differences and which to use is table stakes. This article is one of the best I've read that explains JOIN
s. [antonz.org]
[#Affiliate]
Take your Laravel applications to the next level. Learn how to improve the performance, maintainability, and security of your Laravel projects in this e-book by Ash Allen.
WooCommerce News and Release Information
WooCommerce 8.2.0 Released (October 10th, 2023)
WooCommerce Blocks 11.3.0 Release Notes (October 11th, 2023)
[#Classifieds, Affiliates, and Click Ads]
🤝 OpenLampTech earns a small commission (or payment in some form) from many of these links. Your support helps keep the weekly OpenLampTech newsletter free for readers.
I’m an avid photographer selling prints over on my Darkroom page. Help support me with a purchase today.
We make incorporating a company as easy as possible so that you can focus on the essential things. Visit IncFile today.
Compliantly hire anyone, anywhere, in 5 minutes with Deel
Deel is your one-stop shop for hiring, paying, and managing your remote team.
Thank you for reading. I hope you have a great rest of your week.
Take care.
Josh Otwell
When you are ready, here are more ways I can help...
Content and Development Services - Blog writing and editing; Shopify and WooCommerce customizations; Email newsletters, marketing, and copywriting.
Interested? Great!
Just hit Reply and ask for more information about any of these services.
OpenLampTech is a reader-supported publication. You can support the publication with a virtual coffee for as little as $3 (USD).