When working with arrays its necessary to store an array in a MySQL field. Unfortunately, there is no way to directly pass in an array as a parameter..
in this case we have to use the function serialize and unserialize in php
To convert any array (or any object) into a string using PHP, call the serialize function:
$array = array( 1, 2, 3 ); $string = serialize( $array ); echo $string;
this will results in
a:3:{i:0;i:1;i:1;i:2;i:2;i:3;}
to convert back from the string to the array, use unserialize:
// $array will contain ( 1, 2, 3 ) $array = unserialize( $string );
This is how we can store Arrays in Database Php
Leave a Reply