Do you ever wanted to be able to list your WordPress posts on a non-WordPress website? If yes, just read on, I got the solution to do that!
Do you ever wanted to be able to list your WordPress posts on a non-WordPress website? If yes, just read on, I got the solution to do that!
Let's go: Simply paste the following code on your non WordPress site. You may need to upload the wp-config file from the blog you want to get the posts on the same directory.
<?php
$how_many=1; //how many posts to display
require('blog1/wp-config.php'); //the path to the wp-config file of the blog I want to use
$news=$wpdb->get_results("SELECT 'ID','post_title','post_content' FROM $wpdb->posts
WHERE 'post_type'=\"post\" AND 'post_status'=\"publish\" ORDER BY post_date DESC LIMIT $how_many");
foreach($news as $np){
printf ("<div class='normalText'>%s</div>", $np->post_content);
}?>
That's all. You can also parse rss feeds, but that solution can be simpler.
5 Responses
Very nice, I use simplepie to do this,
i tried this way but couldn’t get the post to show up. using wordpress.2.6.2.
This solution can be simpler if your non-wordpress site hosted in one account with Wordpress blog, or MySQL database allowing remote connections to itself, else this script can`t connect to database with Wordpress posts.
What I’d like to do is list just the first few lines of the latest post on the home page of a non-wordpress site so I can have “Latest from the blog……Blah blah blah blah……Click here to read more”. Etc etc. Any ideas?
Trackbacks: