Error inserting datetime into mysql datetime column using PHP

Question

I'm trying to insert the datetime into a mysql column but I'm getting this error:

Error: INSERT INTO prices (priceLBTC, dt) VALUES (421.59, 2015-12-27 15:41:09) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '15:41:09)' at line 2

Here is the code I'm using to get the datetime and insert it into the "dt" datetime type column.

$dateTime = new DateTime();
$date = $dateTime->format('Y-m-d H:i:s');

$sql = "INSERT INTO prices (priceLBTC, dt)
VALUES ($bitcoinPrice, $date)";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

Put quotes around $date. Alternatively, consider using timestamps — Ohgodwhy
– Ohgodwhy, Commented Dec 27, 2015 at 21:15

Rahul · Accepted Answer · 2015-12-27 21:18:48Z

3

You are getting error cause your datetime value is not quoted as seen below and so DB engine throwing an error assuming you meant to provide more values.

INSERT INTO prices (priceLBTC, dt) VALUES (421.59, 2015-12-27 15:41:09)
                                                   ^.. Here

You need to quote your datetime value using single quote like

INSERT INTO prices (priceLBTC, dt) VALUES (421.59, '2015-12-27 15:41:09')

edited Dec 27, 2015 at 21:18

answered Dec 27, 2015 at 21:16

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

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

1 Comment

Darkstar Over a year ago

That's it, thanks! I didn't think it needed any because the price had none originally.

Max P. · Accepted Answer · 2015-12-27 21:16:13Z

1

$sql = "INSERT INTO prices (priceLBTC, dt) VALUES (".$conn->quote($bitcoinPrice).", ".$conn->quote($date).")";

answered Dec 27, 2015 at 21:16

Max P.

5,6992 gold badges17 silver badges35 bronze badges

Collectives™ on Stack Overflow

Error inserting datetime into mysql datetime column using PHP

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related