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 issue occurs because MySQL 8 changed its default charset to utfmb4. As a result, older software might not be able to connect to it.

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 undefined error, then it means that 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.

PHP: Create CSV file from MySQL.

An example of exporting MySQL rows to a CSV file that is downloaded by the user’s browser.

PHP: Populating a drop down list from MySQL.

This is an extremely simply tutorial on how to populate a drop down list using values that you’ve selected from MySQL.

PHP: Save an object to MySQL database.

This is a tutorial on how to save PHP objects to a MySQL database. This method will also work with other DBMS systems such as SQL Server and PostgreSQL.

mysql_fetch_array() expects parameter 1 to be resource, boolean given.

This is probably one of the most common PHP errors.

Empty a MySQL table with PHP (and PDO).

This is a tutorial on how to completely empty a MySQL table using PHP.

PHP: Select list of MySQL tables (PDO).

This is a tutorial on how to retrieve a list of MySQL tables using PHP and the PDO object.

PHP: PDO transaction example.

In this guide, we will show you how to use transactions with PHP’s PDO object.

PHP: Get query execution time.

Measure the execution time of an SQL query in PHP.

Get the structure of a MySQL table in PHP (PDO).

How to get the structure / column names of a MySQL table in PHP.

Expiring MySQL rows the easy way!

An alternative solution to expiring MySQL rows and records.

CakePHP TINYINT(1) – Won’t accept values that are not 0 or 1.

Having problems with the TINYINT(1) column in CakePHP? Check this out.

Connecting to multiple databases with PDO.

This is a short tutorial on how to connect to multiple MySQL databases in the same script using the PDO object.

PHP User Registration & Login Form – PDO.

An introductory tutorial to building user login & registration forms with PHP’s PDO object.

MySQL

PHP: Export MySQL data to an Excel file.

PHP: How to close a PDO connection to MySQL.

Copy a MySQL table using PHP.

MySQL: Extract Year and Month from Date column.

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

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

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

PDO: Count number of rows in a MySQL table.

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

MyISAM locking explained.

Call to undefined function mysql_connect()

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

PDO: Get the ID of the last inserted row.

WAMP phpMyAdmin username and password.

PHP Tutorial: Reset Password form.

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

Tutorial: Ajax search with MySQL, PHP and JQuery.

PHP: Cache SQL results on file system.

MySQL: SELECT all records from today using PHP.

Adding columns to a MySQL table using PHP.

PHP: Create CSV file from MySQL.

PHP: Populating a drop down list from MySQL.

PHP: Save an object to MySQL database.

mysql_fetch_array() expects parameter 1 to be resource, boolean given.

Empty a MySQL table with PHP (and PDO).

PHP: Select list of MySQL tables (PDO).

PHP: PDO transaction example.

PHP: Get query execution time.

Get the structure of a MySQL table in PHP (PDO).

Expiring MySQL rows the easy way!

CakePHP TINYINT(1) – Won’t accept values that are not 0 or 1.

Connecting to multiple databases with PDO.

PHP User Registration & Login Form – PDO.

Deleting rows with the PDO object.

PDO: Updating MySQL using prepared statements.