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!
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:
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
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).
ADDING MULTIPLE COLUMNS IN A TABLE – MYSQL
By: SHAFI SHAIK
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.
Top Laravel Twitter Accounts to Follow
By: Ashley Allen (discovered via the author's newsletter)
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.
5 Best WordPress Database Plugins 2022 (Free & Paid)
By: BetterStudio Blog
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.
The Block Editor is a Page Builder, too
By: Brian Coords
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.
Reverse an array in PHP by using recursion
By: Yongyao Yan
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.
Nick Diego: Builder Basics – Working with Templates in Full Site Editing (Part 1) 🎥
By: Nick Diego
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.
The Creat[ive][or] In Us
"I haven't read any of these and I need to change that."
"I want to pick one and go for it."
"Step by step, from start to finish."
How Can I Help You
📰 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.
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.