Converting Unix Timestamp to MySQL DATETIME
14,178
remove single quotes aroung the function FROM_UNIXTIME
because it will make it a value. eg
$sql = "INSERT INTO `calendar` (`date`, `title`, `event`) VALUES (FROM_UNIXTIME(".$datestr."), '".mysql_real_escape_string($_POST['title'])."', '".mysql_real_escape_string($_POST['desc'])."')";
As a sidenote, your query is vulnerable with SQL Injection
, please see the article below to learn how to protect from it
Related videos on Youtube
Comments
-
I wrestled a bear once. almost 2 years
This sounds silly but for the life of me I cannot figure it out. I have tried everything.
The problem is that I cannot figure out how to get my date string into my MySQL table... I've been converting to Unix first to account for variations in input format..
$_POST['date']
is in this format:19-1-2013 4:43:32$datestr= strtotime($_POST['date']); echo $datestr; $sql = "INSERT INTO `calendar` (`date`, `title`, `event`) VALUES ('FROM_UNIXTIME(".$datestr.")', '".mysql_real_escape_string($_POST['title'])."', '".mysql_real_escape_string($_POST['desc'])."')"; $query = mysql_query($sql);
This is the most recent thing I've tried and I'm still getting all zeros in my DATETIME field.
Please, what am I doing wrong?