使用 PHP 在 mongodb 中插入和检索日期和时间戳

composer require mongodb/mongodb

<?php
require 'vendor/autoload.php';

// 连接到 MongoDB
$manager = new MongoDB\Driver\Manager("mongodb://localhost:27017");

// 创建一个 UTCDateTime 对象
$datetime = new MongoDB\BSON\UTCDateTime();

// 插入一个包含日期和时间戳的文档
$bulk = new MongoDB\Driver\BulkWrite();
$bulk->insert([
    "name" => "John",
    "created_at" => $datetime,
    "timestamp" => $datetime->toDateTime()->getTimestamp()
]);
$result = $manager->executeBulkWrite("test.users", $bulk);

// 查询刚刚插入的文档
$query = new MongoDB\Driver\Query([], ["limit" => 1, "sort" => ["_id" => -1]]);
$cursor = $manager->executeQuery("test.users", $query);
$document = $cursor->toArray()[0];

// 输出日期和时间戳
echo "Created at: " . $document->created_at->toDateTime()->format('Y-m-d H:i:s') . "\n";
echo "Timestamp: " . $document->timestamp . "\n";