phpMyAdmin is a free software tool for handling the administration of MySQL over the web. This gives a user friendly environment to Create and manage database and data. The Xampp which we discussed earlier also includes phpMyAdmin. So if you have installed xampp phpMyAdmin is already installed.
Creating a Database:
To insert data:
Not installed Xampp??? Click here. or you can also install it seperately but you will need to install Apache server for running the PHP files. So best way is Xampp.
Creating a Database:
- Start Xampp server.
- Type http://localhost/phpmyadmin in the browser and press Enter.
- Click on `Databases` tab.
- Type any name for the database and click Create button.
That's it your database is created.
Creating a table:
- All the databases will be listed on the left side pane. Click on the database you created.
- Give the table name in the text box and enter number of columns(This can be modified later).
- Click Go.
- Now Enter the Column Name and other attributes that are required like length and Type. (there will be option to add more columns here at the top)
- Click Go, your table is created.
Below screen image shows you the phpMyAdmin after creating table. Here daily_statistics is the table name and database name is test.
 |
| Marked database and table names |
To insert data:
- Click on the table name.
- Click the `Insert` tab.
- Enter values in the respective columns and click Go.
- By clicking on the `Browse` tab you can view the inserted values.
