如何正确存储MongoDB isodate从PHP脚本

Question

我想使用PHP et MongoDB驱动程序在MongoDB集合中存储日期。

以下是我的部分脚本：

第一连接：

    public function process(){
    try{
        $this->connexion = new \MongoDB\Driver\Manager($this->dsn);
    }
    catch(\MongoDB\Driver\Exception\InvalidArgumentException $e){
        die("Unable to connect to the MongoDB database : " . $e->getMessage());
    } catch(\MongoDB\Driver\Exception\RuntimeException $e){
        die("General failure : " . $e->getMessage());
    }
}

第二：文档创建

    public function process(){
    $dbConnector = dbConnector::instance(); // Instance de connexion à la base de données


    $query = new \MongoDB\Driver\BulkWrite;

    $query->insert($this->queryArray);

    $writeConcern = new \MongoDB\Driver\WriteConcern(\MongoDB\Driver\WriteConcern::MAJORITY, 1000);
    //$collection = new \MongoCollection($dbConnector->connexion()->db(), $this->store->collectionName());
    try{
        $this->result = $dbConnector->connexion()->executeBulkWrite($dbConnector->dbName() . "." . $this->store->collectionName(), $query, $writeConcern);
    } catch (\MongoDB\Driver\AuthenticationException $e){
        echo "Authentication error : " . $e->getMessage() . "<br />\n";
    } catch(\MongoDB\Driver\ConnextionException $e){
        echo "Connexion error : " . $e->getMessage() . "<br />\n";
    }
    catch(\MongoDB\Driver\Exception\RuntimeException $e){
        echo "Runtime error : " . $e->getMessage() . "<br />\n";
    }
}

$queryArray属性包含我要创建的键/值对。

添加了一种转换方法，可以管理日期并将其转换为MongoDB ISODate：使用\MongoDB\BSON\UTCDateTime作为MongoUTCDate。。。公共静态函数toISODate（$date）{if（is_object（$date））{$dateToString=$date-

    #begin_debug
    #echo "Date from string " . $dateToString . " : " . $initDate->format("d-m-Y") . " (timestamp) " . $initDate->getTimestamp() . "<br />\n";
    #end_debug

    return new MongoUTCDate($initDate->getTimestamp());
}

我的控制器是这样工作的：

            $stats->_id = $this->requestData()->_id;

        $stats->purchases = [array(
            "date" => \wp\Database\MongoDB\Utilities\MongoDate::toIsoDate($this->requestData()->date),
            "coords" => array("lat" => $this->requestData()->coords->lat, "lon" => $this->requestData()->coords->lon),
            "metar" => null,
            "quantity" => $this->requestData()->quantity,
            "price" => (float) $this->requestData()->price,
            "peremption" => \wp\Database\MongoDB\Utilities\MongoDate::toIsoDate($this->requestData()->peremption)
        )];

        $stats->insert();

调用时，文档创建正确，但日期错误：

{
"_id" : "3256222010007",
"purchases" : [ 
    {
        "date" : ISODate("1970-01-18T07:43:01.706Z"),
        "coords" : {
            "lat" : 43.7294742,
            "lon" : 1.416332
        },
        "metar" : null,
        "quantity" : 1,
        "price" : 2.87,
        "peremption" : ISODate("1970-01-18T22:20:34.800Z")
    }
]
}

在前面的示例中，日期将是，即当天的日期。。。

当我记录数据时，我看到日期在PHP中的格式是正确的：

Date from string 2017-06-04 : 04-06-2017 (timestamp) 1496527200<br />

如果转换回时间戳，得到了正确的日期...所以，不明白为什么蒙戈日期是不正确的。

Answer 1

对于那些实验相同的问题，只需乘以1000 PHP给出的时间戳：

    public static function toISODate($date){
    if(is_object($date)){
        $dateToString = $date->year . "-" . $date->month . "-" . $date->day;
    } else {
        $dateToString = substr($date,0,10);
    }
    $initDate = new \DateTime($dateToString);

    #begin_debug
    #echo "Date récupérée à partir de " . $dateToString . " : " . $initDate->format("d-m-Y") . " (timestamp) " . $initDate->getTimestamp() . "<br />\n";
    #end_debug
    $stampedDate = $initDate->getTimestamp() * 1000;

    $mongoUTCDate = new MongoUTCDate($stampedDate);

    return $mongoUTCDate;
}

正确的日期已存储。。。