Çó½ÌÒ»¸öphpÏòmysql²åÈëʱ¼äµÄÎÊÌâ

ÎÒ¿ÉÒÔ´Óxml¶Áµ½Ò»¸öʱ¼ä£º1235716200000
ËƺõÓõÄdateµÄʱºòÐèÒª³ý1000
ËùÒÔÎÒÓÃ$start_time = $post->getElementsByTagName("StartTime")->item(0)->nodeValue/1000;

È»ºó$query="INSERT INTO `test` (`start_time`) VALUES (".$start_time.")";
½á¹û±¨´í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 '06:30:00)' at line 1

¼ÓÁ½¸öÒýºÅ$query="INSERT INTO `test`(`start_time`) VALUES ('".$start_time."')";
Ò²±¨´íIncorrect datetime value: '1970-01-01 00:00:00' for column 'start_time' at row 1

Çó½Ì´ïÈË£¬ÕâÊÇʲôÎÊÌ⣿ԭÒòÊÇʲô£¬Ó¦¸ÃÔõôÕýÈ·²åÈë

---

È¥µôµã .

Òª²»°ÑsqlÓï¾äÊä³öÀ´¿´ÏÂ

---

$result = $db->query($query);
if (!$result){
echo $query."\n";
echo $db->error.$discover.' <br />';
}else{
//echo $Title."added. <br />";
}

---

php±äÁ¿ÔÚË«ÒýºÅÖÐÄÜÖ±½Óʹ
$query="INSERT INTO `test` (start_time) VALUES ($start_time)";
ÕâÑù×ÓÓ¦¸Ã¿ÉÒÔ°É

---

²»ÐУ¬±¨´í

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 '06:30:00)' at line 1

---

echo "INSERT INTO `test` (start_time) VALUES ($start_time)";