vendredi 11 octobre 2019

Unable to display all data from mysql son column

I am retrieving a single row of data from several joined tabled using first(), this includes a json column called properties. I am able to display all the non json data as expected in my blade template.

However for the json column called properties I am pulling my hair out, spend endless hours googling, looking on her but to no avail.

Appreciate if someone could point out the blindingly obvious (as I'm sure it will be)

I have tried also and reached a point where I can access anything in the root of the object but nothing that is nested.

So pretty version of dd($quote->properties) returns;

"{
  "mode": 1,
  "service": 1,
  "rates": {
    "DAP": 825.22
  },
  "detail": {
    "weights": {
      "actual": 111.00,
      "volume": 0,
      "chargeable": 111.00
    }
  }
}"

I Appreciate the leading and training " are only added to render in the browser and don't exist in the actual column.

Using

Result = 1 which is as desired output.

However

Result = Undefined index: DDU

Desired = 825.22



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire