CODEWITHSUNDEEP
phparrayscodeigniterserialization
Mehd S
Mehd S

Reputation: 583

Unserialize data of database

How can unserialize, data stored in database with serialize?
Please give me example.

$result = array();
foreach ($upload_data as $file) {
  $result[] = $file['file'];
}
$insert_to_database = serialize($result);
//This inserted in database, I want unserialize this output
output: a:2:{i:0;s:55:"Chrysanthemum18.jpg";i:1;s:48:"Desert18.jpg";}

Upvotes: 2

Views: 4435

Answers (2)

toopay
toopay

Reputation: 1635

Suppose you use CI AR to retrieve the serialized data...

$qry = $this->db->select('your_serialized_field')
                 ->from('some_table')
                 ->get();
$serialized_data = $qry->result_array();
$unserialized_data = array();
// Then for every record...
foreach($serialized_data as $single_record)
{
   $unserialized_data[] = unserialize($single_record);
}
// You now can see your array
var_dump($unserialized_data);

Upvotes: 2

Lepidosteus
Lepidosteus

Reputation: 12027

Use unserialize()

$var = array('a', 'b', 'c');
$var = serialize($var);
var_dump($var); // string(42) "a:3:{i:0;s:1:"a";i:1;s:1:"b";i:2;s:1:"c";}"
$var = unserialize($var);
echo $var[0]; // 'a'

Upvotes: 3

Related Questions