OpenLampTech issue #37
Laravel developer interview; MySQL generated columns; PHP cURL; Yii vs Laravel; PHP solutions to common problems; Thank you for reading OpenLampTech!
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:
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
As powerful and useful as the CodeIgniter 4 Query Builder class methods and functions are, there are times when you need to hand-craft your own queries. Perhaps they are complex. Or, you would just rather write the raw SQL. Learn how to safely use the input you need – typically as part of the
WHERE clause conditional(s) – using 2 different parameter binding variations with examples in MySQL.
Read, CodeIgniter 4 Query Parameter Binding with examples in MySQL, for more information.
Recently Published in the OpenLampTech Publication
This week was a busy week for the OpenLampTech publication.
Up first, I published a fantastic text-based interview with freelance Laravel web developer, Ash Allen. (Thank you, Ash!)
Read the full interview here:
I also published the OpenLampTech WordPress Wednesday #5 for July 27th, 2022. There are several links to great WordPress-related content.
Find out more in the publication piece:
Linux | Apache | MySQL/MariaDB | PHP
I have curated some fantastic reads for you this week. Let’s get to them!
Using cURL API calls with PHP
By: Shahzaib Khan
cURL enables you to use different protocols to make a connection to and communicate with different servers.
This article provides examples of how to use
cURL with its built-in PHP functions.
Examples for the
DELETE HTTP protocols are shown for clarity and understanding.
Design Patterns in PHP 8: Singleton & Multiton
By: Max Zhuk
In this article, we see examples of both the Singleton and Multiton design patterns. Both patterns serve a different purpose however, they do somewhat resemble each other.
A common Singleton use case is for a single database connection instance while on the other hand, a Multiton could be used as a logger. Both of which are demonstrated in the code in this post.
Difference between Laravel and Yii
By: Vindaloo Softtech
#php #laravel #yii
Laravel and Yii are 2 popular PHP web development frameworks. While they may share some similarities - if nothing other than PHP - there are some differences. Here are some of their individual strengths and differences.
DBMS support options
In-depth knowledge base
Tackling 7 Common PHP Problems With Elegant Solutions
Unfortunately, there are always common problems in programming. However, there are some solutions for them if we look hard enough.
Luckily, PHP has all kinds of solutions for common problems.
In this article, I like these PHP solutions (that I would do well to remember and use):
array_key_last()to track the first and last iterations of a
array_columm()to retrieve values from a single column in a multidimensional array.
The Laravel Ecosystem
By: Ash Allen
Within pretty much any ecosystem there are terms and specific language jargon that many beginners may not know about or understand.
If you're looking for an overview of many of the packages and services available for Laravel, look no more.
Many popular services and packages are covered with information and typical use cases.
A Complete Guide to Generated Columns in MySQL
By: Arctype Team
For better or worse, I'm using Generated Columns quite frequently in some applications to store specific summary data. I like Generated Columns because once the expression that defines the column data value is in place, it's pretty much 'set and forget' (at least for me).
There are 2 types of Generated Columns, Stored and Virtual.
Keep these pointers in mind, taken from this excellent article by Arctype:
"Think of a generated column as a sort of view but limited to columns."
"Similar to a normal column, but you cannot change its value manually."
"The generation expression can only involve immutable functions."
What is a cron job?
By: Mirza Bahic
I use cron jobs quite a bit for maintenance-type tasks and also to process several CSV files located on the Linux server, with PHP scripts.
Cron might very well be the silent workhorse of your *nix system.
In this article, learn how to set up a cron job with examples for cPanel GUI, Plesk, and WordPress.
I discover many articles I read and share 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.
The Creat[ive][or] In Us
"As a developer, I need to git it figured out."
"The unsung hero in my workflow."
"Consistency is but one part."
"There are more options than just the popular one(s)."
"That's 60 #1's."
Thank you for reading OpenLampTech. This post is public so feel free to share it.
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!
Some inspirational ‘Thank You’ cards are in this Etsy Shop.
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.