OpenLampTech issue #25
OpenLampTech issue #25
I've got another massive newsletter for you this week with plenty of great PHP and MySQL content. Enjoy! 📰
Hey glad to have you here! 👍
If someone shared this newsletter with you and you are not yet subscribed, please use the Subscribe button below and join:
Recently from the Digital Owl’s Prose Blog
This week over on the Digital Owl's Prose developer blog, I repurposed some existing content by sharing the original Substack article, MySQL GROUP BY WITH ROLLUP - Substack Repost, with readers there. I really enjoyed writing this article and have a Part 2 in the works so stay tuned for that.
I have curated some fantastic reads for you this week. Let’s get to them!
This Week’s Picks
✔️ MYSQL SHOW COMMANDS
By: SHAFI SHAIK
#mysql
The MySQL SHOW command is useful for admins (or anyone working with the database) to obtain information about processes, connections, and other specific database objects.
To name a few, see examples and information about:
SHOW STATUSSHOW VARIABLESSHOW TABLES
Excellent overview of many common SHOW-type commands for MySQL users.
✔️ WordPress Database/MySQL optimisation guide
By: Maria Pirzada Ansari
#wordpress #mysql
A WordPress site depends heavily on its MySQL (or MariaDB) database. This is the workhorse of the application. Where everything is stored.
Learn how to optimize the WordPress database using a plugin, along with some best optimization strategies that should be implemented at regular intervals during the life of the database.
Some of these that caught my attention are:
Remove old post revisions.
Empty the trash.
Get rid of all the spam comments.
✔️ Creating a custom post type in a Wordpress Plugin
By: Matt Calvert
#wordpress #php
There seem to be so many tidbits of valuable information for WordPress development scattered across the internet that it is difficult (for me) to even know where to start. (And, I'll gladly take any of your suggestions so please, do share.)
The author suggests moving a lot of the code required for a Custom Post type out of the functions.php file into the plugin's files as a better practice than creating a massive functions.php file.
We then learn how to register the Custom Post type with the add_action() method.
I am seriously considering putting together some kind of curated resource directory of WordPress information for those who want to learn (like me) who don't know where to begin to find it.
✔️ PHP Inheritance: How to Inherit Classes in PHP
By: Alex Web Develop
#php
Object-oriented concepts are oftentimes difficult to grasp. I personally learned so much by reading and studying the framework source code I work with (CodeIgniter 4).
This article has well-explained examples of what Inheritance is and is a good place to start if you are trying to learn about this important PHP OOP concept.
The Alex Web Develop site is one of my go-to places to learn about PHP.
✔️ An Overview of MySQL Data Types
By: Dominika Florczykowska
#mysql
I'm always excited to read the content from the LearnSQL.com website. Their articles are top-notch and filled with information for both new SQL users and seasoned alike.
The MySQL database has to have data types in order to store data properly. I'll be the first to admit that oftentimes, I take them for granted.
However, data types are a necessity, and getting them right is crucial to good design and sound data storage practices.
MySQL's data types fall into essentially 3 categories:
Numeric
Text
Temporal (date and time)
Great overview article for you to start with if you are just learning about MySQL's data types.
✔️ 25 Best Open Source Apache Projects
By: Anjali Saini
#apache
Let's face it, where would we be without the Apache Software Foundation?
Nowhere near to where we are now, that's for sure.
I have several favorites listed in this article that interest me:
HTTP Server
Spark
Netbeans
There are many others mentioned in this post. Check them out and see which of them are yours.
✔️ WP Engine Ending Support for .htaccess
By: Roger Montti
#wordpress #apache
According to this article, .htacess directives will no longer be supported on WP Engine servers as of October of 2022. It appears this removal will mostly affect sites that are using .htaccess directives with rules outside of the default WordPress rules.
Might want to keep an eye out for this if you are in this particular category of WordPress site users running on WP Engine.
✔️ PHP Data Types
By: Bilal Niaz
#php
A well-structured and thought-out article covering all of the PHP data types.
Each PHP data type has its own section containing a quick summary and accompanying code example snippet.
Perfect for bookmarking.🔖
✔️ 3 Ways to create a loop with WordPress
By: Michael Cardoza
#wordpress
Although I have PHP and MySQL experience, I'm a total newbie in WordPress development. But, as I make strides to learn more about it, articles such as this sure do help.
As the title suggests:
WP_Query- A built-in WordPress class for secure database queries.get_posts()- Function using the WP_Query class to return an array of objects.query_posts() - A function that you can use to alter the main WordPress query using provided parameters.
Use these handy HTML templates and save time on your next project.
Handy PHP Tweet (for Laravel Devs)
Handy MySQL Tweet
Extra Stuff...
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!
I’ve started up a new creative endeavor, The Techpreneur Developer Newsletter. I'd be more than grateful to be one of your Sunday morning reads.
Thank you for reading. I hope you have a great rest of your week.
Take care.
Joshua Otwell
Visit my blog Digital Owl’s Prose, where I write regularly on CodeIgniter, PHP, and SQL. I’m also active on Medium, LinkedIn, Twitter, and Instagram.
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.