hai friends!
In this Artical i am going to show you how to insert Data into Data Base by using PHP and MYSQL.
creating a new data dase and inserting data is very simple .
now we are going to create new data base by using the following steps.
here iam going to insert and display contact data into data base.
step 3:we required this code to connect with data base db_connection.php
<!--php
date_default_timezone_set('Asia/Kolkata');
$server="localhost";
$username="root";
$password="";
$dbname="apple";
$conn=new mysqli($server,$username,$password,$dbname);
if($conn--->connect_error)
{
die("connection failed:".$conn->connection_error);
}
?>
step 4:we need this code to insert data into Data Base ,all the contact form functionality works in this page ,this will helps to insert data into DB
<!--php
extract($_REQUEST);
include('db_connection.php');
$sql=$conn--->query("INSERT INTO `contact_table`(`name`, `email`, `address`, `message`, `CreatedOn`)
VALUES('$name','$email','$address','$message',now())");
if($sql===TRUE)
{
echo"<script>window.location.assign('contact.php?success=success')</script>";
}
else
{
echo"<script>window.location.assign('contact.php?success=failed')</script>";
echo $conn->error;
}
?>
step 5: Create Table in Data Base Table name as (contact_table) in apple DB
CREATE TABLE `contact_table` (
`id` int(20) NOT NULL,
`name` varchar(20) NOT NULL,
`email` varchar(50) NOT NULL,
`address` varchar(50) NOT NULL,
`message` varchar(200) NOT NULL,
`CreatedOn` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
0 Comments
Please do not Enter any Spam Link in the Comment Box
Emoji