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?

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:

OpenLampTech issue #31

---

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 clause

• The HAVING clause

• The GROUP BY clause

Related: MySQL COUNT(*) and COUNT(column or expression) — Differences

↗️ Read this article…

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.

↗️ Read this article…

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.

↗️ Read this article…

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.

↗️ Read this article…

---

---

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.

↗️ Read this article…

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

↗️ Read this article...

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.

↗️ Read this 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:

1. file autoloading

2. classmap autoloading

3. PSR-0 autoloading

4. PSR-4 autoloading

↗️ Read this article…

---

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."

The Jigsaw of Independence

"Working towards independence myself."

I Made $5M Self-Publishing Books Online—Here Are 7 Things I’d Do Differently if I Were Starting From Scratch in 2022

"I hope to publish a book someday."

The Solo Developer

"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.