PHP Insert DATE in Database with datepicker

Insert DATE in PHP Database with datepicker

<?php session_start();?>
<html>
<body>
    
    <div>
        <div>
            <div class="col-md-8">

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

                <div>
                    <div>
                        <h4>How to Insert Date Values into Database in php</h4>
                    </div>
                    <div>
                        
                        <form action="second.php" method="POST">
                            <div>
                                <label for="">Please enter Name</label>
                                <input type="text" name="name" />
                            </div>
                            <div>
                                <label for="">Please enter Date of Birth</label>
                                <input type="date" name="BirthDate" />
                            </div>
                            <div>
                                <button type="submit" name="save_date">store Data</button>
                            </div>
                        </form>

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

   </body>
</html>

second.php

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

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

    $query = "INSERT INTO t4table (name,BirthDate) VALUES ('$name','$BirthDate')";
    $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");
    }
}
?>

PHP Insert DATE in Database with datepicker

Download PHP code to Insert DATE in Database with datepicker

Other Similar Codes of date in PHP