How To Set Up Local Server Using XAMPP?

XAMPP stands for Cross-Platform (X), Apache (A), MySQL (M), PHP (P) and Perl (P). It is a simple, light-weighted Apache server that makes it extremely easy for developers to create a local HTTP server with just a few clicks.

Step 1: Download XAMPP

Download  one of the version of XAMPP from the link given below

https://www.apachefriends.org/download.html

Step 2: Install XAMPP

The installation of XAMPP is very straightforward just like any other application.

1. Double-click on the downloaded .exe file.

1. Just follow the instructions that pop up.

1. Once the installation process is finished click on a windows button and search for XAMP control panel from your programs list.

1. Click on start button of Apache and MySQL.

1. To test your XAMPP installation open a web browser and search for http://localhost/dashboard/

Creating Database

To create a new database open a web browser and search for http://localhost/phpmyadmin/, you will find PHPMyAdmin dashboard select databases and create a new database.

Creating Table

Select the database that you created where you will find an option to create table, give the table name and select number of columns that you need for your table and click ok.in the next step give column names with appropriate datatype and size and also you can insert data into a table by selecting the Insert tab.

(or)

You can simply run these queries to create a new table and to insert data.

To Create:

CREATE TABLE Users(    UserID int,    LastName varchar(255),    FirstName varchar(255),    Email varchar(255),    City varchar(255) );

To Insert:

INSERT INTO Users(UserID , LastName , FirstName , Email , City)

VALUES ('1', 'Andrew', 'Flint', 'zzz@zzz.com', 'Norway');