<?php
get_month_link( $year, $month );
?>
Category Archives: Wordpress
Wordpress
Archive url from post date – WordPress
<?php
echo get_day_link(2010, 6, 20);
?>
WordPress query to list archives
<?php
$archiveQry= “SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts
FROM $wpdb->posts GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC “;
$archivesData = $wpdb->get_results($archiveQry); foreach($archivesData as $key=>$archive) { ?>
<a href=””><?php echo date(“M”, mktime(0, 0, 0,$archive->month, 1, $archive->year)); ?>
<?php echo $archive->year ?> </a>
<?php } ?>
How to find out the number of posts added to a given category – WordPress
<?php
$posts = get_posts(array('category' => 5)); // Here 5 is category id
echo sizeof($posts);
?>
WordPress function to fetch posts from category id
<?php
$posts = get_posts(array('category' => 5)); // Here 5 is category id
?>
Number of comments of a post from post id – WordPress
<?php $postDetails = get_post($postID); echo $post_id_7->comment_count; ?>
Find out the number of comments of a post – WordPress
<?php comments_popup_link( 'No comments ','1 comment ','% comments ','comments-link ','Comments are off for this post '); ?>
WordPress page permalink from page id
<?php get_permalink($id); ?>
Query to fetch the recent comments – WordPress
<?php
global $wpdb;
$commentQuery = "SELECT * from $wpdb->comments WHERE comment_approved= '1'
ORDER BY comment_date DESC LIMIT 0 ,5";
$comments = $wpdb->get_results($commentQuery);
foreach ($comments as $comment) {
$url = '<a href="'. get_permalink($comment->comment_post_ID).
'#comment-'.$comment->comment_ID .'">';
?>
<li><?php echo $url; ?><?php echo $comment->comment_author; ?> On
<?php echo get_the_title($comment->comment_post_ID); ?></a></li>
<?php } ?>
WordPress function that shows archives
<?php
$args = array(
'type' => 'monthly',
'format' => 'html',
'show_post_count' => false,
'echo' => 1 );
echo wp_get_archives( $args );
?>