Below will get the All articles from Wordpress Database to an external file and display in random order.Also, it depends on how you customized your “Permalink Structure”. Sample below has “/article/%postname%/%post_id%/”. I am using the same code on my footer!

//////////////////////////////////////////////////////////////////////

$conn = mysql_connect('localhost','root','');
mysql_select_db("keithics",$conn) or die(mysql_error());

if (!$conn) {
die('Error!!--> ' . mysql_error()); // if there's an error, e.g. wrong password or username.
}

$sql = "Select * from `wp_posts` where post_status = 'publish' order by rand() limit 5 ";

$result = mysql_query($sql) or die(mysql_error());

while($row =  mysql_fetch_array($result))
{
echo '<a href="'.$site.'blog/article/'.$row['post_name'].'/'.$row['ID'].'/">'.$row['post_title'].'</a>';
}

Related posts:

1. Get Articles from a specific cagetory in Wordpress After googling and not found any code, I made my...
2. Wordpress get_page() function Well this is the first time that I am having...

Tags: Freelancing, PHP programming, Wordpress

This entry was posted on Tuesday, October 28th, 2008 at 4:38 am and is filed under PHP programming, Tips and Tricks. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.