Find guides, reviews, and articles on the topic you need.
Contents 0. In MySQL, query caching has been completely removed in recent versions, while in MariaDB, on the contrary, it has become enabled by default. 1. How MySQL / MariaDB query caching works 2. When to use MySQL / MariaDB que…
Read article →In the previous article, we learned how to convert JPG and other formats to AVIF (which is supported by modern web browsers). This can reduce the space occupied by images on the hosting by up to 8+ times! See also: How to convert…
Read article →Contents 1. AVIF format for websites 2. Programs for converting images to AVIF on a server 2.1 Converting to AVIF with the magick utility 2.2 avifenc utility for converting to AVIF 3. Why converting to AVIF with PHP is a worthwhil…
Read article →Contents 1. Is it possible to mix HTML and PHP code in one file 2. How to use conditions in PHP to output HTML 3. When to use conditions in PHP to output HTML 4. Outputting HTML fragments outside PHP based on conditions in other c…
Read article →Contents What are $mysqli->close() and $result->free() used for in PHP Is it necessary to close connections to MySQL / MariaDB and clear the result of the SQL query? When using $mysqli->close() and $result->free() will NOT give ta…
Read article →After upgrading to PHP 8.4, you may have encountered the following error: PHP Deprecated: PHP Startup: session.sid_length INI setting is deprecated in Unknown on line 0 Deprecated: PHP Startup: session.sid_length INI setting is de…
Read article →The instructions have been checked and corrected to work with the latest components (Apache 2.4.62, PHP 8.3.11, MySQL 9.0.1, and phpMyAdmin 6.0). Table of contents 1. What is a web server for Windows 2. Download web server (Apache…
Read article →Table of contents 1. Windows web server 2. How to install Apache on Windows 3. How to install PHP on Windows 4. PHP 8 setup 5. How to install MySQL on Windows 6. How to install phpMyAdmin on Windows Conclusion Windows web server A…
Read article →The instructions have been checked and corrected to work with the latest components (Apache 2.4.62, PHP 8.3.11, MySQL 9.0.1, and phpMyAdmin 6.0). 1. Downloading Apache, PHP, MySQL, phpMyAdmin Download Apache for Windows: https://w…
Read article →When executing a SQL query to a database, the rows and columns of a table can be returned as the execution result. An empty value can also be returned if no data matching the query is found in the table. The usual algorithm for pr…
Read article →
