Converting Unix Timestamp to MySQL DATETIME

Question

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?

possible duplicate of How to convert timestamp to datetime in MySQL? — trejder
– trejder, Commented Dec 10, 2014 at 13:49

Community · Accepted Answer · 2017-05-23 12:16:53Z

12

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

How can I prevent SQL injection in PHP?

edited May 23, 2017 at 12:16

CommunityBot

11 silver badge

answered Jan 8, 2013 at 9:48

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Converting Unix Timestamp to MySQL DATETIME

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related