OpenLampTech issue #42
Top WordPress mistakes; Laravel custom validation rules; Time-saving MySQL date functions; PHP clean code tricks; Thank you for reading the OpenLampTech newsletter!
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:
Newsletter Shout-out 📣
Coming in September…
The summer may be winding down (depending on where you are in the world, certainly not in Louisiana) but I’m letting you know now that OpenLampTech is going to be on fire in September!!! 🔥🔥🔥
I’ve got an epic developer interview lined up for this month along with an SQL Books piece that will help you level up your SQL skills like no other.
Stay tuned!!!
Recently Published on the Digital Owl’s Prose Blog
Operating and managing a WordPress website can be daunting. Whether you are a novice just starting out, or a seasoned user with experience, you are going to make some mistakes.
Avoid the most common mistakes by reading the fantastic guest article, Top 8 Mistakes Website Owners Make With Their WordPress Websites, published this week on the Digital Owl's Prose developer blog.
Thank you, Harikrishna Kundariya, for contributing to the blog!
Recently Published in the OpenLampTech Publication
I published the OpenLampTech WordPress Wednesday #10 for August 31st, 2022. There are several links to great WordPress-related content.
Find out more in the publication piece:
[#Ad]
Every day Refind picks 7 links from around the web for you, tailored to your interests. Loved by 50k+ curious minds.
Linux | Apache | MySQL/MariaDB | PHP
I have curated some fantastic reads for you this week. Let’s get to them!
How to Create Custom Validation Rules in Laravel 9
By: TechvBlogs
#php #laravel
You need validation rules in order to store sound and safe data for your application. With the many built-in validation rules already included in Laravel, there is likely one that will suit your needs.
If not, you can absolutely create your own.
While I am familiar with the process for CodeIgniter 4, this post was a great 'learning post' for me as a non-Laravel developer.
How to Upload and store file to MySQL database in CodeIgniter 4
By: Yogesh Singh
#php #mysql #codeigniter
While I do use this same approach, there is nothing like storing your files (PDF, image, etc…) in the actual database tables in a BLOB
column.
In this article, the author shows us how to upload a file using some of CodeIgniter's built-in convenience file handling. Storing the file's name and uploaded path in the database allows for retrieval throughout the application.
Web Scraping with PHP: a Step-By-Step Tutorial
By: Antonello Zanini
#php
When I think of PHP, I honestly don't think of web scraping. And, I'm not 100% sure where I sit regarding web scraping. But that's another story for another day.
Using the simple_html_dom
Composer package and PHP’S built-in cURL
library, this article details a good walkthrough on building a simple scraper.
Top 10 Time-Saving MySQL Date Functions
By: Aparna Gurav
#mysql
Being able to manipulate or retrieve Date values in SQL is important for any number of reasons. Imagine if the payroll department couldn't figure out an employee's hours for the pay period. 🤔
Some of my favorite MySQL Date functions I use quite often from this list:
CURDATE()
EXTRACT()
DAYNAME()
Similar: 5 PHP Date Functions and Their MySQL Equivalents
How to Customize WordPress Admin Dashboard (6 Tips)
By: WPBeginner
#wordpress
I operate and manage 3 personal WordPress sites and the last thing I want is a cluttered Admin dashboard.
Read this article by the fantastic WPBeginner blog for 6 tips on how to set up the Admin dashboard for a better experience.
Clean code tricks in PHP everyone should follow
By: .com software
#php
We all could use some tips and tricks to help us with our code. I know for certain that I can always improve my code, be it structure or just readability.
Here are 3 tricks I'm taking away from this article with the plan to learn more about and implement them myself as I can:
Remove unnecessary condition clauses
Invert conditions to reduce code indentations ('returning early')
Use array destructuring
I discover many articles I read and shared in the OpenLampTech newsletter 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.
Interesting book 📚
In one of the newsletters I read, I saw where this book is coming soon and you can grab it for free: The Database Handbook For Developers
The Creat[ive][or] In Us
50 content creator tools you need to know about
"Chances are you won't use them all. But, it sure can't hurt to know about them."
Open source runs on non-code contributions
"Open source is everywhere and non-code too."
The 5-hour rule: How to turn a wasted day into a successful one
"Make the most of every 24 hours you get."
"I could easily become a Ghoster myself."
The Evolution of the Modern Web Application Development
"All things evolve. Even the Web."
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 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!
Some inspirational ‘Thank You’ cards are in this Etsy Shop.
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.
[#Affiliate]
I operate 2 niche WordPress websites and 1 CodeIgniter application, all proudly hosted on Hostinger. I couldn’t be happier with their product and support. Plus, they offer free SSLs.