PHP Data Objects - PDO for MySQL layer to access database

PDO will not work for versions older than PHP 5 ( Check your PHP Version )

Download Zip file with all sample scripts at end of this page

MySQL Functions (PDO_MYSQL)

Basics

Functions	Description
Installation	How to enable PDO in PHP 5 and above versions
Connection	Connection to MySQL Database

Collecting records

Functions	Description
Fetch	Collecting single record
Records	Multiple records from table

Inserting , updating and deleting records

Functions	Description
Insert	Adding records to table
Update	Update record
Delete	Delete records
Drop	Drop table

Counting rows and columns

Functions	Description
RowCount	Number of rows affected by delete or update query
ColumnCount	Number of columns present in a query or table

From a list of records to a single record We can display a list of student names by taking data from a table. From this list user can click a single record ( say student name column ) to get full details of the record ( student details )

Basic Php MySQL database script using PDO

You should have PHP installed 

Database MySQL

Check PDO connection from PHP to MySQL



How to Install Script 

Open sql_dump.txt file and use the sql commands to create your tables. 

Open config.php and enter your mysql login details. 



Open index.php file and check for any error messages 

Open any file and use the top menu to navigate different pages

You can delete table or remove all records by using different pages using top menu.

You can reinitiate all tables and records by visiting links at the top menu. 

So feel free to experiment with drop table or deleting records.

For any changes or modifications , use the Forum

download Basic database management script using PHP PDO & MySQL

MySQL admin script using PDO

PHP Data Objects - PDO

MySQL Functions (PDO_MYSQL)

From a list of records to a single record