<?php
// ‘links’ is the slug name of the link category link
$linkeQry=”SELECT * FROM wp_links as link INNER JOIN wp_term_relationships ON (link.link_id = wp_term_relationships.object_id)
INNER JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) AND wp_term_taxonomy.taxonomy = ‘link_category’
INNER JOIN {$wpdb->prefix}terms as c ON c.term_id=wp_term_taxonomy.term_id
WHERE c.slug=’links'”;
$linksData = $wpdb->get_results($linkeQry);
?>
<ul>
<?php foreach($linksData as $key=>$link) { ?>
<li><a href=”<?php echo $link->link_url; ?>” target=”_blank”><?php echo $link->link_name; ?></a></li>
<?php } ?>
</ul>
<?php
$linkeQry=”SELECT * FROM $wpdb->links”;
$linksData = $wpdb->get_results($linkeQry);
?>
<ul>
<?php foreach($linksData as $key=>$link) { ?>
<li><a href=”<?php echo $link->link_url; ?>” target=”_blank”><?php echo $link->link_name; ?></a></li>
<?php } ?>
</ul>
<?php if (is_user_logged_in()){?>
<li><a href=”<?php bloginfo(‘url’); ?>/wp-admin”>Site Admin</a></li>
<li><a href=”<?php bloginfo(‘url’); ?>/wp-login.php?action=logout&_wpnonce=f17bcd0114″>Log out</a></li>
<?php } else { ?>
<li><a href=”<?php bloginfo(‘url’); ?>/wp-login.php”>Log in</a></li>
<?php }; ?>
<?php
get_year_link( $year );
?>
<?php
get_month_link( $year, $month );
?>
<?php
echo get_day_link(2010, 6, 20);
?>
<?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 } ?>
<?php
date(“M”, mktime(0, 0, 0,MONTH_NUMBER,DATE, YEAR));
eg: echo date(“M”, mktime(0, 0, 0,5,17, 1984)); // May
?>
Zend | Magento Certified PHP | eCommerce Architect
Pramod T P 