Skip to content

Instantly share code, notes, and snippets.

View Mehraban's full-sized avatar

Mehr@ban Mehraban

  • Islamic Republic of IRAN
View GitHub Profile
@Mehraban
Mehraban / sample code WP comments
Last active January 19, 2017 07:26
The second sample code in WordPress comments
<div id="comments">
<ul class="commentlist">
<?php
$all_comments=get_comments( array('status' => 'approve','orderby'=>'comment_date', 'number'=>'100') );
foreach ($all_comments as $cmt) {
mytheme_comment($cmt,array(
'type'=>'comment','avatar_size'=>'64'
));
}
?>
@Mehraban
Mehraban / sample code WP comments
Last active January 19, 2017 07:15
The first sample code in WordPress comments
<?php
function src_simple_recent_comments($src_count=7, $src_length=60, $pre_HTML='<li><h2> تازه‌ترین دیدگاه‌ها </h2>', $post_HTML='</li>') {
global $wpdb;
$sql = "SELECT DISTINCT ID, post_title, post_password, comment_ID, comment_post_ID, comment_author, comment_date_gmt, comment_approved, comment_type,
SUBSTRING(comment_content,1,$src_length) AS com_excerpt
FROM $wpdb->comments
LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID = $wpdb->posts.ID)
WHERE comment_approved = '1' AND comment_type = '' AND post_password = ''
ORDER BY comment_date_gmt DESC
LIMIT $src_count";