Support

Account

Home Forums Add-ons Gallery Field How to extract the serialized array Reply To: How to extract the serialized array

  • 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