OpenLampTech issue #114
MySQL secure_file_priv | WooCommerce checkout - Hear About Us? | NativePHP | Drupal Commerce Core | WooCommerce shop data insights curated resource.
Thank you for reading the OpenLampTech newsletter!
If someone awesome shared this newsletter with you and you are not yet subscribed, please use the Subscribe button below and join:
And now, a message from this week’s sponsor. Thank you, Backpack for sponsoring the OpenLampTech newsletter!
Backpack is one of the most popular admin panels for Laravel. Their simple stack and many many features make it a good choice for both devs who are now getting started and devs who plan to maintain a project for years to come - they've been doing this since 2016 and their track record speaks for itself.
If you're building a Laravel app, try Backpack, their free version is enough for most projects. Even better - if your project becomes complex, they have paid 1st party add-ons for the most common needs. Same vendor, all features you need.
OpenLampTech has sponsorship opportunities for your brand, product, or service in the weekly newsletter. As an independent publication, collaboration is very affordable.
Display Product Category Description In WooCommerce
While reading some WooCommerce-related posts in Reddit recently, I saw one such ask where a user wanted to display a Product’s category description on the Single Product page.
NativePHP: Build Desktop Applications with PHP
I'm foaming at the mouth over this. Something I've always wanted to try and do on my work laptop for a lot of the small data processing and services I use daily. Now, I can. Perhaps, even combine them into a suite of tools to sell to my co-workers (lol jk).
In this article, see an example of converting a Laravel application to a desktop app with NativePHP. SQLite is used for data storage. As of the time of publication, NativePHP is still in alpha but looks promising as its development progresses.
[Medium]
Commerce Core 2.37 release adds a new store dashboard
Ryan Szrama, who has a fantastic OpenLampTech developer interview you should read, highlights Drupal Commerce Core 2.37 features. This release includes a store dashboard and some bug fixes, among other improvements. The store dashboard provides store owners with insights into their store's performance including KPIs such as sales metrics, summary reports, and a project updates feed. Additional changes include the ability to filter and export product lists, improved product variations handling, and a new shipping origin concept.
Building Maintainable PHP Applications: Framework Decoupling vs Framework Coupling
One of the concepts I've not considered when using frameworks (my framework experience is limited to CodeIgniter 4) is the,
“folder by type” structure instead of “folder by feature”
as is put by the author. The article argues that loosely coupling your PHP app with frameworks offers several benefits for maintainability.
Learn more about Davor Minchorov in this OpenLampTech developer interview.
[Davor Minchorov]
WooCommerce Checkout How Did You Hear About Us?
I'm not sure if a feature like this is worth it or not. I suppose someone wants to know where the hard-earned marketing dollars had the biggest impact and return.
Nevertheless, if you want to collect this type of data on a WooCommerce Checkout page, here is how to do it.
This solution provides PHP code you can either drop in your child theme's functions.php
file or use a code snippets plugin. I'm all for small and impactful code snippets such as those found in this piece versus a bloated plugin.
[Unlimited WP]
What is the secure_file_priv Variable in MySQL?
In MySQL, if you need to bulk upload data, you can use many INSERT
statements (perhaps in a loop using PHP or Python) or the more performant LOAD DATA INFILE
. MySQL comes with many settings enabled by default. Some of them you may be familiar with and others you may have never heard of before. The secure_file_priv
variable determines from where data can be loaded into your MySQL database.
[Medium]
WordPress and WooCommerce-Specific Functions for Shop Data Insights
WooCommerce developers and tech-savvy shop owners will enjoy this curated list of WordPress and WooCommerce-specific PHP functions to garner insights from shop data.
Here recently, I have been querying AI (Google Bard and ChatGPT) for content source ideas.
We know - or should - that these AIs can spit out pure garbage.
Therefore, anytime I do receive any information from them (the AIs) I do my darn best to fact-check and provide relevant links to something solid I can find on the internet.
[OpenLampTech]
SQL Table Creation: The Missing Manual
It never hurts to revisit the basics. While CREATE TABLE
may be basic SQL command, it is far from trivial. This content piece has several examples of CREATE TABLE
statements with supporting context for the various parts. I like the layout and flow of this piece as there are numerous tables within the article with information about a particular aspect of the command (E.g., column definition, constraints, etc…).
[TechBeamers]
WooCommerce
WooCommerce 8.5.1 Released (January 15th, 2024)
WooCommerce 8.5.1 issues with Web Application Firewall (ModSecurity) January 16th, 2024
The WooCommerce Legacy REST API extension is now available in WordPress.org (January 17th, 2024)
Getting to Know Woo: Extending the New Product Editor with React (January 17th, 2024)
Fix for the fatal error when editing customer profile in WooCommerce 8.5 (January 17th, 2024)
Thank you for reading. I hope you have a great rest of your week.
Take care.
Josh Otwell
When you are ready, here are more ways I can help...
Content, E-commerce Development, and Email/Newsletter Services - Photography services; Shopify and WooCommerce customizations, development, and setup; Email and Newsletter setup and management.
Interested? Great!
Just hit Reply and ask for more information about any of these services.
OpenLampTech is a reader-supported publication. You can support the publication with a virtual coffee for as little as $3 (USD).
[#Classifieds, #Affiliates, #Click Ads, #Shoutouts]
🤝 OpenLampTech earns a small commission (or payment/gain in some form) from many of these links. Your support helps keep the weekly OpenLampTech newsletter free for readers.
Take your Laravel applications to the next level with Battle Ready Laravel by Ash Allen. Learn how to improve the performance, maintainability, and security of your Laravel projects in this e-book.
The online DNS course for developers. Learn more at Nslookup.
AI-powered SQL generator and data analytics tool. Learn more at SQLAI.ai - AI, SQL & DATA.