如何格式化PHP的Bootstrap DatePicker

Question

I am using this Bootstrap DatePicker: code below

<input class="datepicker" name="date">

<script> //date picker js
  $(document).ready(function() {  
      $('.datepicker').datepicker({
         todayHighlight: true,
         "autoclose": true,
      });
  });   
</script>

and I capture that in my PHP here:

$date = $_POST['date'];

The problem is that the DatePicker gives me the format dd/mm/yyyy when I need it yyyy-mm-dd in my $date variable. How do I reformat this?

Answer 1

****** SOLUTION ******

To solve this issue I saw that the variable 'date' was formatted dd/mm/yyyy and was a string. I was able to parse it and rebuild as a date in the proper format.

list($m,$d,$y) = explode("/",$_POST['date']);
$timestamp = mktime(0,0,0,$m,$d,$y);
$date = date("Y-m-d",$timestamp);

*Note - I also had to surround the $date variable in single quotes in the query:

$sql = "INSERT INTO tableName (..., date, ...)
        VALUES (..., '".$date."', ...)";