MySQL

Various guides and tutorials about the MySQL database system.

PHP: Export MySQL data to an Excel file.

This is a tutorial on how to export MySQL data to an Excel file using PHP.

PHP: How to close a PDO connection to MySQL.

This is a PHP tutorial on how to close a PDO connection.

Copy a MySQL table using PHP.

This is a short guide on how to copy a MySQL table using PHP.

MySQL: Extract Year and Month from Date column.

This is a short guide on how to get the year and month from a date column in 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.

MyISAM locking explained.

The other day, some of our users reported that saving data had become extremely slow. In some cases, forms were taking up to 15 seconds to submit.

Call to undefined function mysql_connect()

If you are encountering this error, it is probably because you are trying to use the old mysql_* functions in PHP 7.

MySQL: INT(11) vs TINYINT(1) – What do the numbers in brackets mean?

When it comes to columns such as INT (11) and TINYINT (3), the number in brackets isn’t actually that important.

PDO: Get the ID of the last inserted row.

This is a short guide on how to get the ID of the last inserted row using PDO’s lastInsertId method.

WAMP phpMyAdmin username and password.

Having trouble logging into a new install of phpMyAdmin? This article should save you some time and confusion!

PHP Tutorial: Reset Password form.

This is a short tutorial on how to create a simple Reset Password form with PHP and MySQL.

Using wildcards with PHP’s PDO object & prepared statements.

This is a short PHP tutorial on how to use the wildcard character when using prepared statements with the PDO object.

Tutorial: Ajax search with MySQL, PHP and JQuery.

In this tutorial, I will show you how to create an Ajax search form using JQuery, PHP and MySQL.

PHP: Cache SQL results on file system.

This is a simple tutorial on how to use PHP to cache the results of an SQL query to the file system.

MySQL: SELECT all records from today using PHP.

This is a guide on how to select all MySQL records from today (or another specified day).

Adding columns to a MySQL table using PHP.

This is a tutorial on how to add columns to a MySQL table using PHP.