how to pass an array to mysql stored procedure

[shaddf]

i have this array:

test={'dog','cow','shee'};

 

how can I pass it to a stored procedure:

call sp_array(in i_arr1 text);

what data type should I use?

Iam currently looping through and multi executing the procedure in php to pass the values one by one .But is there a way to pass it to the procedure and then assign it to a cursor in sql.

[Destramic]

do you mean cache?

 

any you array should be:

$test = array(
    'dog', 
    'cow', 
    'shee'
);

or are you using a template engine like smarty or some other nonsense?

[QuickOldCar]

You can use list() or implode() them and comma separated

 

If happened to pass them through a loop can also build a string using concatenating assignment operator .=

[shaddf]

You can use list() or implode() them and comma separated

 

If happened to pass them through a loop can also build a string using concatenating assignment operator .=

 Sorry but ,i may have an array containing a sentences like "this is your day.Go for it","You are  doing it well","Keep it up!".how caan I pass that array to a stored procedure.so that I can assign it to a cursor in the procedure

[QuickOldCar]

Arrays in stored procedures are not supported and can get messy.

 

What you should do is normalization in a relational database instead.

Splitting your data first and importing it into a database the way you intend to use it.

 

Split the array prior and insert each as it's own id while associating it to whatever user/group/values id another table you intend on keeping it associated to.

 

If insist on doing it as trying to save arrays, you have to come up with your own method that can work for you.

Usually can pass a comma delimited string or split the data a delimiter would possibly never use such as a double pipe ||

Pass the string and store as VARCHAR(255) to the stored procedure.

Inside the procedure you can split the string back into its elements.

 

Can also look into serialize and unserialize

[shaddf]

Arrays in stored procedures are not supported and can get messy.

 

What you should do is normalization in a relational database instead.

Splitting your data first and importing it into a database the way you intend to use it.

 

Split the array prior and insert each as it's own id while associating it to whatever user/group/values id another table you intend on keeping it associated to.

 

If insist on doing it as trying to save arrays, you have to come up with your own method that can work for you.

Usually can pass a comma delimited string or split the data a delimiter would possibly never use such as a double pipe ||

Pass the string and store as VARCHAR(255) to the stored procedure.

Inside the procedure you can split the string back into its elements.

 

Can also look into serialize and unserialize

Thanks for the double pipe idea.how can i split the string back and assign it to a cursor in the stored procedure.

[QuickOldCar]

using explode() will explode the string back into an array at whatever delimeter use

 

$array = explode("||",$data);

[Barand]

You might have to write the array contents to separate rows in a temporary table

[shaddf]

do you mean cache?

 

any you array should be:

$test = array(
    'dog', 
    'cow', 
    'shee'
);

or are you using a template engine like smarty or some other nonsense?

No ido not mean cache.what I want is to pass a php array variable to a mysql stored procedure from php

[shaddf]

using explode() will explode the string back into an array at whatever delimeter use

 

$array = explode("||",$data);

Is the explode() available in mysql.