Passing object from PHP to Mysql Stored procedure

Question

Hi All,

Scenario :- I have to call MYSQL stored procedure from PHP and do some operations ( around 15 commands ) on the database

Problem :- I have to call stored procedure with 36 parameters. Lot of parameters . I don't think it is a good idea to pass these many individual parameters and even heard passing individul parameters increases network traffic.

Looking for :- I created a Data Object at PHP side and is there any way I can create similar kind of Object in MYSQL and pass this object as a parameter and extract the data from the object in MYSQL stored procedure

Thanks for your help Regards Kiran

Answer 1

You can't pass objects between different programs. Only variables of scalar type can be passed.
You can use some serialization mechanism to convert your data array into string and back.

The easiest serialization mechanism is split-based, we all used in our first gueastbook script :)
There are also json encoding and PHP serialize() among widely used ones.