Feeds:
Posts
Comments

Archive for January 6th, 2011

Hai yesterday from our mentor, Thyagu sir’s class i learned how to insert the values into MySQL database through PHP script.

Here iam sharing my experiences of how i did this process

Before proceeding with this task, we need to install LAMP stack on our machines.

To do it in one command, open the terminal and type

sudo tasksel install lamp-server

The first step is to write a html code to design a form

For example say the name as input.html


<html>
<head>
</head>
<body>
<form name="run" action="store.php" method="post">
Name : <input type="text" name="name" /> <br />
Address : <input type="text" name="address" /> <br />
<input type="submit" value="Clickme" />
</form>
</body>
</html>

Store this file into documentroot i.e., /var/www

The second step is to create a database in mysql and a table inside the database

To create a database in mysql we need to enter into mysql shell prompt.

To do it, enter the following command from the terminal

$ mysql -u root -p

You will be asked to enter a password

Enter password:

Give your mysql password which you gave during mysql installation

You will get a mysql shell prompt which looks as follows

mysql>

Now create a database using mysql commands

Here i attached a screenshot to describe the steps done in mysql db

The last step is to write a PHP script to receive the values entered in the HTML file

Store the below script in a file matching the name of attribute ‘action’ in html code ( here store.php )

Place this file inside document root i.e., /var/www


<?php
$conn = mysql_connect('localhost','root','yourmysqlpassword') or die('Iam dying');
mysql_select_db('slash',$conn);
$name = $_POST['name'];
$address = $_POST['address'];
$string = "insert into slashprog(name,address) values('".$name."','".$address."')";
mysql_query($string,$conn);
mysql_close();
?>

Now run the Apache Web Server

/etc/init.d/apache2 start on Ubuntu 10.04

Open a browser and type http://localhost/input.html.

You can see the form looks like below

Enter the values and press the ‘Clickme’ button to do insertion

Now go to mysql shell and confirm whether the values are inserted or not.

That’s all the values get inserted.

Our next step is to convert the same concept into Ruby on Rails

 

Advertisements

Read Full Post »