”;
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.
”;