Step 1: Create a Contact Form
<!DOCTYPE html>
<html>
<head>
<title> Simple PHP contact form
with MySQL and Form Validation </title>
</head>
<body>
<h3> Contact US</h3>
<form action="thankyou.php"
method="post">
Name:<br>
<input type="text" name="u_name"
required><br>
Email:
<input type="email" name="u_email"
required><br>
Subject:<br>
<input type="text" name="subj"
required><br>
Message:<br>
<input type="text" name="message"
required><br>
<input type="submit" value="Submit"><br>
</form>
</body>
</html>
Step 2: Create Database
Step 3: Create Table
Step 4: Create Database Connection
<?php
function Connect()
{
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "responses";
// Create connection
$conn = new mysqli($dbhost,
$dbuser, $dbpass, $dbname) or die($conn->connect_error);
return $conn;
}
?>
Step 5: Create Insert Function and Thank You Page
<?php
require 'connection.php';
$conn = Connect();
$name = $conn->real_escape_string($_POST['u_name']);
$email =
$conn->real_escape_string($_POST['u_email']);
$subj =
$conn->real_escape_string($_POST['subj']);
$message = $conn->real_escape_string($_POST['message']);
$query = "INSERT into
tb_cform (u_name,u_email,subj,message) VALUES('" . $name . "','"
. $email . "','" . $subj . "','" . $message .
"')";
$success = $conn->query($query);
if (!$success) {
die("Couldn't enter data:
".$conn->error);
}
echo "Thank You For Contacting Us <br>";
$conn->close();
?>
Step 6: Run It
No comments:
Post a Comment