OpenLampTech

Share this post

OpenLampTech issue #28

openlamptech.substack.com

Discover more from OpenLampTech

The LAMP stack and the PHP technologies and frameworks it runs. Code, content, and community for developers.
Continue reading
Sign in

OpenLampTech issue #28

WordPress block editor; Laravel Twitter accounts to follow; MySQL multiple columns; PHP recursion; Linux input-ouput. Thank you for being here and reading the OpenLampTech newsletter!

Joshua Otwell
May 27, 2022
2
Share this post

OpenLampTech issue #28

openlamptech.substack.com
Share

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 Published on the Digital Owl’s Prose Blog

This week on the Digital Owl's Prose developer blog, I'm continuing with more content aimed to help anyone learn the basics of MySQL. I have so many articles planned out when I find the time to write them all.

In the meantime, Range-based Filtering With the BETWEEN Operator in MySQL is a must-read if you are filtering by a range of values in a query.


New eBook in my Kofi Shop 🏪

I've added a premium 11-page eBook to my Kofi shop. "CodeIgniter 4 Query Builder join() Method Explained", is your guide to understanding the different parameters and JOIN types you can use with this built-in CodeIgniter method. Grab yours here:

Get eBook


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.


Linux | Apache | MySQL/MariaDB | PHP

I have curated some fantastic reads for you this week. Let’s get to them!

Know about Linux Input-Output Redirection

By: Suparna Ganguly

#linux

This article is all about Linux redirection, covering the 3 types:

  • stdin - standard input

  • stdout - standard output

  • stderr - standard error

One little trick I really like in Linux is redirecting a command's output to a file using '>' (or >> to append).

➡️ Read this article…

ADDING MULTIPLE COLUMNS IN A TABLE – MYSQL

By: SHAFI SHAIK

#mysql

This might not come up too often. But, when it does, it sure is handy to know how. I had this requirement not long ago for a MySQL summary table in one of my projects and wrote about it on my blog.

➡️ Read this article…

Top Laravel Twitter Accounts to Follow

By: Ashley Allen (discovered via the author's newsletter)

#laravel #php

Are you a Laravel developer?

Here is a massive list of Twitter accounts to follow if you're into Laravel.

Although I'm not (yet) a Laravel developer, there is a lot to learn from such a technical community of developers.

Therefore, I'm interested in Laravel content and find value in paying attention to this space.

➡️ Read this article…



5 Best WordPress Database Plugins 2022 (Free & Paid)

By: BetterStudio Blog

#wordpress

Database optimization and backups are crucial for any WordPress website. I've even heard a saying before that you're only as good as your best backup. 😜

One of these WordPress plugins should do the trick for you.

➡️ Read this article…

The Block Editor is a Page Builder, too

By: Brian Coords

#wordpress 

You know, once I think about it, this is right. But on the other hand, although I'm quite familiar with the block editor, I don't think I've ever used it as a page builder. 

Having only really used it for blog posts with Gutenberg, I should definitely explore it more as a builder. 

Man, the WordPress landscape is a whirlpool.

➡️ Read this article…

Reverse an array in PHP by using recursion

By: Yongyao Yan

#php

There are a plethora of PHP array functions built into the language that you can do pretty much anything you can think of with. 

However, this post revisits a more fundamental concept on recursion, which is essentially a function calling itself.

➡️ Read this article…

Nick Diego: Builder Basics – Working with Templates in Full Site Editing (Part 1)  🎥

By: Nick Diego

#wordpress

I don't typically share videos in the OpenLampTech newsletter (although I plan to more often in the future), but I'm including this Part 1 of a 3-part series I watched over on the WordPress(dot)tv site.

I really wish to learn the Full Site Editing (FSE) direction WordPress is taking and this is actually a video that I felt was definitely within my grasp as far as understanding.

➡️ Watch this video…


The Creat[ive][or] In Us

Your Guide to the 10 Best Business Books of All Time

"I haven't read any of these and I need to change that."

“Following your passion” is bullshit. Do this instead.

"Sage advice."

30 “Proven” Ways to Make Money Online Blogging with WordPress

"I want to pick one and go for it."

The Ultimate Guide to Writing Online

"Step by step, from start to finish."

I Made 100 CSS Buttons For Your Next Big Project 🚀️

"Awesome gift!"


Thank you for reading OpenLampTech. This post is public so feel free to share it.

Share


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 written and shared another Techpreneur Developer Newsletter issue this past Sunday. Read, Goal setting and side income…, to find out more about my direction with this particular creative endeavor. You may even want to join in yourself, for which I'd be most grateful. 🙏


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

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.

2
Share this post

OpenLampTech issue #28

openlamptech.substack.com
Share
Comments
Top
New
Community

No posts

Ready for more?

© 2023 Joshua Otwell
Privacy ∙ Terms ∙ Collection notice
Start WritingGet the app
Substack is the home for great writing