How to store multidimensional array in database?

[rahulephp]

Hi there,

 

can you please help me?

 

i have data in array and i want to insert it in a single table.

structure of table and array to be store is shown below:

 

Please let me know how to store this array in database?

 

Database Structure:

 

array-structure

 

database-Browse

 

Let me know any solution for this?

Thanks in anticipation

[glenelkins]

hi

 

change all fields to allow text characters and serailize the array:

 

$array = array ( 
    'temp_property_name' => array (
                                                 0=>'x',
                                                 1=>'y'
                                               )
                        );


$temp_property_name = serialize ( $array['temp_property_name'] );

 

 

[rahulephp]

Hey thanks for your quick reply.

Will do that and get back to you soon.