What is WAMPSERVER :
WAMPSERVER IS A LOCAL WEBHOSTING PACKAGE
WAMP stands for Windows Apache MySQL and PHP. WAMPSERVER is a server for executing Hypertext Preprocessor programming language. Normally PHP is used as a server side programming language in building beautiful web applications and websites. In a web development activity WAMPSERVER playing the role of displaying the webpages without the help of a Browser. HTML and CSS is also used on side by side to display the webpages and ultra modern web applications and graphical presentations.
What is PHP?
PHP was initially "Personal Home Page" and now it is known as Hyper-text Pre Processor". PHP is very widely used to build stunning web applications and websites. There are many such websites built with PHP. PHP was initially developed by 'Rasmus Leadoff' which is further developed by PHP Team. The introductory release of PHP was done in the year 1995. With the introduction of PHP Scripting language Web Development has become easy by using PHP's scripts. This scripting language brought a revolution in the we development. More and more developers started using PHP for Web Development.
What is MySQL ?
MySQL is an open-source relational database management system (RDBMS). "SQL", the abbreviation for Structured Query Language. MySQL is structured query language which is normally used in web development as well as to prepare database tables and queries.
What is Apache ?
Apache is a free and open-source cross-platform web server software, helps in web building technology.
What is MariaDB ?
MariaDB is a community-developed, commercially supported Database of the MySQL relational database management system (RDBMS).
How to Install WAMPSERVER in Windows
Download WAMPSERVER latest version from https://sourceforge.net/projects/wampserver/
Download page will go through a series of steps i.e. First of all, right click on the icon of downloaded WAMPSERVER it normally appears in download folder in Explorer.
On the menu item Select and Click "Run as Administrator".
You will be intimated to choose permission then continue to click ‘Yes”.
Then again window appears to Select language option, normal case “English” or any other required language as per list.
Visual Basic Support packages 2009, 2010, 2011, 2012, 2013 etc.as explained in the page displayed is to be downloaded from the given link on the bottom.
Then Click on the button to install WAMPSERVER.
The WAMPSERVER will be installed in your PC.
Then installer will ask for whether to use internet explorer or any other web browser for accessing the web. Ideal to choose internet explorer.
A pop-up window will appear whether to open WampServer, then click Yes/No. Click Yes and proceed further. Choose Language as English or as per your need.
If the installation is successful, then first it will appear in red then “W” then orange “W” and then green color sign of WAMPSERVER i.e. “W” will be displayed on the bottom shortcut bar of Desktop. All the Visual packages are must because without which the WAMPSERVER will not work properly.
Login to PHP My Admin :
Left click on the icon “W” to display a stretched list containing Local Host, PHP My Admin and other menu items. Out of which click on Menu Item “PHP My Admin”, you will be directed to a login page asking to login, no auto default password available, you may set it later on login directly to PHP My Admin. Select MySQL for database choice on the selection pane.
Create your First Database:
See the left pane which will show the option “NEW”. Click on “New” You will have to provide name of database say “empdata” or any other name you want to add.
Creating your First Table in Mysql:
Then you will be directed create table option, then give name of table say “emptable”. After creating the table, you will be redirected to the structure for creating the fields for eg.: id(select Int- 11), when adding id a message box will appear asking the details about id click ‘OK’ and proceed further, below add next column name i.e. nameofemployee(select var char - 70, add 3rd column name i.e. joindate (select var char – 12), below add 4th column name i.e. remarks (select var char – 60). You may preferably chose A/I (auto increment) option for continuous numbering on top of the table, which will be the primary key. Otherwise you will have to write the sr.no.(id here).
Insert Data into the Database(“empdata”) Table:
You may insert the name of employee, join date and remarks but not to fill the id, which is in auto mode and will increase gradually. Saver the data by clicking ‘Go’ button.
You can view the results after clicking browser
Comments
Post a Comment