OpenLampTech issue #21
OpenLampTech issue #21
Installing wp-cli; MySQL shell for vs code; PHP $this; CSRF protection in WordPress; Import CSV in Laravel; MySQL learning tier; MySQL query order guide; CodeIgniter join method.
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
This week over on the Digital Owl's Prose blog, I wrote an in-depth article on the CodeIgniter 4 Query Builder join() method. I enjoyed writing this post as this type of crossroads of PHP and MySQL is one of my favorites. Check out the post, CodeIgniter 4 Query Builder join() Method Explained.
New Freebie in my Kofi Shop!
I have created a simple PDF to help you remember the query syntax order for a basic MySQL query. Grab yours now!
A Message From This Week's Sponsor
This week's OpenLampTech newsletter sponsor is, me!
Help support this newsletter and my content by visiting the sponsor below. Thank you! 🙏
Join the "MySQL Learning Tier" membership over in my Kofi Shop for exclusive premium content in the form of:
Blog posts unpublished elsewhere
In-depth guides
Deep-dive articles
Instructional and learning video shorts.
I have curated some fantastic reads for you this week. Let’s get to them!
This Week’s Picks
✔️ The Complete Guide to Installing WP-CLI
By: Erik Torsner
#wordpress
The WP-CLI allows you to do many of the same things you can do from the WordPress Admin panel, but from the command line instead.
Adding users, taking backups, and checking for updates - at scale - is where using a tool like WP-CLI makes the most sense.
In a world where I get analysis paralysis just trying to decide which resource to use to learn WordPress development, at least I've found a great one to learn about WP-CLI from.
✔️ GeoSpatial data handling made easy with MySQL 8.0
By: pon suresh pandian
#mysql
There was such a huge feature upgrade in the jump from MySQL version 5.7 to 8 that I feel like v8 really propelled MySQL into stardom.
Among all the features and improvements, one of the most significant was the geospatial development and functionality.
The experts at the Mydbops team cover all the enhancements and upgrades now available for spatial data and querying included in MySQL version 8.
Good stuff here folks.
✔️ "PHP: How to fix the ""Call to undefined function curl_init()"" error"
By: Anto Online
#php
Learn why this error message is displayed and how to fix it by installing the missing extension from the command line in this short, but useful article.
I can't recall using the PHP curl_exec() function (yet) at the time of writing, in my short web development career. But, when I do and if I encounter this particular error, I'll have a good idea of how to fix it.
✔️ Protecting WordPress custom forms from CSRF attack
By: Franky Hung
#wordpress #php
This article covers a great example of a form with no CSRF protection and then implementing CSRF protection in the same form, demonstrating the difference.
WordPress has a wp_create_nonce() function you use in the actual <form> as a hidden <input> field and an accompanying wp_verify_nonce() function you use to verify the nonce when the <form> is submitted and processed.
Foundational web 101 learning here that I enjoy revisiting and brushing up on every chance I get.
🔒 I've published a paywalled article over on my Kofi page. I really appreciate anyone's support for unlocking and reading this article. In this post, I'm sharing my thoughts and experiences I've not written much about before.
Other self-taught developers will surely relate to some of the points I wrote about. Thank you!
5 Truths I've Come To Realize As a Self-taught Developer
✔️ MySQL Shell For VS Code – Your New GUI?
By: David Stokes
#mysql
Honestly, I never could get into VS Code although I tried. I can't get past Sublime Text 3 with its Vim key bindings (which are the best other than the native Vim) so that's what I use for my editor.
But, I have used the MySQL Shell quite a bit and wrote a lot about it a couple of years back over on my developer blog.
Bringing MySQL Shell over to VS Code is way cool and definitely will help with productivity if you are using these 2 environments.
I sure do like seeing cool things like this in the developer space. 👏👍🤘
✔️ Import and export CSV in Laravel 8 and MySql
By: Harendra Verma
#php #laravel #mysql
The CSV file is one of the most common data interchange formats around. Uploading CSVs is nothing new in application development and if you need to do this in Laravel, this article is a solid place to start.
Covering application file structure and scaffolding, I really enjoyed reading and learning about many of the Controller methods used for the actual CSV processing. As an added bonus, this post covers exporting operations as well which doesn't seem to be covered as much as similar type blogs.
✔️ How the Backend of your WordPress site works
By: Reuben Walker
#wordpress
Reuben Walker shares useful resources for each of the components that make up a WordPress site in this roundup style post.
There are link sources for:
HTML
CSS
PHP
Javascript
SQL
Plenty to read, learn, and revisit in this article so keep it handy.
Support OpenLampTech, my blog, and my work with a coffee if you would like.☕
✔️ DYNAMICALLY ACCESS PHP OBJECT PROPERTIES WITH $THIS
By: (discovered via the Symfony Station newsletter)
#php
I absolutely without shame will admit to everyone that I've used $this about a zillion times and not really understood just what in the hell $this is. And, I think that is pretty common for developers with non-traditional backgrounds. We can definitely use something and not understand what it is, nor what it does.
I understand that $this represents the current Class context. But, there is a lot more to $this.
Find out all about $this by reading this article.
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!!!
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.
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.