



Have inserted the following before the Insert, but it's not inserting in the correct format and seems to be defaulting to 1970-01-01 00:00:00
<?php
if(isset($_POST['ADDEVENTPICKER'])) {
$_POST['ADDEVENTPICKER'] = date("Y-m-d", strtotime($_POST['ADDEVENTPICKER']));
}
?>
<?php
if (isset($_POST["formADDEVENTBTN"]) || isset($_POST["formADDEVENTBTN_x"])) {
$InsertQuery = new WA_MySQLi_Query($SMTmysqli);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "SMTevents";
$InsertQuery->bindColumn("SMTeventtitle", "s", "".((isset($_POST["SMTeventtitle"]))?$_POST["SMTeventtitle"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMTeventdesc", "s", "".((isset($_POST["SMTeventdesc"]))?$_POST["SMTeventdesc"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMTeventdate", "t", "".((isset($_POST["ADDEVENTPICKER"]))?$_POST["ADDEVENTPICKER"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMTeventtime", "s", "".((isset($_POST["SMTeventtime"]))?$_POST["SMTeventtime"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMTvenueID", "i", "".((isset($_POST["SMTeventvenue"]))?$_POST["SMTeventvenue"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("SMTeventimg", "s", "".$WA_DFP_UploadStatus["WA_UploadResult1"]["serverFileName"] ."", "WA_DEFAULT");
$InsertQuery->saveInSession("NEWEVENTID");
$InsertQuery->execute();
$InsertGoTo = "add-event-confirm.php";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);
}
?>
Here's the Datepicker code:
<link type="text/css" href="../webassist/datepicker/add-event_datepicker_1/jquery-ui.css" rel="stylesheet" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<script src="//ajax.googleapis.com/ajax/libs/jqueryui/1/jquery-ui.min.js"></script>
<script type="text/javascript">
$(function(){
$('#datepicker_1').datepicker({
showButtonPanel:true,
dateFormat:"dd/mm/yy"
});
});
function closeDatePicker_datepicker_1() {
var tElm = $('#datepicker_1');
if (typeof datepicker_1_Spry != null && typeof datepicker_1_Spry != "undefined" && ADDEVENTPICKER_Spry.validate) {
datepicker_1_Spry.validate();
}
var docElm = document.getElementById("datepicker_1");
var tBlur = docElm.getAttribute("onBlur");
if (!tBlur) tBlur = docElm.getAttribute("onblur");
if (!tBlur) tBlur = docElm.getAttribute("ONBLUR");
if (tBlur) {
tBlur = String(tBlur).replace(/\bthis\b/g, "docElm");
eval(tBlur);
}
}
</script>
And the Datepicker form field...
<div class="form-group">
<label for="ADDEVENTPICKER" class="col-sm-2 control-label">Date:</label>
<div class="col-sm-10">
<input id="datepicker_1" name="ADDEVENTPICKER" type="text" placeholder="Click here to select a date" />
</div><!-- col-sm-10 -->
</div><!-- end form-group -->
I've attached the page also, for inspection. Thank you.