OpenLampTech issue #31
WordPress block-based ecosystem; Drupal PWAs; What is a WordPress Developer; MySQL multiple columns. Thank you for being here and reading the OpenLampTech publication!
Hey 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 published another short tip for learning MySQL. In the
WHERE clause, we use the equality comparison operator - the equals sign (=) - as a means to filter rows based on some equality condition(s).
Read, MySQL WHERE Clause Equality Comparison Operator, to learn more.
Check out this Substack thread I shared.
Share your favorite programming books with me too!
Do you have any of these books already?
Save the Date - Coming Soon 🔜
Check back into the publication on Tuesday, June 21st, 2022 to read this OpenLampTech report.
Linux | Apache | MySQL/MariaDB | PHP
I have curated some fantastic reads for you this week. Let’s get to them!
The WordPress Block-Based Ecosystem Reaches Fruition
By: Reuben Walker
Reuben Walker shares great coverage on WordPress as it moves forward in block-based design and building.
We learn about:
Full Site Editing (FSE)
And much, much more.
Content like this is quite useful for someone like me that is more and more interested in learning WordPress and I know you will appreciate it too.
Best Practices for CodeIgniter Web Development
By: Jane Brewer
I'm okay admitting I am a bit biased towards CodeIgniter.
All that said, there are good pointers in this article.
Those that stood out to me:
Keep the code modular - The only thing I can add here is I need to work on better implementing this myself.
Use the standard libraries - Don't reinvent the wheel. Use the built-in libraries.
Design lightweight models - Use multiple models to manage complex data relationships.
7 pieces of Linux advice for beginners
By: Opensource.com (Red Hat)
Once you jump into the Linux ecosystem, you realize that the sky's the limit.
To this day I would do well to use these pieces of advice.
Enjoy the process
Share the Linux you know and use
Linux is pretty awesome don't you agree?
What’s a WordPress “Developer?”
By: Dan Knauss
Oh boy. Wanna open up a can of worms?
Here ya go…
I don't necessarily have an opinion on this one way or the other. I am a backend PHP and MySQL developer and figuring out WordPress (or where it's going) is challenging for me.
Page builders, code, and low code/no-code all take some form of time commitment and learning.
I respect them all.
Use what works and get the job done is what I say.
Class, Instance, Object, Interface, Trait
By: Tony Reijm
There are many terms, definitions, and keywords for programming languages. I'm sure there are even some slang words out there.
This article covers important terms and concepts related to Object-Oriented Programming (OOP) in PHP.
There are fantastic, 'plain speak' explanations on each of these staple OOP concepts.
I sure enjoyed reading this post.
WordPress WooCommerce Contact Form Plugin with Widget
This post covers a deep dive into a WordPress contact form plugin that registers a WordPress widget.
There is plenty of plugin code in this article for anyone (like me - raises hand) to study and learn more about creating WordPress plugins.
I have a lot to learn about WordPress development. This is a fantastic article to delve into as I become more familiar with it.
Your first database wrapper's childhood diseases
After reading this, I get the sense I should get out of PDO's way and let PDO do its thing.
This article is full of so much good information, it should be illegal for it to be that good and free at the same time.
I'm going to say that a large portion of the PHP code I write to work with PDO is unnecessary.
Do visit the 'General purpose query function' section within the post as you bookmark it.🔖
A Drupal developer's guide to Progressive Web Apps
By: Alex Borsody
Honestly, I've not looked into Progressive Web Apps (PWAs) that much. I am aware of them but never really studied their implementation.
This post is a high-level overview of the steps and practices of how you can create a PWA using Drupal. As the article covers, you could easily follow this same workflow for other solutions as well.
Cool PHP tip from Twitter
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.
The Creat[ive][or] In Us
"This looks worth doing."
"Read and implement."
"Email is here to stay."
"Information and data capture is crucial."
"Everyone wants to be read."
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!
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.