PHP - INSERT a variable of type Time into a column in MySQL of type Time

Question

I keep getting this error:

"Catchable fatal error: Object of class DateTime could not be converted to string"

From this code:

<?php
   $value_startTime = new DateTime();
   $value_startTime->setTime($value_HourStart,$_POST['TextBoxStartMin'],0);

   $value_endTime = new DateTime();
   $value_endTime->setTime($value_HourEnd,$_POST['TextBoxEndMin'],0);

   $query_InsertJob="INSERT INTO job (jobDesc,timeStart,timeEnd)
   VALUE ('$_POST[TextAreaProblem]','$value_startTime','$value_endTime')";
?>

These variables can have values from 00 to 23: $value_HourStart $value_HourEnd

These variables can have values from 00 to 59: $_POST['TextBoxStartMin'] $_POST['TextBoxEndMin']

I am having no trouble with: $_POST[TextAreaProblem]

What is it that I am doing wrong?

Phil · Accepted Answer · 2011-07-29 02:49:58Z

1

You need to convert those DateTime objects into strings for use in the query.

Try something like this (PDO example because I can't abide encouraging people to use the mysql_* functions)

$stmt = $db->prepare('INSERT INTO job (jobDesc, timeState, timeEnd) VALUES (?, ?, ?)');
$stmt->execute(array(
    $_POST['TextAreaProblem'],
    $value_startTime->format('H:i:s'),
    $value_endTime->format('H:i:s')
));

answered Jul 29, 2011 at 2:49

Phil

166k25 gold badges265 silver badges269 bronze badges

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

Comments

Andreas · Accepted Answer · 2011-07-29 02:47:44Z

0

$value_startTime and $value_endTime are objects. Try it with $value_startTime->getTimestamp().

$query_InsertJob="INSERT INTO job (jobDesc,timeStart,timeEnd) VALUE ('$_POST[TextAreaProblem]','".$value_startTime->getTimestamp()."','"$value_endTime->getTimestamp()."')";

answered Jul 29, 2011 at 2:47

Andreas

2,6682 gold badges22 silver badges33 bronze badges

Collectives™ on Stack Overflow

PHP - INSERT a variable of type Time into a column in MySQL of type Time

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related