{"id":31,"date":"2005-03-14T20:59:26","date_gmt":"2005-03-15T00:59:26","guid":{"rendered":"http:\/\/hoogervorst.dyndns.org\/~arthur\/wordpress\/?p=31"},"modified":"2005-03-14T21:10:08","modified_gmt":"2005-03-15T01:10:08","slug":"get-the-comments","status":"publish","type":"post","link":"http:\/\/www.hoogervorst.ca\/arthur\/?p=31","title":{"rendered":"Get the comments"},"content":{"rendered":"

O<\/span>K: the first WordPress hack, the last 7 comments on your blog (or whatever number you’d like). I like the way this is on Alan’s page where it’s called ‘Active conversations’<\/a>. On Alan’s page the whole thread is lifted out (which is particularly neat too), in my case I only wanted to see the comments (and their permalinks).\n<\/p>\n

\n

<?php if ( $comments = $wpdb->get_results(“SELECT comment_author, ” .
\n “comment_author_url, comment_ID, comment_post_ID “.
\n “FROM $wpdb->comments WHERE comment_approved = ‘1’ ” .
\n “ORDER BY comment_date_gmt DESC LIMIT 5”) ){
\n?>
\n<li>
\n<h2><?php _e(‘Comments’); ?><\/h2>
\n<ul>
\n<?php foreach ($comments as $comment) {
\n echo ‘<li>’ .
\n sprintf(‘%s on %s’, $comment->comment_author,
\n ‘<a href=”‘. get_permalink($comment->comment_post_ID) .
\n ‘#comment-‘ . $comment->comment_ID . ‘”>’ .
\n get_the_title($comment->comment_post_ID) . ‘<\/a>’);
\n echo ‘<\/li>’; }
\n}
\n?><\/p>\n

<\/ul><\/li><\/p>\n<\/blockquote>\n

Paste the code in your theme’s sidebar.php file (somewhere between line 44 and line 50).\n<\/p>\n

Some observations: First of all, I like to see a date. Maybe I should group the data first and then print (echo) it off. Secondly, look at the get_the_title! It gets an ID as a parameter which means that there’s going to be another query fired off on the server. Not really efficient (note, this code you can also find [minus the small change] in your WordPress dashboard) . Tell the boys that. <\/p>\n

More after.\n<\/p>\n

ed: I went through great lengths getting the code to show up nice. Watch out for extra spaces when you copy the snippet. Also, if you have a spare *nux computer to play with, I highly recommend you to test it on that machine first.<\/small><\/p>\n","protected":false},"excerpt":{"rendered":"

OK: the first WordPress hack, the last 7 comments on your blog (or whatever number you’d like). I like the way this is on Alan’s page where it’s called ‘Active conversations’. On Alan’s page the whole thread is lifted out … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[2,16],"tags":[],"_links":{"self":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts\/31"}],"collection":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=31"}],"version-history":[{"count":0,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=\/wp\/v2\/posts\/31\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=31"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=31"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.hoogervorst.ca\/arthur\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=31"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}