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.
If you enjoyed this article, please consider sharing it!
Leave a Comment
- Neatothemesget 20% off every theme […]
- WordPress Defendersave $4 on your purchase […]
- Templaticsave 20% on your purchase […]
- Squeeze Themeget 25% off your order […]
- Canvas ThemeGet 25% off the Canvas theme […]
- WPShiftsave 10% on your order […]
- ModThemessave 15% off your purchase […]
- Zidalgo Themessave 20% on your order […]
- WooThemessave 20% on your purchase […]
- Autobloggedsave $40 on multi-site licence […]
On Twitter : @aditgupta Yes, it is beautiful :) If you travel to Europe make sure to visit Brussels as well!
Theme & content : Copyright © 2008 - 2010 Jean-Baptiste Jung. Graphic art by GreenBubbles.org.ua, all right reserved.
10 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?
Hi,
I use .tpl (template) files for my html and .php files to push the templates. So where would I place the codes you’ve given?
Any way to limit this to pull in one category?
Thanks in advance
Great! The site I would like to use this on currently uses ASP (ugh) but I am planning to switch to PHP at the first of the year. I just might use your script. Definite Bookmark.
I get this error:
Call to undefined method stdClass::set_prefix() in wp-settings.php on line 268
which is $ prefix = $ wpdb->set_prefix( $ table_prefix ) ; I spaced this line out in case it got erased by the comments. Does this mean I can use the tables prefix being used by the other database and it will work? Is it possible to change the wp_ table prefix after installation without messing up the blog?
Hmmmm have tried to get this to work using several different methods but no joy.
My wordpress installation is in a directory called ‘blog’
I am trying to load the latest posts onto my sites homepage (which is not part of the WP install)
However – if I include ANY wordpress files (wp-config, wp-load.php etc) then I just get a blank white screen on my homepage??
Anyone any ideas? I am using WP 2.9.2
Trackbacks: