OpenLampTech issue #32
MySQL COUNT(); 100 WordPress facts; PHP Interfaces; 6 depreciated Linux commands. 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:
Recently Published on the Digital Owl’s Prose Blog
Over on the Digital Owl's Prose developer blog, I published an article about finding all tables’ current AUTO_INCREMENT
values in MySQL.
Read the post, Find All Table's Current AUTO_INCREMENT Value, to learn more.
In this week's OpenLampTech publication, I shared the article: OpenLampTech Report - What is the LAMP stack?
Housekeeping
For some reason, last week's OpenLampTech newsletter issue #31 did not mail out or was not properly delivered (or both). My apologies to all of you. Here is last week's issue:
Save the date - Coming Soon 🔜
I'm publishing a fantastic developer interview with Ben Brumm of the Database Star Academy website. Look for this text-based interview to land in your inbox on June 28th, 2022, and be full of valuable insight.
Linux | Apache | MySQL/MariaDB | PHP
I have curated some fantastic reads for you this week. Let’s get to them!
MySQL COUNT() – the essence, syntax, and types
By: DbForge Team
#mysql
COUNT()
is one of the standard SQL aggregate functions used to count rows or column values in a table.
In this article, we see examples and have explanations on using COUNT()
with:
The
WHERE
clauseThe
HAVING
clauseThe
GROUP BY
clause
Related: MySQL COUNT(*) and COUNT(column or expression) — Differences
The Disadvantages of WordPress
By: Kim Coleman (Discovered via WPShout)
#wordpress
Definitely, something you don't see much of.
I strongly feel it is just as important to know what tool not to use as it is to know which tool to use.
This article covers topics you should consider if you're going to use WordPress instead of other SaaS or site builder products (I'm thinking Wix, Squarespace, etc).
Here are a few that stuck out to me:
Self-hosting WordPress and maintaining the site and all updates.
Knowing which themes and plugin products work well together.
You can do whatever you like with your site, which may not always be the best thing to do.
6 deprecated Linux commands and the tools you should be using instead
By: Jose Vicente Nunez (Sudoer)
#linux
The Linux command line is where magic and power converge. I'm far from a grade-A Linux sysadmin but I am comfortable using - and learning - Linux commands.
Here is an article that covers depreciated commands and those to use instead.
For a couple of these commands, I didn't even know of the depreciated versions much less their current counterparts so this article is a good learning resource for me.
Drupal is dying!
By: Maxime Topolov
#php #drupal
Oh no!
But, is Drupal really dying?
I'm thinking about these points (although I absolutely don't have any answers):
Drupal is dying because it's too complex - Perhaps I'm not the best judge because pretty much everything is too complex for me lol. 🤣🤣🤣
Drupal is dying because it's running on PHP - Maybe more PHP developers need to learn Drupal?
Drupal is dying because it's open-source - I suppose with any open-source software you always need devs, docs, and exterminators.
Quite an interesting (and eye-opening) read.
PHP Interfaces Explained
By: Alex Web Develop
#php
Interfaces are like contracts. When a PHP class implements an Interface, that class must also then include (or implement) all of the Interface's methods.
An Interface's methods only provide the signature or definition and any arguments but not the actual implementation of the method.
So like a framework but with no directions or any other information.
Learn more about PHP Interfaces in this article with clear and easy-to-follow examples.
Buggy CakePHP Code: The 6 Most Common Mistakes CakePHP Developers Make
By: Michael Houghton
#php #cakephp
Although this blog post is written for CakePHP (with which I have no experience), I think there is always something to learn no matter which tool or framework you use.
I'm paying attention to:
Keeping business logic in the Models instead of the Controllers.
Return often and early (I've got to use this principle more myself)
Comment the code
Interesting, Incredible, Impressive – All The Best WordPress Stats & Facts
By: Janette Burhans & Aileen Javier
#wordpress
The most popular CMS is that for a reason.
Or, at least 100 reasons.
This post has 100 interesting WordPress facts you probably didn't know about. There are some quite remarkable figures reported on WordPress statistic-wise.
A fun article.
How to Autoload Classes With Composer in PHP
By: Sajal Soni
#php
I first learned about autoloading in PHP from the fantastic book, PHP & MySQL Novice to Ninja (not an affiliate link).
The spl_autoload_register()
function is used to load needed classes into memory.
Autoloading helps with fewer require
and include
directives along with using only those 3rd party classes we need.
This article covers the details of autoloading using the Composer package manager in these 4 ways:
file autoloading
classmap autoloading
PSR-0 autoloading
PSR-4 autoloading
Many articles I read and share in the OpenLampTech newsletter, I discovered 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
The ‘Form’ Element Created the Modern Web. Was It a Big Mistake?
"Thought-provoking."
"Working towards independence myself."
"I hope to publish a book someday."
"Uncannily familiar."
How much confidence is too much confidence when building your new startup?
"We need all the confidence we can get."
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 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!
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.