Inserting DATETIME to SQL from PHP [duplicate]

Question

I can't seem to store the datetime to the database.

public function add_post($username, $content) {
    date_default_timezone_set("Asia/Manila");
    $date = date("m/d/Y h:i A");
    $final = strtotime($date);
    $time_posted = date("m/d/Y h:i A", $final);

    $sql =" INSERT INTO POSTS (username, post_content, time_posted)
            VALUES ('$username','$content','$time_posted')";

        return $this->db->query($sql);
}

It looks like this in the database 0000-00-00 00:00:00

Here is my posts table: Posts table

Answer 1

The date-time field should be formatted as:

$time_posted = date("Y-m-d H:i:s", $final);

Answer 2

Help this code for you,

public function add_post($username, $content) {
   date_default_timezone_set("Asia/Manila");
   $date = date("m/d/Y h:i A");
   $final = strtotime($date);
   $time_posted = date("Y-m-d H:i:s", $final);

   $sql =" INSERT INTO POSTS (username, post_content, time_posted)
        VALUES ('$username','$content','$time_posted')";

    return $this->db->query($sql);
}

Answer 3

MySQL time-stamp has a fixed pattern for date time input i.e. "Y-m-d H:i:s", If you want to insert date time into database then convert the pattern to the above mentioned one and then try. It'll work