MySQL Forums
Forum List  »  PHP

pass json to mysql as parameter to stored procedure
Posted by: David McKinney
Date: April 04, 2019 02:59AM

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.


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.

Options: ReplyQuote

Written By
pass json to mysql as parameter to stored procedure
April 04, 2019 02:59AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.