OpenLampTech issue #16
Discover more from OpenLampTech
OpenLampTech issue #16
MySQL Workbench snippets; SQL book recommendation; Case for WP.com; mysqld; MySQL shutdown error; CodeIgniter 4 form helper; Learn Symfony 6; PHP tricky true false examples
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:
Recently from the Digital Owl’s Prose Blog and OpenLampTech Publication
Are you using MySQL Workbench? I wrote the post, Quick SQL Snippets in MySQL Workbench, just for you (and me). Check it out!
Looking for an SQL book to integrate with your development practices and learn all about which anti-patterns to avoid? Here you go...
I have curated some fantastic reads for you this week. Let’s get to them!
This Week’s Picks
✔️ A Case for WP.com
By: Justin Ferriman
#wordpress
This post covers a great use case for WP(dot)com, simplicity.
I started with WP(dot)com for my developer blog, Digital Owl's Prose, in late 2016 and am still there today (as of this publishing).
I mainly started there out of ignorance (wasn't really aware of what all existed), but stay there for now because I've wizened up.
I only bring up this point that as the author covers in the article, using WP(dot)com is as painless as possible. Less thinking, and more doing the actual work (blogging in my case).
I built and (briefly) ran a self-hosted WP(dot)org site on a host I won't mention and it was a nightmare. Not so much the WP part, but more so the hosting. And, some fault on me as a junior still trying to learn.
I'll stick with my WP(dot)com Business plan...
✔️ What is mysqld?
By: Arctype
#mysql
The mysqld is responsible for a lot in the MySQL ecosystem. From High Availability to storage and security, mysqld is there behind the scenes making things happen.
There is a lot to learn about the internal functions of the MySQL daemon and this article by Arctype, lays out an easy-to-understand foundation of many of the processes involved.
I'm telling y'all, the folks over at Arctype drop some fantastic blog posts.
Check them out...
✔️ How to Fix the XAMPP Error “MySQL Shutdown Unexpectedly” (3 Methods)
By: Kinsta
#mysql
In my opinion, the Kinsta articles are pure gold and I always learn something from the ones I read.
Get 3 tips on how to solve this specific error message in your local XAMPP (the 2nd one actually surprised me honestly).
As a side note, I use the DevKinsta local development environment for WordPress and enjoy using it when I'm tinkering around with WP development. DevKinsta is also super-easy to set up and run.
Do you need to learn MySQL? Just starting out on your journey and confused about how to query a table and get the data you need? I am creating premium MySQL Beginners content for this specific reason. To help those who want to learn the basics of MySQL but don't know where to start. Learn more about my premium MySQL blog posts and content as I develop and release them, in addition to a weekly email with an actionable MySQL tip.
✔️ How to Write a Good Controller? One of the Most Common Mistakes Using the Example of Laravel
By: Droptica
#php #laravel
This post covers some best practices for better controller structuring with an example using Laravel (although I think this can be applied to other frameworks as well).
Some actionable takeaways for me:
Spread out much of the business logic to other areas of the application.
The less code you have in the controller, the better overall.
Scrutinize the controller code to make sure it is a task for the controller and not some other service or area of the application.
✔️ CodeIgniter Form Helper library — at a glance
By: Joshua Otwell
#php #codeigniter
After my 2nd mini project (which was a similar clone to my first) with CodeIgniter 4, I just had to write about the form helper library.
Using PHP methods and functions to create the HTML form elements is super easy, especially since well, I like PHP.
I cover several of the available methods and what they map to for the HTML form elements.
✔️ Learn Symfony 6 for Beginners
By: Code With Dary
#php #symfony
Although I have not watched this video in its entirety, I did watch the first several individual videos as they were released a few weeks back. The Code With Dary, YouTube channel always produces quality content and the videos are top-notch.
Thanks to the content on this channel (through a different series of videos), I was able to finally solidify the whole MVC design pattern as it relates to core PHP.
If you want to learn Symfony, here you go...
✔️ PHP Tricky True False Examples
By: Waqar Ahmed
#php
Sometimes those truthy and falsy tests are so confusing to me, especially checking the return values of empty() and isset() - which are typically never what you expect.
Thank goodness posts like this one exists for folks like me...
⭐⭐⭐ Many of the posts I curate and share in this newsletter, I read and enjoyed on Medium. If you are not yet and member and wish to join the platform, I would be more than grateful if you would use my sign-up link. At no extra cost to you, I will receive a small portion of your membership fee when you sign up. Thank you! 🙏
Support OpenLampTech, my blog, and my work with a coffee if you would like.☕
Newsletter Shout out 📣
Extra stuff…
Did you enjoy this issue of OpenLampTech? Please share it with others so that they can enjoy the content as well. Thank you!!!
“Reply” or comment and let me know what you think of this issue of OpenLampTech.
What do you want to see more of?!?
What do you want to see less of?!?
I’d love to know!
Also, share with me links to your published blogs and articles so that I can read them and possibly include them here in the newsletter!
Thank you for reading. I hope you have a great rest of your week.
Take care.
Joshua Otwell
Visit my blog Digital Owl’s Prose, where I write regularly on CodeIgniter, PHP, and SQL. I’m also active on Medium, LinkedIn, Twitter, and Instagram.
How can I help you?
Are you thinking of starting up a blog? I use WordPress for my blog, Digital Owl’s Prose. Let’s both save money on the plans offered. 💸
Grab a Gmail HTML Email Signature template from my Etsy shop and make your emails pop and stand out. ✉️
Need hosting for your next web application or WordPress site? I use and highly recommend Hostinger. They have great pricing and service.
I enjoy reading Refind: The essence of the web, every morning in your inbox. Subscribe for free. Help me get a premium subscription by signing up yourself with my referral link.
Grab a free pack of mobile Creator wallpapers with my referral link.
Just getting started or wanting to learn MySQL? Find out about my premium blog posts and MySQL Beginner Series here.
Want to support this newsletter and my work? Drop some spare change in my Tip Jar.💰
Disclosure: Some of the services and products 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.
Cover photo credits: Image by Click on 👍🏼👍🏼, consider ☕ Thank you! 🤗 from Pixabay