How to Insert DATE Value into Database in PHP MySQL

By Super Admin | May 15, 2021 | PHP
Share : Whatsapp

https://www.fundaofwebit.com/post/how-to-insert-date-values-into-database-in-php-mysql

How to Insert DATE Value into Database in PHP MySQL


in this post, you will be learning about how to insert date value into database in php mysql, where we will take the input type as date and insert date value in mysql database using php on the form submit by method POST.

I have used Bootstrap v5 to design the user interface.

Lets get started to: (How to insert date in mysql using php)

Note: For better and detailed understanding. please watch out the Video above.

Step 1: Create a table named demo into your Database (MySQL) as follows:

CREATE TABLE `demo` (
    `id` int(11NOT NULL,
    `name` varchar(191NOT NULL,
    `date` DATE NOT NULL
);

Step 2: Create a index.php file and paste the below html form design code:

<?php session_start();?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Funda of Web IT</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
    
    <div class="container">
        <div class="row justify-content-center">
            <div class="col-md-8">

                <?php 
                    if(isset($_SESSION['status']))
                    {
                        ?>
                            <div class="alert alert-warning alert-dismissible fade show" role="alert">
                            <strong>Hey!</strong> <?php echo $_SESSION['status']; ?>
                            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                            </div>
                        <?php
                        unset($_SESSION['status']);
                    }
                ?>

                <div class="card mt-5">
                    <div class="card-header">
                        <h4>How to Insert Date Values into Database in php</h4>
                    </div>
                    <div class="card-body">
                        
                        <form action="code.php" method="POST">
                            <div class="form-group mb-3">
                                <label for="">Name</label>
                                <input type="text" name="name" class="form-control" />
                            </div>
                            <div class="form-group mb-3">
                                <label for="">Date of Birth</label>
                                <input type="date" name="dateofbirth" class="form-control" />
                            </div>
                            <div class="form-group mb-3">
                                <button type="submit" name="save_date" class="btn btn-primary">Save Data</button>
                            </div>
                        </form>

                    </div>
                </div>
            </div>
        </div>
    </div>

    <script src="https://code.jquery.com/jquery-3.5.1.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>

Now, when you click on the Submit button, the <form> contains action="code.php" so, lets go to Step 3 to write the code:

Step 3: Create a code.php file and paste the below code to insert date value in mysql database in php.

<?php
session_start();
$con = mysqli_connect("localhost","root","","phptutorials");

if(isset($_POST['save_date']))
{
    $name = $_POST['name'];
    $dob = date('Y-m-d'strtotime($_POST['dateofbirth']));

    $query = "INSERT INTO demo (name,dob) VALUES ('$name','$dob')";
    $query_run = mysqli_query($con$query);

    if($query_run)
    {
        $_SESSION['status'] = "Date values Inserted";
        header("Location: index.php");
    }
    else
    {
        $_SESSION['status'] = "Date values Inserting Failed";
        header("Location: index.php");
    }
}
?>


Thanks for reading...