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
- ModThemessave 15% off your purchase […]
- Zidalgo Themessave 20% on your order […]
- WooThemessave 20% on your purchase […]
- Autobloggedsave $40 on multi-site licence […]
- Kreative Themessave 50% on your purchase […]
- Smarter Themesave $5 on your order […]
- Classipress Themesave 20% on your purchase […]
- ReviewAZONsave $15 on your order […]
- Headway Themeget 20% off your licence […]
- Gorilla Themesget 10%off any theme […]
On Twitter : I should write a new tutorial "How to type and work with a cat on your knees"
Theme & content : Copyright © 2008 - 2010 Jean-Baptiste Jung. Graphic art by GreenBubbles.org.ua, all right reserved.
9 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?
Trackbacks: