Home / Questions / 177997
Accepted
Brandon Castillo
Asked: 2020-07-05 14:48:08 +0800 CST 2020-07-05 14:48:08 +0800 CST

How can I remove "timezone_type" and "timezone" from my JSON?

  • 772

In my toJSON() function I display certain values ​​in them a datetime. Example:

 "gps": [
    {
        "serie": "12345",
        "name": "MasterK10",
        "dateUpdate": {
            "date": "2018-07-04 00:00:00.000000",
            "timezone_type": 3,
            "timezone": "Europe/Berlin"
        } 
]

I want it to just display like this:

"gps": [
        {
            "serie": "12345",
            "name": "MasterK10",
            "dateUpdate": "2018-07-04 00:00:00.000000",
    ]

I add my method and the image of the query in SQL-Server

public function toJson() {
    return json_encode(array(
        'serie' => $this->serie,
        'name' => $this->name,
        'dateUpdate' => $this->dateUpdate,
        'location' => json_decode($this->location->toJson()),
        'status' => $this->status
    ));
}

enter image description here

php

3 Answers

  1. You could get the array $this->dateUpdateand assign another variable with the string, so that it looks like this:

    public function toJson() {
    $dateUpdateArray = $this->dateUpdate;
    //Asignamos otra variable
    $dateUpdateString = $dateUpdateArray['date'];
    return json_encode(array(
        'serie' => $this->serie,
        'name' => $this->name,
        'dateUpdate' => $dateUpdateString,
        'location' => json_decode($this->location->toJson()),
        'status' => $this->status
    ));
}
    • 0

  2. You can access the property dateUpdate.updatedirectly like this:

       public function toJson() {
    return json_encode(array(
        'serie' => $this->serie,
        'name' => $this->name,
        'dateUpdate' => $this->dateUpdate['date'],
        'location' => json_decode($this->location->toJson()),
        'status' => $this->status
    ));
}

    I hope it helps you, greetings

    • 0
  3. Best Answer

    It worked for me with this code:

    'dateUpdate ' => date_format($this->dateUpdate , 'Y-m-d H:i:s')

    Thank you all.

    • 0