The use of abstraction layers is a controversial topic among PHP users. There are reasons why people use them, and likewise why they don’t. In this article I will be going through the advantages and disadvantages of using the ADODB database abstraction layer.

This is the Full chapter 6 from the recently published book 'Mastering phpMyAdmin for Effective MySQL Management'. The Chapter 'Changing Table Structure' give a great step by step guide with diagrams. Publshed in HTML for your enjoyment.

This example use MySQL functions from PHP to display full MySQL table(every column and every row) as HTML.

A collection of 21 tips on working with MySQL database. Clear explanations and tutorial exercises are provided on connecting and selecting MySQL database, creating and dropping tables, inserting, updating, and deleting rows, selecting and looping through data rows, searching by key words, setting auto-increment IDs.

Learn how to connect to a MySql database in PHP.

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

Learn how to easily create a comment system. Don't know what a comment system is? Well, it's what you see very often in a news system. Basically it allows your users to give feedback on tutorials, news etc. This tutorial is definitley a must-see.

This tutorial will teach you how to deal with special characters like HTML tags, white space etc. from a user submitted form and database output.

After reading this tutorial, you should be able to add previous and next links to your pages that display data from a database.

In PHP every database is accessed slightly differently. To connect to MySQL, you would use mysql_connect(). When you decide to upgrade to Oracle or Microsoft SQL Server, you would use ocilogon() or mssql_connect() respectively. What is worse is that the parameters you use for the different connect functions are different also.. That's why a database wrapper library such as ADODB comes in handy when you need to ensure portability. <p> This tutorial has been translated into multiple languages, including German, Spanish, Polish, Thai and Chinese.