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 −
-
− Learn how to use PHP to open and close a MySQL database connection.
-
− This part explains how to create MySQL database and tables using PHP.
-
− This part explains how to delete MySQL database and tables using PHP.
-
− 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.
-
− Learn how to fetch records from MySQL database using PHP.
-
− This one explains how to show your query result into multiple pages and how to create the navigation link.
-
− This part explains how to update existing records into MySQL database using PHP.
-
− This part explains how to delete or purge existing records from MySQL database using PHP.
-
− Learn different ways to take backup of your MySQL database for safety purpose.