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

我正在尝试创建一个双层博客.我想跟踪注册用户发布博客的日期和时间.稍后博客将在前端发布时间在我的博客中查看时间：下午2:50 / am,日期为日期：2016年8月7日.

这是插入代码

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).

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();

}

}

}

}