OpenLampTech issue #39
PHP traits; Local PHP dev tools; MySQL aggregate functions; Laravel AJAX with jQuery; Thank you for making OpenLampTech a success!
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 📣
Get Scott's free, 5 minute daily newsletter. Used by 50,000+ people to stay up to date on business, tech finance and cryptocurrency.
Recently Published on the Digital Owl’s Prose Blog
We have a great guest article this week on the Digital Owl's Prose developer blog by Korra Shailaja.
"There have arrived a number of frameworks in the market to organize web databases like PostgreSQL, MongoDB, Oracle, etc. But the most popular one among these is MySQL."
Read the entire article, The Best 7 Reasons To Choose Mysql For Organizing Your Web Database.
Recently Published in the OpenLampTech Publication
I published the OpenLampTech WordPress Wednesday #7 for August 10th, 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 do database indexes work?
By: Justin Gage
#mysql
As this article covers, you've likely used MySQL indexes in queries and didn't even realize it. Indexes help with faster read type (SELECT
- particularly in WHERE
clauses) queries but can slow down write-type operations (INSERT
, UPDATE
).
Related: One of the best SQL books I’ve read and studied on Indexing.
PHP Traits Explained
By: Alex Web Develop
#php
As of this writing, I've not used Traits in any of the projects I am working on. I honestly like - and understand - this definition of a Trait provided by the author.
"In a nutshell, a trait is a structure that prevents code duplication in classes."
Definitely, something on my radar to learn more about as I progress with PHP development.
Output Buffering in PHP
By: Yahaya Oyinkansola
#php
I first learned of PHP output buffering in the phenomenal book, PHP & MySQL: Novice to Ninja. In this beginner book, output buffering is more so demonstrated with effective use patterns. Which is fine.
However, this blog post goes way more in-depth into output buffering concepts and functionality.
PHP has many available output buffering functions available and several prominent ones are covered.
Give this one a good read, folks.
In-Depth HTTP to HTTPS Migration Guide for WordPress in 2022
By: Kinsta blog
#wordpress
Here is another jewel of a blog post from the Kinsta blog.
HTTPS
is a big deal nowadays. It's obvious in the browser search bar whether a site has HTTPS
by showing either a padlock icon or the caution warning triangle.
This post is for you if you have a WordPress site that needs to migrate over to HTTPS
.
How to Fetch records from MySQL with jQuery AJAX – Laravel 9
By: Yogesh Singh
#php #mysql #laravel
AJAX makes it possible to take some action without having to reload the web page. Oftentimes, this is convenient for the users. We can even grab data from the database during AJAX calls.
However, as shown in this article, it is important to protect against CSRF attacks.
Good post with code samples for each process step with Artisan commands included.
PHP Web Development: Is it Time to Retire the Old Workhorse?
By: Dipti Parmar
#php
This is a good piece written on this age-old topic. Since the "insert whatever stat here" portion of websites on the internet are built with WordPress, we know PHP isn't going anywhere.
Honestly, PHP just clicks for me. For whatever reason (I'm probably just that oddball).
I tried Python, and do like it. However, I just prefer and can work better with PHP for websites/applications.
Top 7 MySQL Aggregate Functions
By: Aparna Gurav
#mysql
MySQL aggregate functions allow you to apply certain operations to groups of data. Providing more granular data is often used in reporting or otherwise shaping the data.
The major aggregate functions are covered with examples of each:
COUNT()
MIN()
/MAX()
SUM()
AVG()
Related: Create a comma-separated list with MySQL GROUP_CONCAT()
Dream Universal, Develop Local: A look at PHP Local Development Tools.
By: Reuben Walker
#php #wordpress #laravel #drupal #symfony
If you’ve ever been curious about what’s out there in PHP land for local development, your curiosity ends here. Like always, the author over at Symfony Station publishes some fantastic content and this article is no different.
There is plenty to explore here with succinct summaries and linking resources for each local software piece.
I myself am partial - and have been exploring - Dev Kinsta for local WordPress development and it seems quite solid for that specific ecosystem.
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
5 scary Git commands you'll eventually have use for
"I'm afraid of all the git commands."🤣
Default WordPress Generated CSS Cheat Sheet for Beginners
"I need all the CSS cheat sheets I can get."
Pieter Levels Makes $2.9m A Year From Nomad List And Remote OK
“We all have the opportunity and potential to build what we want.”
How to Be Consistent with Content Creation for Developers
"It takes effort and skill for both."
"Using the best tools for the job at hand is what's important."
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.