OpenLampTech No. 142
Improve DB skills | MySQL commands in Linux | Drupal data management with JSON | PHP 8.4 - what's coming | PHP knowledge you need.
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:
OpenLampTech has sponsorship opportunities for your brand, product, or service in the weekly newsletter. As an independent publication, collaboration is very affordable.
All commentary is mine unless otherwise quoted.
Improve Your DB Skills: 10 MysqliDB Functions in PHP Development
I have more experience with PDO in most of the PHP projects I have worked on.
MySQLi is also a great option but it is database-agnostic so you can only use it with MySQL (nothing wrong with that!).
According to its Github page, MysqliDB is a wrapper for MySQLi.
This article shares some of the dedicated methods and functions for common sets of operations such as SELECT
, UPDATE
, DELETE
, and pagination to name a few.
[Medium]
6 PHP Knowledge You Didn’t Know You Needed
For me, the array_reduce()
function is one of the most interesting out of the 6 “features” listed in this article.
Anonymous functions have their use and I've used them some in WooCommerce when hooking into action and filter hooks. However, I'll need to learn more about closures as I've not used them (yet).
[Medium]
Command to Show Users in MySQL Database on Linux
Despite the usefulness and convenience of ORMs and other database abstraction layers, I think there is great value in knowing (and using) commands on the command line. At the very least, for database administration-type tasks.
This article has several example queries showing how to retrieve MySQL user information from the command line.
[Linux Shout]
PHP 8.4: What’s New For Developers
While still a little ways off from release (slated for November 21st, 2024), PHP 8.4 has interesting new functionality coming.
To name a few are the array find functions, additional/extended mb functions, a createFromTimestamp()
method, and full HTML5 support.
[Medium]
[Affiliate]
Consuming APIs in Laravel - Learn how to confidently integrate third-party APIs in your Laravel projects using maintainable, testable, and extensible code.
Brad Jones on Modernizing Drupal's Data Management with JSON Integration
There is no doubt that JSON is everywhere and somewhat of a structured data format standard. It's also a given that most databases support JSON and/or a form of document store (SODA - Oracle, Document Store - MySQL).
I get the feeling that this is more of an integrate-JSON as opposed to a make-it-all-JSON type of thing.
[The Drop Times]
WooCommerce 9.2: Pre-release updates (July 26th, 2024)
Quick insights:
A new global unique ID has been added to the non-block product editor. I'm not sure if it is/was already a part of the block-based product editor at this time.
New database option,
woocommerce_hooked_blocks_version
. This seems to be a sort of versioning (probably a bad word choice) for (I'm guessing) default block placement in existing stores.Additional database change:
“Update db_version variable and use it to prevent adding global_unique_id when the lookup table was not yet updated”
[#Affiliates and Classifieds] - Your support keeps the OpenLampTech newsletter free for readers
Ultimate Laravel Boilerplate to help other indie hackers deliver their SaaS in hours. Get started with LaraFast today! (affiliate)
Popups, newsletters, and abandoned carts. Use Omnisend with integrated email and SMS campaigns. (affiliate)
Check out the Ecommerce Coffee Break newsletter (and podcast) for the latest in Shopify news. (subscriber incentive)
Thank you for reading. I hope you have a great rest of your week.
Take care.
Josh Otwell
Some links may be affiliate links from which I earn a small commission at no additional cost to you.