$tags = wp_get_post_tags($post->ID);

if ($tags) {

$first_tag = $tags[0]->term_id;

$args=array(

'tag__in' => array($first_tag),

'post__not_in' => array($post->ID),

'showposts'=>10,

'caller_get_posts'=>1

);

$my_query = new WP_Query($args);

if( $my_query->have_posts() ) {

while ($my_query->have_posts()) : $my_query->the_post(); ?>

realate post';} ?>

3. WordPress主題使用 PHP代碼輸出最新文章

$limit = get_option('posts_per_page');

$paged = (get_query_var('paged')) ? get_query_var('paged') : 1;

query_posts('showposts=' . $limit=7 . '&paged=' . $paged);

$wp_query->is_archive = true; $wp_query->is_home = false;

?>

ID)) : ?>

4. 最新評論：

global $wpdb;

$sql= "SELECT DISTINCT ID, post_title, post_password,

comment_ID,comment_post_ID, comment_author, comment_date_gmt,

comment_approved,comment_type,comment_author_url,

SUBSTRING(comment_content,1,30) AScom_excerpt FROM $wpdb->comments LEFT OUTER

JOIN $wpdb->posts ON($wpdb->comments.comment_post_ID = $wpdb->posts.ID)

WHEREcomment_approved = '1' AND comment_type = " AND post_password = " ORDERBY

comment_date_gmt DESC LIMIT 10";

$comments = $wpdb->get_results($sql);

$output = $pre_HTML;

foreach ($comments as $comment) {

$output.= "n

}

$output .= $post_HTML;

echo $output;

?>

5. wordpress主題–相關(guān)文章代碼

基本sql是這樣：$sql = “SELECT p.ID, p.post_title, p.post_date, p.comment_count,

count(t_r.object_id) as cnt FROM $wpdb->term_taxonomy t_t, $wpdb->term_relationships

t_r, $wpdb->posts p WHERE t_t.taxonomy =’post_tag’ AND t_t.term_taxonomy_id =

t_r.term_taxonomy_id AND t_r.object_id = p.ID AND (t_t.term_id IN ($taglist)) AND

p.ID != $post->ID AND p.post_status = ‘publish’ GROUP BY t_r.object_id ORDER BY cnt

DESC, p.post_date_gmt DESC LIMIT $limit;”;

一點(diǎn)一點(diǎn)的解釋：term_taxonomy 、term_relationship、posts這三張表存的什么我不多說，網(wǎng)上一般都可以查到，維基百科貌似都有。把他們連起來，做個(gè) sql，注意 group by以及l(fā)imit，這樣就可以提取結(jié)果了$related_post = $wpdb->get_results($sql);

之前要把$taglist 做好，利用wp_get_post_tags($post->ID);可以將該篇文章的的 tag 取到一個(gè)數(shù)組中，然后再鏈接就可以了 最后怎么處理輸出就看個(gè)人愛好了，這個(gè)功能我寫的大概也就十幾行，我比較喜歡簡短的說，呵呵。

function related_post($limit = 10) {

global $wpdb, $post;

$tags = wp_get_post_tags($post->ID);

$taglist = "'" . $tags[0]->term_id. “‘”;

$tagcount = count($tags);

if ($tagcount > 1) {

for ($i = 1; $i < $tagcount; $i++) {

$taglist .= “, ‘”.$tags[$i]->term_id.”‘”;

}

}

$sql = “SELECT p.ID, p.post_title, p.post_date, p.comment_count, count(t_r.object_id) as cnt

FROM $wpdb->term_taxonomy t_t, $wpdb->term_relationships t_r, $wpdb->posts p WHERE

t_t.taxonomy =’post_tag’ AND t_t.term_taxonomy_id = t_r.term_taxonomy_id AND t_r.object_id =

p.ID AND (t_t.term_id IN ($taglist)) AND p.ID != $post->ID AND p.post_status = ‘publish’ GROUP

BY t_r.object_id ORDER BY cnt DESC, p.post_date_gmt DESC LIMIT $limit;”;

$related_post = $wpdb->get_results($sql);

$output = “”;

foreach ($related_post as $tmp){

$output .= 這個(gè)就看個(gè)人愛好了

}

if($output == “”)$output = “No Related Post Yet”;

echo $output;

}