PHP MySQL Record Insert Using Form Example

PHP MySQL Record Insert Using Form Example


Posted in : PHP Posted on : February 3, 2011 at 5:37 PM Comments : [ 0 ]

This example gives a demo to insert records in mysql database table using html form in php application.

PHP MySQL Record Insert Using Form Example:

This example gives a demo to insert records in mysql database table using html form in php application.

First of all create a database using create database statement like:

CREATE DATABASE php_mysql;

After that create table using create "user" table statement like:

CREATE TABLE user( 
user_id int(11) NOT NULL auto_increment, 
user_name varchar(20) default NULL, 
user_email varchar(50) default NULL, 
user_address varchar(150) default NULL, 
PRIMARY KEY (user_id) 
)

After that we will run this example for insert record using form. In this example we will used POST method for form submission.

Example:

<?php
$connection = mysql_connect("localhost","root","root");
if (!$connection) {
die('PHP Mysql database connection could not connect : ' . mysql_error());
}
else{ 
$db_name = "php_mysql";
mysql_select_db($db_name, $connection);
if(isset($_POST['submit'])){
if($_POST['user_name']!="" && $_POST['user_email']!="" && $_POST['user_address']!=""){
$sql = "insert into user(user_name, user_email, user_address)
values('".$_POST['user_name']."', '".$_POST['user_email']."',
'".$_POST['user_address']."');";
mysql_query($sql, $connection);
printf("Last inserted record has id %d\n", mysql_insert_id());
}
}
}
?> 
<html>
<body>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<table>
<tr>
<td>User Name : </td>
<td><input type="text" name="user_name" /></td>
<td></td>
</tr>
<tr>
<td>Email : </td>
<td><input type="text" name="user_email" /></td>
<td></td>
</tr>
<tr>
<td>Address : </td>
<td><input type="text" name="user_address" /></td>
<td></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name='submit' value="Submit"/></td>
<td></td>
</tr>
</table> 

</form>
</body>
</html>

After running this example the output is:

Output:

After form submission the browser output is

And the database user table output is:

Download Example Code

Go to Topic «PreviousHomeNext»

Your Comment:


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 

 
Tutorial Topics