wordpress文章按两个自定义字段组合排序

wordpress在默认情况下可以使用文章的一个自定义字段进行排序,代码如下:

<span class="pln">$args </span><span class="pun">=</span><span class="pln"> array</span><span class="pun">(</span> <span class="str">'meta_key'</span> <span class="pun">=></span> <span class="str">'sort'</span><span class="pun">,</span> <span class="str">'orderby'</span> <span class="pun">=></span> <span class="str">'meta_value_num'</span><span class="pun">,</span> <span class="com">// 须 WordPress 2.8 及以上版本</span> <span class="str">'order'</span> <span class="pun">=></span><span class="pln"> DESC  </span><span class="pun">);</span><span class="pln">  $arms </span><span class="pun">=</span><span class="pln"> array_merge</span><span class="pun">(</span><span class="pln">$args</span><span class="pun">,</span><span class="pln"> $wp_query</span><span class="pun">-></span><span class="pln">query</span><span class="pun">);</span><span class="pln">    query_posts</span><span class="pun">(</span><span class="pln">$arms</span><span class="pun">);</span> <span class="kwd">while</span> <span class="pun">(</span><span class="pln">have_posts</span><span class="pun">())</span> <span class="com">//循环内容</span><span class="pln">  endwhile</span><span class="pun">;</span><span class="pln">wp_reset_query</span><span class="pun">();</span>

$args = array( 'meta_key' => 'sort', 'orderby' => 'meta_value_num', // 须 WordPress 2.8 及以上版本 'order' => DESC ); $arms = array_merge($args, $wp_query->query); query_posts($arms); while (have_posts()) //循环内容 endwhile;wp_reset_query();

但是有时候我们可能会碰到更加复杂的情况，需要对两个自定义字段进行组合排序，方法如下：

<span class="pln">$query </span><span class="pun">=</span> <span class="str">"SELECT wposts.*, wpostmeta1.*, wpostmeta2.*   FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta1, $wpdb->postmeta wpostmeta2  WHERE wposts.ID = wpostmeta1.post_id  AND wposts.ID = wpostmeta2.post_id  AND wpostmeta1.meta_key = 'date'  AND wpostmeta2.meta_key = 'time'  ORDER BY wpostmeta1.meta_value ASC,           wpostmeta2.meta_value ASC"</span><span class="pun">;</span><span class="pln">    $results </span><span class="pun">=</span><span class="pln"> $wpdb</span><span class="pun">-></span><span class="pln">get_results</span><span class="pun">(</span><span class="pln">$query</span><span class="pun">);</span> <span class="kwd">foreach</span> <span class="pun">(</span><span class="pln"> $results </span><span class="kwd">as</span><span class="pln"> $result </span><span class="pun">)</span> <span class="pun">{</span> <span class="com">//循环内容</span> <span class="pun">}</span>

$query = "SELECT wposts.*, wpostmeta1.*, wpostmeta2.* FROM $wpdb->posts wposts, $wpdb->postmeta wpostmeta1, $wpdb->postmeta wpostmeta2 WHERE wposts.ID = wpostmeta1.post_id AND wposts.ID = wpostmeta2.post_id AND wpostmeta1.meta_key = 'date' AND wpostmeta2.meta_key = 'time' ORDER BY wpostmeta1.meta_value ASC, wpostmeta2.meta_value ASC"; $results = $wpdb->get_results($query); foreach ( $results as $result ) { //循环内容 }

wordpress文章按两个自定义字段组合排序

相关推荐：

最近更新