PHP Current Version Adoption in 2023, AJAX Character Counter, PHP Conferences of November - 8 minutes - Lately in PHP 99 By Manuel Lemos On the Lately in PHP 99 podcast, you will learn in 8 minutes about the percentages of adoption of PHP versions by members of the Laravel community, a package that can show a character counter using AJAX to measure the length of text entered by a user in text form input, the PHP conferences and user group meetings around the world in November 2023.

Read this article, watch an 11-minute video, or listen to episode 99 audio of the Lately in PHP podcast to learn about the best articles published on the PHP Classes site in the week of October 1 through October 7.

PHP 8 Enums to CSS Colors, WordPress Editor, Bot Protection, SVG to PNG Conversion - 6 minutes - Lately in PHP 98 By Manuel Lemos On the Lately in PHP 98 podcast, you will learn in 6 minutes about a WordPress plugin that implements a visual editor for posts with blocks, a package to convert SVG graphics into PNG images and remove the image transparency using the ImageMagick extension, a WordPress plugin to blocks abusive bots, using PHP 8 enum types to assign names to colors defined by CSS frameworks like Bootstrap and Tailwind.

Read this article, watch a 6-minute video, or listen to episode 98 audio of the Lately in PHP podcast to learn about the best articles published on the PHP Classes site in the week of September 23 through September 30

Fast PHP Menu Builder, Pure PHP Automatic Backup, 8 Artificial Intelligence Facts - 3 minutes - Lately in PHP 97 By Manuel Lemos On the Lately in PHP 97 podcast you will learn in 6 minutes about a fast PHP menu builder package that loads configuration from files, a pure PHP automatic database backup package, 8 artificial intelligence facts that all developers need to know.

Read this article, watch a 6-minute video, or listen to episode 97 audio of the Lately in PHP podcast to learn about the best articles published on the PHP Classes site in the week of September 17 through September 22.

October PHP Events, Customize PHP Composer Hooks, Make WordPress Host a Podcast - 6 minutes - Lately in PHP 96 By Manuel Lemos On the Lately in PHP 96 podcast you will learn in 3 minutes about October PHP Events, Customize PHP Composer Hooks, Make WordPress Host a Podcast.

Read this article, watch a 3-minute video, or listen to episode 96 audio of the Lately in PHP podcast to learn about the best articles published on the PHP Classes site in the week of September 10 through September 16.

Future of PDO, PHP Classes Ideas, Scan Documents into PDF, Tools for Code Quality - 3 minutes - Lately in PHP 95 By Manuel Lemos The Lately in PHP podcast is back with a new format that is more direct to the point, thanks to the feedback from our audience.

Read this article, watch a 3-minute video, or listen to episode 95 of the Lately in PHP podcast to learn about the best articles published on the PHP Classes site in the week of September 3 through September 9.

How to Verify If the EverSQL MySQL Tool Provides Good Optimization Suggestions - 8 minutes - Lately in PHP Podcast Episode 93 Part 7 By Manuel Lemos The EverSQL MySQL optimization tool is excellent for suggesting alterations to MySQL tables and indexes to make SQL queries run faster.

The actual gains in performance may vary depending on the type of query. Significant SQL query optimizations reduce the number of table rows scanned when the MySQL server executes a query.

Read this article, watch an 8-minute video, or listen to part 7 of episode 93 of the Lately in PHP podcast to learn how to verify the efficiency of the MySQL query optimizations suggested by the EverSQL tool.

How to Implement PHP Asyncronous programming using PHP 8.1 Fibers - 6 minutes - Lately in PHP podcast episode 94 By Manuel Lemos PHP 8.1 introduced a new feature called fibers, allowing developers to implement PHP asynchronous programming.

If you implement asynchronous programming, it is possible to make your PHP scripts execute multiple tasks in parallel, thus making those scripts faster.

Read this article, watch a 6-minute video, or listen to episode 94 of the Lately in PHP podcast to learn how to use PHP fibers, PHP Swoole, or ReactPHP to make your PHP scripts finish faster.

Make SQL Queries Run Faster Using the EverSQL MySQL Query Optimization Tool - 4 minutes - Lately in PHP Podcast Episode 93 Part 6 By Manuel Lemos Slow SQL queries are one of the factors that can make sites slower and cause harm to the user experience.

Fortunately, optimization tools can suggest small changes in your database schema that can make your SQL queries run much, so your Web sites can provide a much better user experience.

EverSQL is one of those optimization tools that can suggest effective changes for databases stored in MySQL servers or some other server compatible with MySQL, such as MariaDB.

Read this article, watch a 4-minute video, or listen to part 6 of episode 93 of the Lately in PHP podcast to learn how to optimize your MySQL database using the EverSQL tool for free.

How to Help the EverSQL Tool Optimizing MySQL SQL Queries More Efficiently by Passing It Your MySQL Database Metadata - 4 minutes - Lately in PHP Podcast Episode 93 Part 5 By Manuel Lemos The EverSQL tool is excellent for suggesting optimizations for SQL queries for your applications that use MySQL.

That tool must first obtain the structure of your database tables to suggest good optimizations. You can get that structure by executing a SQL query that extracts the database metadata.

Read this article, watch a 4-minute video, or listen to part 4 of episode 93 of the Lately in PHP podcast to learn how to extract your MySQL database metadata to help the EverSQL tool to optimize your application SQL queries for free.

Introduction on How to Use the EverSQL MySQL Query Optimizer Tool for Free - 3 minutes - Lately in PHP Podcast Episode 93 Part 4 By Manuel Lemos When you want to optimize SQL queries to optimize an application that uses MySQL, you can use "manual" methods. These methods require good SQL query optimization knowledge. If you need to optimize many SQL queries, doing it "manually" may also take time.

One way to optimize SQL queries without requiring you to learn so much about optimization is to use a SQL query optimization tool. Optimization tools also take you much less time to optimize many queries than if you try manually.

Read this article, watch a 3-minute video, or listen to part 4 of episode 93 of the Lately in PHP podcast to learn how to use a free tool to optimize MySQL SQL queries without much knowledge and faster than if you try to do it manually.