php – 如何在mysql中插入日期和时间并查看它们

public function save_blog($data,$files) {

    $category_id = $data['category_id'];
    $blog_title = $data['blog_title'];
    $blog_short_description = $data['blog_short_description'];
    $publication_status = $data['publication_status'];
    $blog_long_description = $data['blog_long_description'];

    $path=  '../asset/admin/blog_image/';
    $target_image = $path.$files['blog_image']['name'];
    $file_type = pathinfo($target_image,PATHINFO_EXTENSION);
    $file_size = $files['blog_image']['size'];
    $check = getimagesize($files['blog_image']['tmp_name']);
    if ($check) {
        if (file_exists($target_image)) {
            echo 'Sorry File already exists.';
            exit();
        } else {
            if ($file_size > 1000000) {
                echo 'Sorry uour file Size is too large.';
                exit();
            } else {
                if ($file_type != 'jpg' && $file_type != 'png') {
                    echo 'Sorry your file type is not valid.';
                    exit();
                } else {
                    move_uploaded_file($files['blog_image']['tmp_name'],$target_image);
                    $date=date("M  j,Y,g:i a");
                    try {
                        $query = "INSERT INTO tbl_blog(category_id,blog_title,blog_short_description,blog_long_description,blog_image,publication_status,post_time) VALUES(:category_id,:blog_title,:blog_short_description,:blog_long_description,:blog_image,:publication_status,:date)";
                        $stmt = $this->pdo->prepare($query);
                        $stmt->bindParam(':category_id',$category_id,PDO::PARAM_STR);
                        $stmt->bindParam(':blog_title',$blog_title,PDO::PARAM_STR);
                        $stmt->bindParam(':blog_short_description',$blog_short_description,PDO::PARAM_STR);
                        $stmt->bindParam(':blog_long_description',$blog_long_description,PDO::PARAM_STR);
                        $stmt->bindParam(':blog_image',$target_image,PDO::PARAM_STR);
                        $stmt->bindParam(':publication_status',$publication_status,PDO::PARAM_INT);
                        $stmt->bindParam(':date',$date);
                        $stmt->execute();
                        $message = "Save Blog information successfully";
                        return $message;
                    } catch (PDOException $e) {
                        echo $e->getMessage();
                    }
                }
            }
        }
    }
    else {
    echo 'Sorry ! this is not an image !';
    exit();
    }
}

在mysql中我创建列名称：post_time,类型：DATETIME.它是否正确？

如何将时间视为我想要的格式时间：下午2:50和日期,日期为2016年8月7日

嗨,这是更新的代码,工作正常.我的问题是如何跳过我的.csv文件的第一行,该文件通常包含标题(id,name,email,address).

<?php
include 'connection.php';

class Import {
    private $pdo;

    public function __construct() {     
        $obj_connection = new Db_connection();
        $this->pdo = $obj_connection->connection();     
    }

    public function import_csv() {

        $extension= end(explode(".",basename($_FILES['file']['name'])));
        if (isset($_FILES['file']) && $_FILES['file']['size'] < 10485760 && $extension=='csv') {
            $file = $_FILES['file']['tmp_name']; 
            $handle = fopen($file,"r"); 
            try {           
                while (($data = fgetcsv($handle,1000,",")) !== FALSE) {                   
                $importSQL = "INSERT INTO tbl_applicants ( application_no,applicant_name,applicant_email,applicant_mobile,applicant_address ) VALUES('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]')";
                $this->pdo->query($importSQL);  
                }
            }
            catch(PDOException $e) {
                echo $e->getMessage();
            }

        }
    }

}