PHP MySQL Contact Us Form Example

Mar 02, 2022 . Admin



Hello Friends,

I am going to explain you PHP MySQL contact us form example. You will learn How to Create a PHP contact form with MySQL & HTML5 Validation. In side this article we will see how to Create a simple contact form in PHP with MySQL.

This article will give you simple example of contact us form in PHP MySQL. We will use get Simple PHP Contact Form to Send data & Storing In MySQL Database.

You can use from how to PHP Contact us Form with Database Example. I will give you simple How to Create a Contact Page with PHP.

So, let's see bellow solution:

index.php
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" type="text/css" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js"></script>
    
    <title>PHP MySQL Contact Us Form Example</title>
    
    <style type="text/css">
        .error
        {
            color: red;
        }
    </style>
    
</head>
<body>

<?php 
$nameErr = $emailErr = $passwordErr = $confirm_passwordErr = $messageErr = "";
$name = $email = $password = $confirm_password = $message = "";

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    if (empty($_POST['name'])) {
        $nameErr = "Name is required!";
    }
    
    if (empty($_POST['email'])) {
        $emailErr = "Email is required!";
    }

    if (empty($_POST['password'])) {
        $passwordErr = "Password is required!";
    }

    if (empty($_POST['confirm_password'])) {
        $confirm_passwordErr = "Confirm_password is required!";
    }

    if (empty($_POST['message'])) {
        $messageErr = "Message is required!";
    }

    if($_POST['password']!=$_POST['confirm_password']){
        $pass = "plese enter velid password and Confirm Password";
    }
    if (empty($nameErr)&&empty($emailErr)&&empty($passwordErr)&&empty($confirm_passwordErr)&&empty($messageErr)&&empty($pass)) {
            
            $name = $_POST['name'];
            $email = $_POST['email'];
            $password = $_POST['password'];
            $confirm_password = $_POST['confirm_password'];
            $message = $_POST['message'];

            $servername = "localhost";
            $username = "root";
            $password_db = "root";
            $dbname = "db_php";

            $conn = mysqli_connect($servername,$username,$password_db,$dbname);

            if (!$conn) {
                die("connection failed:".mysqli_connect_error());
            }

            $sql = "INSERT INTO users (name,email,password,confirm_password,message)
            VALUES('$name','$email','$password','$confirm_password','$message')"; 

            if ($conn->query($sql)===TRUE) {
                echo "<div class='msgbox alert alert-success p-1 text-center m-0 ' style='background-color:#9bffbbfa; width: 300px; height: 30px'>Data Insert Successfully</div>";
            }else{
                echo "Error: " .$sql . "<br>" . mysqli_error($conn);
            }
            $conn->close();
    }
}
?>
    <div class="container mt-5 ">
        <div class="card">
            <div class="card-header bg-dark text-white text-center">
                <h3>PHP MySQL Contact Us Form Example - Mywebtuts.com</h3>
            </div>
            <div class="card-body">
                <form action="<?php $_SERVER['PHP_SELF'] ?>" method="post">
                    
                    <div class="row">
                        <div class="col-md-6">
                            <label for="name">Name :</label>
                            <span class="error">*</span>
                            <input type="text" name="name" id="name" class="form-control">
                            <span class="error"><?php echo $nameErr ?></span>
                        </div>
                        <div class="col-md-6">
                            <label for="email">Email :</label>
                            <span class="error">*</span>
                            <input type="text" name="email" id="email" class="form-control">
                            <span class="error"><?php echo $emailErr ?></span>
                        </div>
                    </div>
                    
                    <div class="row mt-3">
                        <div class="col-md-6">
                            <label for="password">Password :</label>
                            <span class="error">*</span>
                            <input type="password" name="password" id="password" class="form-control">
                            <span class="error"><?php echo $passwordErr ?></span>
                        </div>
                        <div class="col-md-6">
                            <label for="confirm_password">Confirm Password :</label>
                            <span class="error">*</span>
                            <input type="password" name="confirm_password" id="confirm_password" class="form-control">
                            <span class="error"><?php echo $confirm_passwordErr ?></span>
                        </div>
                        <span class="error"><?php echo $pass ?></span>
                    </div>

                    <div class="mt-3">
                        <label for="message">Message :</label>
                        <span class="error">*</span>
                        <textarea rows="5" cols="40" class="form-control" id="message" name="message"></textarea>
                        <span class="error"><?php echo $messageErr ?></span>
                    </div>
                    <div class="text-center">
                            <input type="submit" name="save" class="btn btn-primary mt-3">
                    </div>
                </form>
            </div>
        </div>
    </div>
</body>
</html>
Output:

It will help you...
#PHP

You might also like...