I am trying to save dates generated from jQuery datepicker into a mysql database. I am using ajax but I only ever manage to save 1969-12-31. The mysql fields are expecting a date value.
Any help would be great, many thanks.
The datepicker and form
<script>
$(document).ready(function(){
$("#success").hide();
$(function() {
$( "#start" ).datepicker({
defaultDate: "+1w",
changeMonth: true,
numberOfMonths: 3,
onClose: function( selectedDate ) {
$( "#end" ).datepicker( "option", "minDate", selectedDate );
}
});
$( "#end" ).datepicker({
defaultDate: "+1w",
changeMonth: true,
numberOfMonths: 3,
onClose: function( selectedDate ) {
$( "#start" ).datepicker( "option", "maxDate", selectedDate );
}
});
});
$("#submitMe").on("click",function(){
var formdata = $(this.form).serialize();
$.post('dateinsert.php', formdata,
function(data){
$("#message").html(data);
$("#success").hide();
$("#success").fadeIn(500); //Fade in
});
return false;
});
});
</script>
</head>
<body>
<div class="container">
<div id="success" /></div>
</br>
<form>
<label for="start">From</label>
<input type="text" id="start" name="start">
<label for="end">to</label>
<input type="text" id="end" name="end">
<button type="submit" id="submitMe" class="btn btn-primary">Submit</button>
</form>
The PHP
<?php
//include db configuration file
include_once("config.php");
$start=$_POST['start'];
$end=$_POST['end'];
$starttime = date ("Y-m-d", $start);
$endtime = date ("Y-m-d", $end);
//Insert Data into mysql
$insert_row = $mysqli->query("INSERT INTO dates(start,end) VALUES ('$starttime','$endtime')");
if($insert_row){
echo
"success";
}
else{ echo "An error occurred!"; }
?>