MySQL

Various guides and tutorials about the MySQL database system.

PDO: Insert example.

A simple tutorial on how to insert rows into MySQL with the PDO object.

PHP: Insert multiple rows with PDO.

This PHP tutorial will show you how to insert multiple rows from a PHP array using the PDO object.

PHP: Connecting to a MySQL database.

A simple tutorial on how to connect to a MySQL database with PHP.

Saving a PHP array to a database.

A short tutorial on how to save a PHP array to a database.

Error Handling: Throwing PHP exceptions with the mysql_* extension.

A guide on error handling with PHP’s outdated mysql_* extension.

PHP: Verifying a user via email.

How to verify a user’s email address with PHP.

How to search between dates in MySQL

How to search between dates in MySQL.

PHP: Checking to see if a MySQL connection exists.

How to check to see if a valid MySQL connection is open or not.

Creating a “Hot” algorithm with PHP and MySQL

A simple guide to creating a Reddit-style “What’s Hot” page with PHP and MySQL.

MySQL: A guide on which columns to use.

In this guide, we tell you what MySQL columns to use when storing different types of information.

PHP – Best Practises

A comprehensive list of the best PHP / web development practises that every developer should know about.

Slow MySQLi connection on Windows 7.

Not so long ago, I came across a peculiar issue with PHP’s MySQLi extension. For some strange reason, using the string “localhost” in the constructor will sometimes result in an unexpected delay in connectivity. For example, connecting to MySQL will take 1-2 seconds. This is despite the fact that the DBMS is on a local […]