Reply To: How to extract the serialized array

• Anderson

• January 13, 2016 at 7:24 am

Thanks for reply @hube2

No, I’m using select manual because I’m not inside of wordpress so you can use get_post_meta()

Something like this

//conection... bla bla bla or
global $wpdb;

$single ="SELECT DISTINCT
ID AS id,
post_title AS title,
(SELECT meta_value FROM ".$wpdb->posts." WHERE post_id = ID AND meta_key = 'images') AS images
FROM
".$wpdb->posts."
WHERE
post_status = 'publish' AND
post_type = 'property'
";

foreach($wpdb->get_results($single, OBJECT) as $rss) {

  echo $rss->images; // is array serealized, how extract?

}

I wanted to pull all the images from the Gallery, could be perfectly for full url, Yes