WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Getting Post Meta Data on a Custom Query Across All Blogs (13 posts)

  1. northpen
    Member
    Posted 4 years ago #

    I am querying all my posts across all my blogs (works) and filtering them by events (works). Now I am trying to show the associated meta data which each post but it's not working. I'm guessing that this might have something to do with the fact I am querying across all blogs.

    Can anyone help?

    This is the line that is not echoing anything
    <?php echo get_post_meta($postdetail->ID, "_EventStartDate", $single = true); ?>

    <?php
        $blog_list = get_blog_list( 0, 'all' );
        foreach ($blog_list AS $blog){
          $domain = $wpdb->get_var( "SELECT domain FROM {$wpdb->blogs} WHERE blog_id=".$blog['blog_id']);
          $posts = $wpdb->get_col( "SELECT ID FROM wp_".$blog['blog_id']."_posts WHERE post_type = 'sp_events'");
          foreach($posts as $p)
          {
            $postdetail=get_blog_post($blog['blog_id'],$p);
          ?>
          <a href="<?php echo $postdetail->guid;?>"><?php echo $postdetail->post_title;?></a>;
          <?php echo $postdetail->ID ?>
          <?php echo get_post_meta($postdetail->ID, "_EventStartDate", $single = true); ?> <?php // This Line Echos Nothing ?>
    
        <br />
      <?php }} ?>
  2. James Collins
    Member
    Posted 4 years ago #

  3. northpen
    Member
    Posted 4 years ago #

    Hey James,

    If I do that method, can I still list all my posts sorted by "Event Date" (meta key)?

    I guess it could work if I used that method, put each post into an array and then displayed the whole list. Think that would work?

  4. James Collins
    Member
    Posted 4 years ago #

    Yeh that's how I would do it.

    1. Get the list of blogs.
    2. Loop over each blog, switch to it, get the post(s) from that blog. Add the post(s) to an array.
    3. When finished looping over all blogs, sort the array however you like.
    4. Then loop over the sorted array and echo your content.
    5. Then restore to the original blog.

  5. northpen
    Member
    Posted 4 years ago #

    Ah perfect. Cheers man!

  6. greene.md
    Member
    Posted 4 years ago #

    I am very interested in the code you generate to get this to work. Would you be kind enough to post it?

  7. this is a good method for a small number of blogs, or if you were getting specific ones, but for a large number, I would do something else as switch_to_blog get pretty expensive.

  8. northpen
    Member
    Posted 4 years ago #

    Greene.md - The following below is what I have so far. I have it displaying all my posts but I haven't gotten to the point of being able to sort everything by my event date.

    If anyone knows how to do that, I'd appreciate it.

    Code so far:

    <?php
        $postArray = array();
        $blog_list = get_blog_list( 0, 'all' );
        foreach ($blog_list AS $blog){
          switch_to_blog($blog['blog_id']);
          $posts = $wpdb->get_col( "SELECT ID FROM wp_".$blog['blog_id']."_posts WHERE post_type = 'sp_events'");
          foreach($posts as $post){
            $postdetail=get_blog_post($blog['blog_id'],$post);
            setup_postdata($postdetail);
            $postIndex = array(
              'title'       =>  $postdetail->post_title,
              'content'     =>  $postdetail->post_content,
              'start_date'  =>  get_post_meta($postdetail->ID, "_EventStartDate", $single = true)
            );
            array_push($postArray, $postIndex);
            $display--;
          }
        }
      ?>
    
      <?php
        $mylist = array();
        foreach($postArray as $key => $value) {
          print "$key: $value<br>";
          foreach($postArray[$key] as $K => $v){
            print "$k: $v<br>";
          }
        }
      ?>

    It outputs something like the following, which is close. Now I just gotta get it sorting correctly

    0: Array
    : Singles Event
    : Awesome
    : 2010-07-15 00:00:00
    1: Array
    : Auto Draft
    :
    :
    2: Array
    : Concert of Test
    : Concert of Test event goes here!
    : 2010-07-08 00:00:00
    3: Array
    : TEST EVENT
    :
    : 2010-09-13 00:00:00
    4: Array
    : Testing Event System
    : This is where the event system goes
    : 2010-08-05 00:00:00
  9. northpen
    Member
    Posted 4 years ago #

    Ahhhh! Got it working!

    Changed my date to be first in the array and added a simple sort method. I hope this helps someone. I'll write up a detailed blog post on it later on if it will help anyone.

    <?php
        $postArray = array();
        $blog_list = get_blog_list( 0, 'all' );
        foreach ($blog_list AS $blog){
          switch_to_blog($blog['blog_id']);
          $posts = $wpdb->get_col( "SELECT ID FROM wp_".$blog['blog_id']."_posts WHERE post_type = 'sp_events'");
          foreach($posts as $post){
            $postdetail=get_blog_post($blog['blog_id'],$post);
            setup_postdata($postdetail);
            $postIndex = array(
              'start_date'  =>  get_post_meta($postdetail->ID, "_EventStartDate", $single = true),
              'title'       =>  $postdetail->post_title,
              'content'     =>  $postdetail->post_content
    
            );
            array_push($postArray, $postIndex);
            $display--;
          }
        }
      ?>
    
      <?php asort($postArray); ?>
    
      <?php
        foreach($postArray as $key => $value) {
          print "$key: $value<br>";
          foreach($postArray[$key] as $K => $v){
            print "$k: $v<br>";
          }
        }
      ?>
  10. James Collins
    Member
    Posted 4 years ago #

    As Andrea suggested, performance of this could potentially be an issue.

    Perhaps you could store this array in a transient that expires every 24 hours or so? That would effectively mean that the loop and switch_to_blog() calls would only have to be called once per day.

    Another option could be to hook into the save_post hook (http://codex.wordpress.org/Plugin_API/Action_Reference#Post.2C_Page.2C_Attachment.2C_and_Category_Actions), and construct/add to this array each time a post is published with the '_EventStartDate' postmeta value. You would probably store the array in wp_sitemeta.

  11. northpen
    Member
    Posted 4 years ago #

    Hey James,

    That's an interesting idea. I'll keep that in mind when I do some benchmarking.

    Right now I am planning on doing a cache of that page probably once per day. I'll see how that works out

  12. jbroglie
    Member
    Posted 4 years ago #

    Thanks northpen and all contributors for writing on this topic! I have the spent the past few days trying to figure out how to do a multisite query.

    Northpen, I was using the last bit of code you sent and I think I found an error: when the blog_id == 1 (for the main blog) you are using the query:

    SELECT ID FROM wp_1_posts

    when I think it should be

    SELECT ID FROM wp_posts

    I fixed this just with an if statement. I also took out the $display-- because I wasn't sure what it was doing.

    global $wpdb;
    				global $post;
    				$postArray = array();
    				$blog_list = get_blog_list( 0, 'all' );
    
    				foreach ($blog_list AS $blog){
    				  switch_to_blog($blog['blog_id']);
    				  $posts = $wpdb->get_col( "SELECT ID FROM wp_".$blog['blog_id']."_posts WHERE post_status = 'publish' AND post_type = 'post'");
    				  if ($blog['blog_id'] == 1)
    					$posts = $wpdb->get_col( "SELECT ID FROM wp_posts WHERE post_status = 'publish' AND post_type = 'post'");
    				  foreach($posts as $post){
    					$postdetail=get_blog_post($blog['blog_id'],$post);
    					setup_postdata($postdetail);
    					$postIndex = array(
    					  'start_date'  =>  get_post_meta($postdetail->ID, "_EventStartDate", $single = true),
    					  'title'       =>  $postdetail->post_title,
    					  'content'     =>  $postdetail->post_content
    
    					);
    					array_push($postArray, $postIndex);
    				  }
    				}
    
    				asort($postArray);
    
    				foreach($postArray as $key => $value) {
    				  print "$key: $value<br>";
    				  foreach($postArray[$key] as $K => $v){
    					print "$k: $v<br>";
    				  }
    				}
  13. jbroglie
    Member
    Posted 4 years ago #

    On another note, I used code from the Diamond Multisite Widget to get a global display of posts. Does anyone know if querying this way, with a bunch of UNIONs, is more efficient?

    global $wpdb;
    				global $blog_id;
    				$table_prefix = $wpdb->base_prefix;
    
    				$sqlstr = '';
    				$blog_list = get_blog_list( 0, 'all' );
    
    				$sqlstr = "SELECT * from ".$table_prefix ."posts where post_status = 'publish' and post_type = 'post' ";
    
    				$uni = '';
    				foreach ($blog_list AS $blog) {
    					if ($blog['blog_id'] != 1) {
    						if ($sqlstr != '')
    							$uni = ' union ';;
    						$sqlstr .= $uni . " SELECT * from ".$table_prefix .$blog['blog_id']."_posts  where post_status = 'publish' and post_type = 'post' ";
    					}
    				}
    
    				$limit = '';//' LIMIT 0, 5';
    				$sqlstr .= " ORDER BY post_date_gmt desc " . $limit;		
    
    				$post_list = $wpdb->get_results($sqlstr);
    				echo $wpdb->print_error();
    				print_r($post_list);

    Also, does anyone know why this query doesn't include the blog_id column in the recordset that it returns? I can't figure it out...you would think that SELECT * would give you all the columns.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.