php datetime insertion into mysql

Question

I am trying to insert the datetime into a column in a mysql table.

 <?php

//Some code

date_default_timezone_set('Europe/London');

//Other variables defined also

$date_time = new DateTime();


$queryreg = mysql_query ("

    INSERT INTO users VALUES ('','$username','$password','$email','$website','$image','$date_time')

    ");



?>

However the browser states: "Catchable fatal error: Object of class DateTime could not be converted to string in C:\xampp\htdocs\design\register.php on line 181". Any idea why it is doing this? Many thanks in advance.

possible duplicate of Using php DateTime object in mysql query — Ja͢ck
– Ja͢ck, Commented Dec 14, 2012 at 16:26

Marc B · Accepted Answer · 2012-12-14 15:06:37Z

5

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

INSERT INTO .... VALUES (..., '$date');

answered Dec 14, 2012 at 15:06

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

Comments

MrKiane · Accepted Answer · 2012-12-14 15:06:09Z

1

It is because you are trying to typecase $date_time to string by surrounding it with '' in your SQL query. Either remove the surrounding quotes or convert to string by doing:

$date_time->format('Y-m-d H:i:s');

answered Dec 14, 2012 at 15:06

MrKiane

5,0332 gold badges19 silver badges27 bronze badges

Comments

shadyyx · Accepted Answer · 2012-12-14 15:06:51Z

1

You have to use $datetime->format('Y-m-d H:i:s') for the insertion, like this:

INSERT INTO users VALUES ('', '$username', '$password', '$email', '$website', '$image', '{$date_time->format('Y-m-d H:i:s')}')

I also suggest not using mysql_* functions but rather learn using PDO with prepared statements or at least mysqli_* functions.

Also sanitize Your input to prevent SQL Injection.

answered Dec 14, 2012 at 15:06

shadyyx

16.1k7 gold badges62 silver badges98 bronze badges

Comments

jamesTheProgrammer · Accepted Answer · 2012-12-14 15:10:25Z

1

Provide a string format for the date, like this:

date_format(variable, "string format")

date_format($date_time, "%m/%d/%y"), for example.

answered Dec 14, 2012 at 15:10

jamesTheProgrammer

1,7734 gold badges22 silver badges34 bronze badges

Comments

Igor Popov · Accepted Answer · 2012-12-14 15:09:02Z

0

The best solution is to have timestamp field in table with default value CURRENT_TIMESTAMP.

But if you want to control manually this one then you need to convert DateTime object to a string like this:

<?php
//Some code
date_default_timezone_set('Europe/London');

//Other variables defined also
$date_time = new DateTime();

$queryreg = mysql_query("INSERT INTO users VALUES
      ('','$username','$password','$email','$website','$image',
      '{$date_time->format('Y-m-d H:i:s')}')");
?>

answered Dec 14, 2012 at 15:09

Igor Popov

9988 silver badges16 bronze badges

Collectives™ on Stack Overflow

php datetime insertion into mysql

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related