1115. Introduction on How to Use the EverSQL MySQL Query Optimizer Tool for Free - 3 minutes - Lately in PHP Podcast Episode 93 Part 4
Updated on: 2022-11-17
Posted on: 2022-11-08
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.
More ... 
Post a comment 
See comments (0) Trackbacks (0)
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.
More ... Post a comment See comments (0) Trackbacks (0)1. How to Generates a Kubernetes Configuration File to Setup a Container using PHP
Updated on: 2022-11-05
Posted on: 2022-11-05
Blog: Kubernetes Resource generator package blog
Package: Kubernetes Resource generator
Kubernetes is a system to manage containers used in many cloud hosting systems.
Containers are helpful for managing and running applications that can run isolated, including those that implement PHP-based Web applications.
This package provides a simplified way to generate configuration files for Kubernetes containers from given parameters.
More ... Post a comment See comments (0) Trackbacks (0)
Containers are helpful for managing and running applications that can run isolated, including those that implement PHP-based Web applications.
This package provides a simplified way to generate configuration files for Kubernetes containers from given parameters.
More ... Post a comment See comments (0) Trackbacks (0)1. How to Implement a PHP Automatic Form Fill Solution that Pre-Fills Form Inputs with Values Entered Before by the Same User
Updated on: 2022-11-03
Posted on: 2022-11-03
Blog: Yii2 Form PreFiller package blog
Package: Yii2 Form PreFiller
Many Web site users do not have much patience to do repetitive tasks.
If they have to fill out lengthy forms with information, they may avoid it and not fill it, especially if the form asks for values already requested.
This package provides some help to minimize that issue. It provides a solution to "remember" the values that a user filled in a form with the same types of inputs.
So next time a Web site asks the user to fill a form with the same fields, this package can provide the values the user entered last time so that the application can pre-fill the inputs with those values.
More ... Post a comment See comments (0) Trackbacks (0)
If they have to fill out lengthy forms with information, they may avoid it and not fill it, especially if the form asks for values already requested.
This package provides some help to minimize that issue. It provides a solution to "remember" the values that a user filled in a form with the same types of inputs.
So next time a Web site asks the user to fill a form with the same fields, this package can provide the values the user entered last time so that the application can pre-fill the inputs with those values.
More ... Post a comment See comments (0) Trackbacks (0)1. How to Use a PHP Travel Planner Application to Help You to Move to Another Country and Have a Better Life
Updated on: 2022-11-01
Posted on: 2022-11-01
Blog: MyDreamLife.eu package blog
Package: MyDreamLife.eu
Many people who want a better life try to move to another country.
Often that is a non-trivial change of life because it requires a lot of preparation, for instance, planning how to arrive at the destination country, where you will stay, how much it will cost, etc.
This package implements a Web application that allows users to do the necessary planning to move with the least of the problems.
More ... Post a comment See comments (2) Trackbacks (0)
Often that is a non-trivial change of life because it requires a lot of preparation, for instance, planning how to arrive at the destination country, where you will stay, how much it will cost, etc.
This package implements a Web application that allows users to do the necessary planning to move with the least of the problems.
More ... Post a comment See comments (2) Trackbacks (0)4. How to Implement a PHP SMTP Gmail Replacement for the PHP mail Function that Works with the Gmail OAuth Authentication
Updated on: 2022-11-11
Posted on: 2022-10-31
Blog: MIME E-mail message sending package blog
Package: MIME E-mail message sending
Many developers use Google Gmail to send email messages to their users because Gmail is a free service that works well.
In 2022 Google made the use of Gmail as a means to send email messages via Gmail SMTP server more secure by requiring an OAuth access token instead of the traditional password of the Gmail user account.
This requirement made many developers update their PHP applications to use OAuth tokens and continue to use the Gmail SMTP server for free.
Read this article to learn how to use OAuth access tokens to send email messages from PHP applications using the Gmail SMTP server.
More ... Post a comment See comments (2) Trackbacks (0)
In 2022 Google made the use of Gmail as a means to send email messages via Gmail SMTP server more secure by requiring an OAuth access token instead of the traditional password of the Gmail user account.
This requirement made many developers update their PHP applications to use OAuth tokens and continue to use the Gmail SMTP server for free.
Read this article to learn how to use OAuth access tokens to send email messages from PHP applications using the Gmail SMTP server.
More ... Post a comment See comments (2) Trackbacks (0)1. How to Avoid Security Issues using PHP URL Redirect Follow Class to Discover the Final URL of a Short URL
Updated on: 2022-10-28
Posted on: 2022-10-28
Blog: URL Tracker Class package blog
Package: URL Tracker Class
Short URLs help pass URLs of pages to other people in a way that may be easier to remember or type.
One challenge of short URLs is that they hide the actual destination URLs. If the pages of destination URLs have security issues, the users that get short URLs may not be aware of that until they access the short URL destination pages.
This package finds and returns the destination URLs of a given short URL. It may also return any intermediary URLs that browsers may need to access until they reach the final destination URL.
This way, developers may use security tools for auditing the safety of the final destination of the short URL, as well as all intermediary URLs.
More ... Post a comment See comments (0) Trackbacks (0)
One challenge of short URLs is that they hide the actual destination URLs. If the pages of destination URLs have security issues, the users that get short URLs may not be aware of that until they access the short URL destination pages.
This package finds and returns the destination URLs of a given short URL. It may also return any intermediary URLs that browsers may need to access until they reach the final destination URL.
This way, developers may use security tools for auditing the safety of the final destination of the short URL, as well as all intermediary URLs.
More ... Post a comment See comments (0) Trackbacks (0)1. How to Use a WordPress Events Plugin Manage and Publish Organized Events
Updated on: 2022-10-28
Posted on: 2022-10-27
Blog: Event Story Manager Plugin package blog
Package: Event Story Manager Plugin
WordPress is a well-known publishing platform that can work for other purposes besides publishing blog posts using plugins that extend the possibilities of the original WordPress software.
This package implements a plugin that can transform a WordPress site into a regional event publication site.
More ... Post a comment See comments (1) Trackbacks (0)
This package implements a plugin that can transform a WordPress site into a regional event publication site.
More ... Post a comment See comments (1) Trackbacks (0)1. How to Quickly Add a Laravel Shopping Cart to a PHP Web Site to Sell Your Own Products
Updated on: 2022-10-26
Posted on: 2022-10-26
Blog: Laravel Shopping Basket package blog
Package: Laravel Shopping Basket
Many Web sites have a shopping section on which they can sell products to their users.
The developers of those some of those sites use the Laravel framework to implement the area with less effort than if they develop the sites using PHP without any framework, content management system, or library dedicated to creating shopping sites.
This package can help quickly add a shopping section to a site that already uses the Laravel framework, thus reducing the effort to add this feature.
More ... Post a comment See comments (0) Trackbacks (0)
The developers of those some of those sites use the Laravel framework to implement the area with less effort than if they develop the sites using PHP without any framework, content management system, or library dedicated to creating shopping sites.
This package can help quickly add a shopping section to a site that already uses the Laravel framework, thus reducing the effort to add this feature.
More ... Post a comment See comments (0) Trackbacks (0)1114. How to Use Simple MySQL Monitoring Tools for Free to Find the Slowest Queries that You Should Optimize First - 2 minutes - Lately in PHP Podcast Episode 93 Part 3
Updated on: 2022-10-25
Posted on: 2022-10-25
When you want to optimize the performance of a MySQL-based application, you should try to optimize first the slowest queries that affect the application's performance.
The MySQL slow query log file provides a list of slow queries as they happen. So you need to monitor that file to determine the most critical slow SQL queries you need to optimize first.
Read this article, watch a 2-minute video, or listen to part 3 of episode 93 of the Lately in PHP podcast to learn how to use a free tool to monitor the MySQL slow query log and find the slowest SQL queries.
More ... Post a comment See comments (0) Trackbacks (0)
The MySQL slow query log file provides a list of slow queries as they happen. So you need to monitor that file to determine the most critical slow SQL queries you need to optimize first.
Read this article, watch a 2-minute video, or listen to part 3 of episode 93 of the Lately in PHP podcast to learn how to use a free tool to monitor the MySQL slow query log and find the slowest SQL queries.
More ... Post a comment See comments (0) Trackbacks (0)1113. How to Buy a PHP Elephant Personalized with Your Logo
Updated on: 2022-10-24
Posted on: 2022-10-24
The PHP elePHPants are lovely mascots that many PHP developers love for being a symbol of their favorite language. The PHP Classes site sells plush toy versions of the PHP elePHPant.
Today we are announcing a significant improvement to the PHP ElePHPant mascot toys we are making available to make these plush toys even nicer.
From now on, you can purchase a personalized version of the PHP ElePHPant. This fact means that the plush toy may show a logo of your choice on the opposite side of the belly where it shows the PHP logo. Your logo can be an image with your name, your company name, or some other type of image that you can share with us.
Read this article to learn more about these new personalized elePHPants and how you can buy them so you can get them for yourself or for the people that you love the most in your life, hopefully in time for Christmas.
More ... Post a comment See comments (0) Trackbacks (0)
Today we are announcing a significant improvement to the PHP ElePHPant mascot toys we are making available to make these plush toys even nicer.
From now on, you can purchase a personalized version of the PHP ElePHPant. This fact means that the plush toy may show a logo of your choice on the opposite side of the belly where it shows the PHP logo. Your logo can be an image with your name, your company name, or some other type of image that you can share with us.
Read this article to learn more about these new personalized elePHPants and how you can buy them so you can get them for yourself or for the people that you love the most in your life, hopefully in time for Christmas.
More ... Post a comment See comments (0) Trackbacks (0)
