Hi friends.. Today i am going to tell you about how to insert data available in HTML from using PHP in to MySQL database. Here i will use post method for transfer data using HTML form to my PHP script. Lets see here how to create form without having table. I mean you can create a HTML form and you want to align it in proper manner. In here you can see inside my css code i have aligned it without using table .OK here is my code for create HTML form
Below you can seemy css code for displaying the proper out put like this
<!--
To change this template, choose Tools | Templates
and open the template in the editor.
-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<style type="text/css">
body {background-color:black;}
#main-body {width: 350px;
height: 250px;
background-color: cornflowerblue;
border: 6px brown dashed;
margin-left: 300px;
margin-top: 200px;
padding: 10px;
}
#main-body-inner
{
width: 340px;
height: 240px;
background-color: white;
margin-top:5px;
margin-left: 5px;
}
#myform {padding: 30px;}
#myform label,input{ display: block;
width: 120px;
float: left;
margin-bottom: 10px;
}
#myform label{
text-align: right;
padding-right: 20px;
}
br
{
clear: left;
}
#submit {width: 75px; float: left; margin-left: 175px;}
</style>
<title>INSERT DATA USING PHP TO MYSQL DATABASE</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div id="main-body">
<div id="main-body-inner">
<form id="myform" name="myform" action="insert.php" method="post">
<label for="first-name">First Name</label>
<input type="text" id="fname" name="fname" /> <br />
<label for="last-name">Last Name</label>
<input type="text" id="lname" name="lname" /><br />
<label for="age">Age</label>
<input type="text" id="age" name="age" /><br />
<input type="submit" id="submit" value="Submit" />
</form>
</div>
</div>
</body>
</html>
Now we have created our html form and we have styled it. Below you can see my PHP code.
<?php
/*
* author :damith.uwu@gmail.com
*
*
*
*/
include 'connection.php';
if(isset ($_POST['fname']) && isset ($_POST[ 'lname']) && isset ($_POST[ 'age'])) // getting the values from the post
{
$connection = new createConnection(); // creating connection
$connect = $connection->connectToDatabase(); // connect to database
$connection->selectDatabase(); // select database
$fname = mysql_real_escape_string($_POST['fname']); // escape sql injection
$lname =mysql_real_escape_string($_POST['lname']);
$age = mysql_real_escape_string($_POST['age']);
$query="insert into test values ('$fname','$lname','$age')"; // query for insert data
mysql_query($query); // execute the insert query
echo ("User registration Successfull..");
echo "<a href='index.html'><h1>Go Back </h1> </a>"; // link for go back
$connection->closeConnection(); // closing the connection
}
else
{
echo "Error occured!"; // display error message
}
?>
In here i have used a connection class. Below you can see my connection class.
<?php
/**
* @author damith
* @copyright 2011
*/
class createConnection
{
var $host="localhost";
var $username="username here";
Var $password=" password here";
var $database="databse name";
var $myconn;
function connectToDatabase()
{
$conn= mysql_connect($this->host,$this->username,$this->password);
if(!$conn)
{
die ("Cannot connect to the database");
}
else
{
$this->myconn = $conn;
}
return $this->myconn;
}
function selectDatabase()
{
mysql_select_db($this->database);
if(mysql_error())
{
echo "Cannot find the database ".$this->database;
}
}
function closeConnection()
{
mysql_close($this->myconn);
}
}
?>
When you completed the insert process you can see the message like this.
OK you done.. Download the full source from here
Damith's Blog 