XAMPP:
XAMPP is an open source cross platform web server,
MySQL database engine, and PHP and Perl package.
It is compiled and maintained by apache. The acronym XAMPP stands for;
- X
– [cross platform operating systems] meaning it can run on any OS
Mac OX , Windows , Linux etc.
- A
– Apache -
this is the web server software.
- M
– MySQL - Database.
Use of XAMPP:
- In
order to use PHP, you will need to install PHP, Apache and may be even
MySQL. It’s not easy to install Apache and configure it. If you install
Apache on its own, you will still have to set it up and integrate it with
PHP and Perl among other things. XAMPP deals with all the complexity in
setting up and integrating with PHP and Perl. Unlike Java that runs with the Java SDK
only, PHP requires a web server to work
- XAMPP
provides an easy to use control panel to manage Apache, MySQL and other
programs such as Tomcat, filezilla etc. You don’t have to memorize
commands for starting apache, MySQL etc.
Step by step installing XAMPP:
Double click on the downloaded software
We will get a warning message as below
As per the warning message disable the UAC or
install the software other than program files
In the welcome screen click on next
Select all the components and click on Next
Provide the installation directory for XAMPP and
click on Next
Click on Next
Click on Next
Wait until the installation got finished
Click on Allow access
Check start control panel option and click on Finish
Select the language and click on save
We will get a XAMPP control panel as below
Here we started Apache server and mysql by
clicking on start button adjacent to them
By clicking on Admin button belong to Apache we can
access the dashboard page as below
In the admin console click on New
Provide name for the database and click on create
We can create tables on the newly created
database by using Create table option
Creating a table “nametable” with two columns
Connecting to sql work bench and checking for the
table created