How to save JSON in DB - laravel 8

Question

I'll have JSON and try to disassemble and save it in database:

{
    "token": "f56445c24ad84e9c452f3ca6ef91e90beb2aef21",
    "participant": "ZuP0rsny3MhqLC0",
    "data": {
        "orgs": [{
            "org1": {
                "attribute": [{
                    "name": "val",
                    "inn": "val",
                    "kpp": "val"
                }],
                "tickets": [{
                    "ticket1": [{
                        "account_uid": "val",
                        "created_at": "val",
                        "title": "val",
                        "text": "val",
                        "status": "val",
                        "priority": "val",
                        "fullname": "val",
                        "workaddr": "val",
                        "phone": "val",
                        "email": "val",
                        "workstart": "val",
                        "workend": "val",
                        "dispetcher": "val",
                        "responsible": "val",
                        "closed_at": "val",
                        "file": "val"
                    }]
                }]
            }
        }]
    }
}

I'll try to save it to db with using use Illuminate\Http\Request(Request $request), but can't given access to array org1 and ticket.
Misstake:

Undefined array key &quot;org1&quot;

Which way to move? Thnx

David · Accepted Answer · 2021-07-13 08:54:29Z

1

Change the json into an array:

$json_array = json_decode($your_json, true);

Access the element you want:

$org1 = $json_array['data']['orgs']['org1'];

And if you want to convert to json:

$org1 = json_encode($org1);

answered Jul 13, 2021 at 8:54

David

1446 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

Evgeniy Over a year ago

Thnx, 4 answer, but using your way i'll have mistake: ErrorException: Trying to access array offset on value of type null

David Over a year ago

Just tried, it works well on my side. Share your code please

David Over a year ago

Maybe you should implement some validation in your controller. It seems the array does not exist

Evgeniy Over a year ago

json in topick start, and function to try output: look like yor example^

Evgeniy Over a year ago

public function test(Request $request) { $json_array = json_decode($request->data, true); $org1 = $json_array['data']['orgs']['org1']; dd ($org1); }

|

Evgeniy · Accepted Answer · 2021-07-13 09:45:26Z

dd() output:

array:1 [
  0 => array:1 [
    "orgs" => array:1 [
      0 => array:1 [
        "org1" => array:1 [
          0 => array:2 [
            "attribute" => array:1 [
              0 => array:3 [
                "name" => "Из json"
                "inn" => "88888111"
                "kpp" => "11188888"
              ]
            ]
            "tickets" => array:1 [
              0 => array:1 [
                "ticket1" => array:1 [
                  0 => array:14 [
                    "account_uid" => "UKP2010001002"
                    "created_at" => "2021-13-07"
                    "title" => "Из json"
                    "text" => "Из json"
                    "status" => "1"
                    "priority" => "2"
                    "fullname" => "Вася Джейсонович"
                    "workaddr" => "дом улица фонарь"
                    "phone" => "+791478562548"
                    "email" => "[email protected]"
                    "workstart" => "вечером"
                    "workend" => "утром"
                    "dispetcher" => "Матрёна Петровна"
                    "responsible" => "Гайдай Пётр"
                  ]
                ]
              ]
            ]
          ]
        ]
      ]
    ]
  ]
]

Collectives™ on Stack Overflow

How to save JSON in DB - laravel 8

2 Answers 2

10 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related