PHP Contact us Form with Database and Validation

PHP contact us form with database and validation; In this post, i will teach you how to create simple php contact us form & storing in mysql database with validation.

As well as you can use this code personally and professionally.

Description :- i will create database for store/save contact us form data. Then will create database connecting file and contact us form in Html. After that, will create store contact us form data and thank html page.

PHP Contact us Form with MySQL Database and Validation

  • Step 1 – Create PHP Project
  • Step 2 – Create phpmyadmin MySQL Database and Connecting File
  • Step 3 – Create Contact Us Form In HTML
  • Step 4 – Store Contact Us Form to Database
  • Step 5 – Create Thank You Html Page

Step 1 – Create PHP Project

In step 1, Navigate to your local web server directory. And inside this directory, create one directory. And you can name this folder anything.

Here, I will “demo” the name of this folder. Then open this folder in any text editor (i will use sublime text editor).

Step 2 – Create phpmyadmin MySQL Database and Connecting File

In step 2, you need to create database and table. So run the following sql query to create database and table:

CREATE DATABASE my_db;


CREATE TABLE `contact_us` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

Then create a php file that named mydbCon. Which is used to connect phpmyadmin mysql database to project (demo).

So, now create mydbCon file and add the below given code into your file:

<?php

    $hName='localhost'; // host name

    $uName='root';   // database user name

    $password='';   // database password

    $dbName = "my_db"; // database name

    $dbCon = mysqli_connect($hName,$uName,$password,"$dbName");

      if(!$dbCon){
          die('Could not Connect MySql Server:' .mysql_error());
      }
?>

Step 3 – Create Contact Us Form In HTML

In step 3, create a php file that named contact-us.php. This file will display PHP MySQL contact us form and store form data into MySQL database with validation.

Here, i will use html validation with PHP MySQL contact us form. Now, you need to add the following contact us form code into contact-us.php file:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>PHP Contact US Form with Database and Validation</title>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
</head>
<body>

<div class="container mt-2">
    <div class="row">
        <div class="col-md-12">
            <div class="page-header">
                <h2>PHP MySQL Contact US Form with Database</h2>
            </div>
           
            <form action="store-contact-us.php" method="post">

                <div class="form-group">
                    <label>Name</label>
                    <input type="text" name="name" class="form-control" required="">
                </div>                        


                <div class="form-group">
                    <label>Email</label>
                    <input type="email" name="email" class="form-control" required="">
                </div>

                <div class="form-group">
                    <label>Message</label>
                    <input type="text" name="massage" class="form-control" required="">
                </div>

                <input type="submit" class="btn btn-primary" name="submit" value="submit">
            </form>
        </div>
    </div>        
</div>

</body>
</html>

Step 4 – Store Contact Us Form to Database

In step 4, create new file that named store-contact-us.php file. Because this is used to store contact us form data into mysql database.

So, add the below code into your store-contact-us.php file:

<?php

if(count($_POST)>0)
{    
     include 'mydbCon.php';

     $name = $_POST['name'];
     $message = $_POST['message'];
     $email = $_POST['email'];
 
     $query = "INSERT INTO contact_us (name,message,email)
     VALUES ('$name','$message','$email')";

     mysqli_query($dbCon, $query);

     $lastId = mysqli_insert_id($dbCon);
 
     if (!empty($lastId)) {
        $message = "Your contact information is saved successfully";
     }

}
  header ("Location: thank-you.php");
?>

Step 5 – Create Thank You Html Page

In step 5, create thank-you.php file. After successfully saved contact us form data in PHP MySQL database. Then i will redirect to thank you page.

Add the following code into thank-you.php file:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Thanks for Contact US - PHP MySQL</title>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
</head>
<body>

<div class="container mt-2">
    <div class="row">
        <div class="col-md-12">
            <div class="page-header">
                <h2>Thanks for contacting us. We will get back you.</h2>
            </div>
        </div>
    </div>        
</div>

</body>
</html>

The php contact us form with validation and store it into database will look like in following image:

Recommended PHP Tutorials

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *