PHP Interact with MySQL Database Procedures

When using PHP to interact with MySQL database, the following 5 steps can usually be broken down. Please note that the interaction is actually a continous process. This is only for learning purpose that the whole process is broken down into 5 steps.

Step 1: Connect with MySQL server

Step 2: Select a MySQL database to work with

Step 3: Peform query on MySQL database tables, e.g. read data, update data, insert data or delete data.

Step 4: Display results on the screen, if required.

Step 5: Close the connection with MySQL server