edate = 11/05/2017
sdate = 11/17/2017
myid = 1
CODE --> php
$str = "Update mytable Set edate = :edate, sdate = :sdate, stime = :stime Where id = :myid"; $stmt = $conn->prepare($str); $stmt->bindParam(':edate', $_POST['edate'], PDO::PARAM_STR); $stmt->bindParam(':sdate', $_POST['sdate'], PDO::PARAM_STR); $stmt->bindParam(':myid', $_POST['myid'], PDO::PARAM_STR);
I have tried date ("Y-m-d", $edate) and many other variations. I also had the fields originally set to Date and Time but have not done much with the Time field, figured I would concentrate on the Date fields first. Does anyone have any ideas?