1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 |
<?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
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
<?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"); } } ?> |