LAMP – Linux Apache Mysql Php
If you are thinking of web development and you are a free and open source software lover, then LAMP is the ideal tool for you in developing high-ended dynamic web applications…
Here, i’ll show you how to install LAMP on a Linux system that is running the Ubuntu flavor OS…..
So let’s get started…….
We install Apache first – which is the web server.
Open the terminal by: ctrl+alt+t and copy, paste the following command in your terminal:
sudo apt-get install apache2
Enter the password to grant administrative privileges and press enter….
In order to test whether apache is running or not open your web browser and type:
You will see a default folder, open it and you’ll see the message: It Works! Continue reading
We Create a Database called zwaroop. Add a new table myTable with fields: ID as INT, Name as VARCHAR(50), Email as VARCHAR(50).
For those who are using LAMP, WAMP, XAMPP etc.. this is straight forward… Go ahead to your web browser and navigate to http://localhost/phpmyadmin
, which is a GUI that allows you to construct your database as quickly as possible.
So far we have.,
Database Name: zwaroop
Table Name: myTable
Field Names: ID, Name, Email
This is our basic html page that the user will be viewing it…
<!-- include jquery library file-->
<label>ID: </label> <input id="ID" type="text" />
<label>Name: </label> <input id="Name" type="text" />
<label>E-Mail: </label> <input id="Email" type="text" />
<a id="insert" title="Insert Data" href="#">Push into mysql</a>
<!-- For displaying a message -->
Create a page called insert.php, this page include all the server-sided code for inserting data into our mysql database. Assume our front-end html page consists of 3 input boxes that takes the ID, Name and Email… So here we go,