OpenLampTech

Share this post
OpenLampTech issue #25
openlamptech.substack.com

OpenLampTech issue #25

I've got another massive newsletter for you this week with plenty of great PHP and MySQL content. Enjoy! 📰

Joshua Otwell
May 6
Share this post
OpenLampTech issue #25
openlamptech.substack.com

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:

Receive a free copy of my eBook, “10 MySQL Tips For Everyone” when you subscribe to the weekly OpenLampTech newsletter!

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 STATUS

  • SHOW VARIABLES

  • SHOW TABLES

Excellent overview of many common SHOW-type commands for MySQL users.

➡️ Read this post…

✔️ 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.

➡️ Read this post…

✔️ 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.

➡️ Read this post…

✔️ 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.

➡️ Read this post…



✔️ 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.

➡️ Read this post…

✔️ 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.

➡️ Read this post…

✔️ 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.

➡️ Read this post…

✔️ 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.🔖

➡️ Read this post…

✔️ 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:

  1. WP_Query - A built-in WordPress class for secure database queries.

  2. get_posts() - Function using the WP_Query class to return an array of objects.

  3. query_posts() - A function that you can use to alter the main WordPress query using provided parameters.

➡️ Read this post…


Use these handy HTML templates and save time on your next project.


Handy PHP Tweet (for Laravel Devs)
Twitter avatar for @_devOnFiredotun_oyetunde @_devOnFire
I love Laravel😍😍 #laravel #php #Database

Laravel Eloquent @LaravelEloquent

#Laravel #Eloquent Tips: These are some quick commands that #Laravel provides you out of the box, each of them has options that enable you more control. For more details: https://t.co/PzsJyfFHXJ #Laravel #Database #PHP https://t.co/3xHfpv6OJf

April 30th 2022

1 Like
Handy MySQL Tweet
Twitter avatar for @ChiragPallanchirag pallan @ChiragPallan
Day 34 | Apr 30, 2022 #100daysofcode #SQL #MySQL
Image

April 30th 2022

6 Retweets9 Likes

Extra Stuff...

  • The Future of Substack

  • Entrepreneur spotlight: the next step in paid writing with Matthias Bohlen

  • Guest Post: Research and the Author

  • MariaDB Documentation PDF

  • The Complete Guide to Regular Expressions (Regex)


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

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.

Share this post
OpenLampTech issue #25
openlamptech.substack.com
Comments

Create your profile

0 subscriptions will be displayed on your profile (edit)

Skip for now

Only paid subscribers can comment on this post

Already a paid subscriber? Sign in

Check your email

For your security, we need to re-authenticate you.

Click the link we sent to , or click here to sign in.

TopNewCommunity

No posts

Ready for more?

© 2022 Joshua Otwell
Privacy ∙ Terms ∙ Collection notice
Publish on Substack Get the app
Substack is the home for great writing