纪小年 - 第 23 页

2008/09/05

简单5步，制作wordpress留言板

做一个wordpress留言板很简单，我们知道一般可以用新建一个主题名字叫“留言板”的页面，让访客以评论留言的方式来实现。但是这种方式建立的留言板，其实是一个一般主题(post)或页面(page)，因此缺乏进一步定制的功能，而且提示文字也全部是“评论” 要...

1

WordPress

2008/08/06

汇编大量WordPress代码

显示最新文章

<ol class="dp-c">
<li class="alt"><span><span>&lt;?php query_posts(</span><span class="string">’showposts=5′</span><span>); ?&gt; </span></span></li>
	<li><span>&lt;ul&gt; </span></li>
<li class="alt"><span>&lt;?php <span class="keyword">while</span><span> (have_posts()) : the_post(); ?&gt; </span></span></li>
	<li><span>&lt;li&gt;&lt;a href=<span class="string">"&lt;?php the_permalink() ?&gt;"</span><span>&gt;&lt;?php the_title(); ?&gt;&lt;/a&gt;&lt;/li&gt; </span></span></li>
<li class="alt"><span>&lt;?php <span class="keyword">endwhile</span><span>;?&gt; </span></span></li>
	<li><span>&lt;/ul&gt; </span></li>
</ol>

1

2

3

4

5

6

7

8

</ol>

显示最新评论

<ol class="dp-c">
<li class="alt"><span><span>&lt;?php </span></span></li>
	<li><span><span class="keyword">global</span><span> </span><span class="vars">$wpdb</span><span>; </span></span></li>
<li class="alt"><span><span class="vars">$sql</span><span> = "SELECT DISTINCT ID, post_title, post_password, comment_ID, </span></span></li>
	<li><span>comment_post_ID, comment_author, comment_date_gmt, comment_approved, </span></li>
<li class="alt"><span>comment_type,comment_author_url, </span></li>
	<li><span>SUBSTRING(comment_content,1,30) AS com_excerpt </span></li>
<li class="alt"><span>FROM <span class="vars">$wpdb</span><span>-&gt;comments </span></span></li>
	<li><span>LEFT OUTER JOIN <span class="vars">$wpdb</span><span>-&gt;posts ON (</span><span class="vars">$wpdb</span><span>-&gt;comments.comment_post_ID = </span></span></li>
<li class="alt"><span><span class="vars">$wpdb</span><span>-&gt;posts.ID) </span></span></li>
	<li><span>WHERE comment_approved = <span class="string">‘1′</span><span> AND comment_type = </span><span class="string">”</span><span> AND </span></span></li>
<li class="alt"><span>post_password = <span class="string">”</span><span> </span></span></li>
	<li><span>ORDER BY comment_date_gmt DESC </span></li>
<li class="alt"><span>LIMIT 10"; </span></li>
	<li><span><span class="vars">$comments</span><span> = </span><span class="vars">$wpdb</span><span>-&gt;get_results(</span><span class="vars">$sql</span><span>); </span></span></li>
<li class="alt"><span><span class="vars">$output</span><span> = </span><span class="vars">$pre_HTML</span><span>; </span></span></li>
	<li><span><span class="vars">$output</span><span> .= </span><span class="string">"n&lt;ul&gt;"</span><span>; </span></span></li>
<li class="alt"><span><span class="keyword">foreach</span><span> (</span><span class="vars">$comments</span><span> </span><span class="keyword">as</span><span> </span><span class="vars">$comment</span><span>) { </span></span></li>
	<li><span><span class="vars">$output</span><span> .= </span><span class="string">"n&lt;li&gt;"</span><span>.</span><span class="func">strip_tags</span><span>(</span><span class="vars">$comment</span><span>-&gt;comment_author) </span></span></li>
<li class="alt"><span>.<span class="string">":"</span><span> . </span><span class="string">"&lt;a href=""</span><span> . get_permalink(</span><span class="vars">$comment</span><span>-&gt;ID) . </span></span></li>
	<li><span><span class="string">"#comment-"</span><span> . </span><span class="vars">$comment</span><span>-&gt;comment_ID . </span><span class="string">"" title="on "</span><span> . </span></span></li>
<li class="alt"><span><span class="vars">$comment</span><span>-&gt;post_title . </span><span class="string">""&gt;"</span><span> . </span><span class="func">strip_tags</span><span>(</span><span class="vars">$comment</span><span>-&gt;com_excerpt) </span></span></li>
	<li><span>.<span class="string">"&lt;/a&gt;&lt;/li&gt;"</span><span>; </span></span></li>
<li class="alt"><span>} </span></li>
	<li><span><span class="vars">$output</span><span> .= </span><span class="string">"n&lt;/ul&gt;"</span><span>; </span></span></li>
<li class="alt"><span><span class="vars">$output</span><span> .= </span><span class="vars">$post_HTML</span><span>; </span></span></li>
	<li><span><span class="func">echo</span><span> </span><span class="vars">$output</span><span>;?&gt; </span></span></li>
</ol>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

<li>global $wpdb; </li>

<li class="alt">$sql = "SELECT DISTINCT ID, post_title, post_password, comment_ID, </li>

<li>comment_post_ID, comment_author, comment_date_gmt, comment_approved, </li>

<li class="alt">comment_type,comment_author_url, </li>

<li>SUBSTRING(comment_content,1,30) AS com_excerpt </li>

<li class="alt">FROM $wpdb->comments </li>

<li>LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID = </li>

<li class="alt">$wpdb->posts.ID) </li>

<li>WHERE comment_approved = ‘1′ AND comment_type = ” AND </li>

<li class="alt">post_password = ” </li>

<li>ORDER BY comment_date_gmt DESC </li>

<li class="alt">LIMIT 10"; </li>

<li>$comments = $wpdb->get_results($sql); </li>

<li class="alt">$output = $pre_HTML; </li>

<li>$output .= "n<ul>"; </li>

<li class="alt">foreach ($comments as $comment) { </li>

<li>$output .= "n<li>".strip_tags($comment->comment_author) </li>

<li>"#comment-" . $comment->comment_ID . "" title="on " . </li>

<li class="alt">$comment->post_title . "">" . strip_tags($comment->com_excerpt) </li>

<li>$output .= "n</ul>"; </li>

<li class="alt">$output .= $post_HTML; </li>

<li>echo $output;?> </li>

</ol>

显示热评文章

<ol class="dp-c">
<li class="alt"><span><span>&lt;?php </span><span class="vars">$result</span><span> = </span><span class="vars">$wpdb</span><span>-&gt;get_results(</span><span class="string">"SELECT comment_count,ID,post_title FROM $wpdb-&gt;posts ORDER BY comment_count DESC LIMIT 0 , 10"</span><span>); </span></span></li>
	<li><span><span class="keyword">foreach</span><span> (</span><span class="vars">$result</span><span> </span><span class="keyword">as</span><span> </span><span class="vars">$topten</span><span>) { </span></span></li>
<li class="alt"><span><span class="vars">$postid</span><span> = </span><span class="vars">$topten</span><span>-&gt;ID; </span></span></li>
	<li><span><span class="vars">$title</span><span> = </span><span class="vars">$topten</span><span>-&gt;post_title; </span></span></li>
<li class="alt"><span><span class="vars">$commentcount</span><span> = </span><span class="vars">$topten</span><span>-&gt;comment_count; </span></span></li>
	<li><span><span class="keyword">if</span><span> (</span><span class="vars">$commentcount</span><span> != 0) { ?&gt; </span></span></li>
<li class="alt"><span>&lt;li&gt;&lt;a href=<span class="string">"&lt;?php echo get_permalink($postid); ?&gt;"</span><span> </span></span><span><span>title=</span><span class="string">"&lt;?php echo $title ?&gt;"</span><span>&gt;&lt;?php </span><span class="func">echo</span><span> </span><span class="vars">$title</span><span> ?&gt;&lt;/a&gt;&lt;/li&gt; </span></span></li>
	<li><span>&lt;?php } } ?&gt; </span></li>
</ol>

1

2

3

4

5

6

7

8

9

10

<li class="alt"><?php $result = $wpdb->get_results("SELECT comment_count,ID,post_title FROM $wpdb->posts ORDER BY comment_count DESC LIMIT 0 , 10"); </li>