PHP
and MySQL
PHP will work with virtually all database software,
including Oracle and Sybase but most commonly used is freely available MySQL
database.
What you should
already have ?
·
You have gone through MySQL tutorial to
understand MySQL Basics.
·
Downloaded and installed a latest
version of MySQL.
·
Created database user guest with
password guest123.
·
If you have not created a database then
you would need root user and its password to create a database.
We have divided this chapter in the following
sections −
·
Connecting
to MySQL database − Learn how to use PHP to
open and close a MySQL database connection.
·
Create
MySQL Database Using PHP −
This part explains how to create MySQL database and
tables using PHP.
·
Delete
MySQL Database Using PHP −
This part explains how to delete MySQL database and
tables using PHP.
·
Insert
Data To MySQL Database − Once you have created your database
and tables then you would like to insert your data into created tables. This
session will take you through real example on data insert.
·
Retrieve
Data From MySQL Database − Learn how to fetch records from MySQL
database using PHP.
·
Using
Paging through PHP − This
one explains how to show your query result into multiple pages and how to
create the navigation link.
·
Updating
Data Into MySQL Database − This part explains how to update
existing records into MySQL database using PHP.
·
Deleting
Data From MySQL Database − This part explains how to delete or
purge existing records from MySQL database using PHP.
·
Using
PHP To Backup MySQL Database − Learn different ways to take backup
of your MySQL database for safety purpose.