Working with database in PHP


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:

h1.gif

Step 2 : After clicking on Admin button you will find the below figure on your browser.

h2.gif

Step 3 : From the above page select phpMyAdmin from tools

h3.gif

You will the phpMyAdmin page on your browser as shown below:

H.gif


Step 4 : Open the SQL query window by clicking SQL from the page and create the database.

h4.gif

After writing the query press the GO button.

Step 5 : For creating a table name emp, write the below query

h5.gif

Then press GO button to show the result.

h6.gif

To show the table structure, click on the structure. 

h8.gif

Step 6 : Inserting out the data in the table named emp follow:

By phpMyAdmin user interface. 

Hp1.gif

By query.

h9.gif

Then press GO button, Result. 

h10.gif

Step 7 :
To show the table data  of emp table , click on the emp as shown on the top of the page.

h11.gif

Conclusion : You can work by phpMyAdmin as per requirement.

Up Next
    Ebook Download
    View all
    Learn
    View all