PHP for Absolute Beginners

4.2. Manipulating Data in MySQL Tables

You can manipulate the data in a MySQL table via several types of MySQL statements. In this section, you will learn the MySQL statements that perform the following actions:

• Create a database

• Create a table in the database

• Insert data into the table

• Retrieve the data from the table

• Modify the data in the table

• Delete the data from the table

You'll test these commands using the phpMyAdmin control panel provided by XAMPP. Open a browser and navigate to http://localhost/phpmyadmin to access the control panel (see Figure 4-1).

Figure 4.1. The home page of phpMyAdmin on XAMPP

4.2.1. Creating and Deleting Databases ...