pass json to mysql as parameter to stored procedure

[David McKinney]

Hi, I'm just discovering this environment, but have a background in db development. I'm playing around with json, php, mysql. In my PHP I retrieve some json from a URL.

$json=file_get_contents($url);
$coins=json_decode($json,true);

On the mysql side, I have a stored procedure which takes a parameter of type json.

I would like to call that stored procedure using mysqli, and pass my json object as a parameter to the stored procedure (ideally without converting to a string.) Can this be done? And if so, can you tell me how to proceed?

Many thanks,

David McKinney.