The MySQL database is one of the most popular among PHP developers, and there are numerous well-documented PHP functions you can use in conjunction with your MySQL databases. In this tutorial, you will learn how to make a simple connection to MySQL using just a few of these functions.

Like MySQL, the PostgreSQL database is quite popular among PHP developers. Understandably, there are numerous well-documented PHP functions you can use in conjunction with PostgreSQL. Here you will find how to make a simple connection and select some data using just a few of these functions.

This tutorial explains how to make a simple connection to Sybase using a few PHP functions.

PHP includes functions for Open Database Connectivity (ODBC), which is useful if, for example, you want to connect to a Microsoft Access data source on Windows NT. An increasing number of PHP developers are using the ODBC functions to connect to databases; to that end, the ODBC functions are numerous and well-documented in the PHP Manual. This tutorial presents how to make simple ODBC connections using just a few of these functions.

Learn how to make pagination ([1][2][3]) with some lines of code, very explained.

This DB connectivity class makes it even easier to work with data from MySQL databases. It handles errors, features a better result object, and allows you to iterate through the rows returned by a SELECT query.

In this two-page online tutorial you will learn how to create a database-driven site that can display content on request. It covers topics on a simple SQL query interface and more complex example of parsing and querying.

This tutorial will show you how to display data from a database and allow the user to sort it.

When interacting with a database, functions are called that are common to every transaction; functions to establish a connection, execute the query and then close the connection. This article shows how to create functions that will eliminate this redundancy. The tutorial uses MySQL as the database, but the database layer is irrelevant. These functions can be adapted to use other databases.

This article addresses two SQL-related issues in PHP: 1) Creating complex, powerful, queries to take advantage of your table schemas, and 2) Building those queries on the fly according to user input.