The Slim Framework support forum has moved to This Tender forum is no longer maintained or monitored.

nested array in json response

John H's Avatar

John H

19 Apr, 2013 07:18 PM

I have a json response that looks like:


As you can see, the fav_things property is a nested array.

Up until now, I have had no problems with single properties updating in my database using Slim. I'm stuck on how to best update this array of properties as ONE into a row on my mysql db.

The error message I receive when Slim tries to accept this response and update the db is:

Type: ErrorException Code: 8
Message: Array to string conversion

How can I instruct Slim or my mysql code to interpret this nested array correctly?

my current code looks like

$sql = "UPDATE users SET
WHERE id=:id

$request = $app->request();
$response = $request->getBody();
$response = json_decode($response);

$STH  = $db->prepare($sql);
$STH->bindParam("name", $response->name);
$STH->bindParam("name", $response->city);
$STH->bindParam("name", $response->fav_things);
$STH->bindParam("name", $response->active);

Can anyone help me figure out how to get this fav_things nested property working?

Thanks! Any help is much appreciated!


Showing page 3 out of 3. View the first page

  1. 61 Posted by mahi on 01 Feb, 2017 10:44 AM

    mahi's Avatar

    awesome applications for absolutely nothing from vShare App If we speak about its attributes then this is an amazing nice.

  2. 62 Posted by liz on 11 Mar, 2017 05:44 AM

    liz's Avatar

    good download and install converted Mp3 sound data. Peggo is a superior YouTube to MP3 songs nice.

  3. 63 Posted by ram on 22 May, 2017 10:04 AM

    ram's Avatar

    The application also makes it simple to obtain metadata information for Movies, filter them as per their dream software application and also is made.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:


Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac