MySQL

PHP: List the indexes on a MySQL table using PDO.

This is a PHP tutorial on how to list all of the indexes that have been assigned to a MySQL table.

MySQL: Server sent charset (255) unknown to the client.

This is an issue that occurs because MySQL 8 changed its default charset to utfmb4.

PHP: Get a list of all MySQL databases using PDO.

This is a short tutorial on how to get a list of all MySQL databases using PHP’s PDO object.

PDO: Count number of rows in a MySQL table.

This is a tutorial on how to count the number of rows in a MySQL table using PHP’s PDO object.

Check if a MySQL row exists using PHP’s PDO object.

In this tutorial, I will be showing you how to check if a row exists in MySQL. To do this, I will be using PHP’s popular PDO object.