John Davidson

Message:

So i have this JSON in my MySQL Database

{

    "11011001": {

        "id": 11011001,

        "name": "Test",

        "price": 4,

        "inCart": 7

    }

}

Now i want to work with this data in PHP.
I got the JSON by doing this in PHP:

$sql = "SELECT article FROM test WHERE id = '$id'";

    $result = $conn->query($sql);



    if ($result->num_rows > 0) {

        $row = $result->fetch_assoc();

        $aricle = $row["article"];

    } else {

        echo "Something went wrong";

    }

After that i did this which resulted in getting a JSON Array:

$tarray = json_decode($article, TRUE);

What can i do now to get the values from the JSON?
For example i want the value of the price in a variable called $price.

---

My Answer:
"{"name": "John", "age": 30, "city": "New York"}"