Working with database in PHP

In this section we are going to know that how to work with a database with the XAMPP server of PHP where MySQL is in the back-end.

Introduction

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. 



By query.



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.