如何获得帖子的日期和时间？

Question

I got this feedback form I made, and I would like to get the date and time, when a person posted a feedback, and display it next to their name. So, how can I get the date and time?

Here is the code for the form:

<?php
    if(isset($_POST['add'])){
        $name = $_POST['name'];
        $email = $_POST['email'];
        $comment = $_POST['comment'];
        if($name){
            if($email){
                if($comment){
                    mysql_query("INSERT INTO comments (id, name, email, comment) VALUES ('','$name','$email','$comment')");
                    //redirect
                    header("Location: mypage.php");
                }
                else
                    $msg = "You haven't entered any comment!";
            }
            else
                $msg = "You haven't entered an email address!";
        }
        else
            $msg = "You haven't entered your name!";
    }
?>

Answer 1

You could get the date and time at the point of the $_POST of your current system by using:

$curDate = date('Y-m-d H:i:s');

This would return the date/time in the following format: 2015-01-11 13:17:52 - Which you can then store in the database with your INSERT INTO query.

Make sure you have the correct timezone set within PHP as by default it may return UTC time. http://php.net/manual/en/function.date-default-timezone-set.php