---
description: https://laratutorials.com/php-mysql-contact-us-form-with-database/
---

# PHP MySQL Contact us Form with database

## PHP MySQL Contact us Form with database

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

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.

### How to Create a Contact Form with PHP

Follow the below given simple steps to create simple contact us form in PHP MySQL and store it into database:

#### Step 1 – Requirement and Create Directory

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:\<?phpif(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:![](https://laratutorials.com/wp-content/uploads/2020/09/simple-contact-us-form-in-php-1024x341.png)
