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 — lakshya_arora
– lakshya_arora, Commented Mar 24, 2015 at 14:34

MilanG · Accepted Answer · 2015-03-24 14:40:10Z

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, 2015 at 14:40

answered Mar 24, 2015 at 14:33

MilanG

7,1442 gold badges42 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting the date in mysql using input type date

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related