PHP is a widely-used open source general-purpose scripting language that is
especially suited for web development and can be embedded into HTML.
In this section we are going to know that how to work with a database with the XAMPP
server where MySQL is in the back-end. Here are the following steps :
Step 1 : Open your XAMPP server and do start the Apache & MySQL and click
as shown in the given figure:
Step 2 : After clicking on Admin button
you will find the below figure on your browser.
Step 3 : From the above page select
phpMyAdmin from tools
You will the phpMyAdmin page on your browser as shown below:
Step 4 : Open the SQL query window by clicking SQL from the page and
create the database.
After writing the query press the GO button.
Step 5 : For creating a table name emp, write the below query
Then press GO button to show the result.
To show the table structure, click on the structure.
Step 6 : Inserting out the data in the table named emp follow:
By phpMyAdmin user interface.
Then press GO button, Result.
Step 7 : To show the table data of emp table , click on the emp as
shown on the top of the page.
Conclusion : You can work by phpMyAdmin
as per requirement.