PHP: Export MySQL data to an Excel file.
This is a tutorial on how to export MySQL data to an Excel file using PHP.
Read More...MySQL
PHP: How to close a PDO connection to MySQL.
This is a PHP tutorial on how to close a PDO connection.
Read More...Copy a MySQL table using PHP.
This is a short guide on how to copy a MySQL table using PHP.
Read More...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.
Read More...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.
Read More...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.
Read More...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.
Read More...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.
Read More...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.
Read More...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.
Read More...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.
Read More...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.
Read More...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.
Read More...WAMP phpMyAdmin username and password.
Having trouble logging into a new install of phpMyAdmin? This article should save you some time and confusion!
Read More...PHP Tutorial: Reset Password form.
This is a short tutorial on how to create a simple Reset Password form with PHP and MySQL.
Read More...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.
Read More...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.
Read More...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.
Read More...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).
Read More...Adding columns to a MySQL table using PHP.
This is a tutorial on how to add columns to a MySQL table using PHP.
Read More...PHP: Create CSV file from MySQL.
An example of exporting MySQL rows to a CSV file that is downloaded by the user’s browser.
Read More...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.
Read More...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.
Read More...mysql_fetch_array() expects parameter 1 to be resource, boolean given.
This is probably one of the most common PHP errors.
Read More...How to truncate a MySQL table with PHP
This PHP tutorial will show you how to empty a MySQL table using the PDO object.
Read More...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.
Read More...PHP: PDO transaction example.
In this guide, we will show you how to use transactions with PHP’s PDO object.
Read More...PHP: Get query execution time.
Measure the execution time of an SQL query in PHP.
Read More...How to get the structure of a MySQL table in PHP.
This tutorial will show you how to get the structure of a MySQL table using PHP’s PDO object.
Read More...Expiring MySQL rows the easy way!
An alternative solution to expiring MySQL rows and records.
Read More...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.
Read More...PHP User Registration & Login Form – PDO.
An introductory tutorial to building user login & registration forms with PHP’s PDO object.
Read More...How to delete rows with the PDO object
This PHP tutorial will show you how to delete database rows using the PDO object and prepared statements.
Read More...PDO: Updating MySQL using prepared statements.
A beginners tutorial on updating MySQL rows with the PDO object.
Read More...PDO: Selecting rows from MySQL.
A beginners tutorial on how to select rows from MySQL using the PDO object.
Read More...