Getting the date in mysql using input type date

Question

I want to get the date in mysql using input type="date" .. please help for the code...

here is my code:

<form action="sales.php" method="get">
  <input type="date" name="d1" value="" required="required" />
  <input id="btn" type="submit" value="Search">
</form>

Here is my connection:

<?php 
  if (isset($_GET[ "d1"])) { 
    $do=$_GET[ "d1"]; 
  } else { 
    $do=0;
  }; 
  $result=$ db->prepare("SELECT * FROM sales WHERE date=:a");
  $result->bindParam(':a', $do); 
  $result->execute(); 
  for($i=0; $row = $result->fetch(); $i++){ 
?>

Thanks in advance

possible duplicate of [Inserting Date from form using PHP Mysql](http://stackoverflow.com/questions/12729113/inserting-date-from-form-using-php-mysql) — lakshya_arora, Mar 24 '15 at 14:34

MilanG · Answer 1 · 2015-03-24T14:40:10.073

0

Inside that sales.php script print out:

$date_value =  $_GET['d1'];
echo $date_value;

$myslq_date = date ('Y-m-d H:i:s', strtotime ($date_value));

But check for browser compatibility for that input type - not sure how it's supported.

edited Mar 24 '15 at 14:40

answered Mar 24 '15 at 14:33

MilanG

6,994
2
35
64

Getting the date in mysql using input type date

1 Answers1