Learn how to issue basic mySQL queries using PHP and how to properly validate SQL queries before issuing them to the database server to prevent possible attacks or unauthorized access

Learn how to connect to a MySql database in PHP.

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.

The purpose of these examples are to show you various ways to use PHP and MySQL. The examples include displaying all fields in the database, random fields, sorting alphabetically and limiting the results returned.

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 handle MySql databases in PHP

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

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.

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.