Retrieve wordpress recent posts from external website

GimmeDat · #1 (**permalink**) 09-01-2008, 11:41 PM

Hello All, just looking for recommendations on which is the best way to parse the recent posts of a wordpress blog onto another non blog website?

blacknight · #2 (**permalink**) 09-01-2008, 11:44 PM

Simplest solution would be to use RSS.

There's plenty of ways of doing it. If you're lazy you could use feedburner, like I'm doing on Michele J. Neylon :: Web ramblings and more..

OR you could use one of the many RSS libraries like Carp etc., etc.

Up to you really

Of course if you were using MovableType you could simply use a widget

Forbairt · #3 (**permalink**) 10-01-2008, 01:26 AM

this question was asked here as well (well how to setup an rss feed)

http://www.irishwebmasterforum.com/c...rss-feeds.html

I did my best to answer ... solution given was using magpie

GimmeDat · #4 (**permalink**) 10-01-2008, 10:10 PM

Thanks for suggestions, i tried this one

Cut n' Paste JavaScript RSS Feed

I like it as there is no branding.

louie · #5 (**permalink**) 10-01-2008, 10:28 PM

if you own the blog you can just setup a db connection and pull the latest #? post from it.

GimmeDat · #6 (**permalink**) 10-01-2008, 10:32 PM

Yes i own the blog. Would that involve much work?

Forbairt · #7 (**permalink**) 10-01-2008, 10:43 PM

if you just want to pull the posts ... and so on ...

about 15 minutes to half an hour

to actually write the bit of code probably a minute ... to format it nicely and so on ... probably the rest of the time ...

GimmeDat · #8 (**permalink**) 10-01-2008, 11:22 PM

Thanks a mill. I'll give it a go.

louie · #9 (**permalink**) 10-01-2008, 11:50 PM

there is something I use myself

PHP Code:

  $show_blog = true;
if($show_blog){
//replace HOST, USER, PASS, DB_NAME with your DB details
$limit = 10;
 $con = mysql_connect(HOST,USER,PASS);
 if (!$con){ die('Could not connect: '); }
 // make foo the current db
 $db_selected = mysql_select_db('DB_NAME', $con);
 if (!$db_selected) {
  die ('Can\'t use db : ');
 }
 echo "<div class='left_tab'>Recent Posts...</div>
  <div class='left_menu'>
  <ul>";
 $sSql = "SELECT `ID`,`post_title`, `wp_posts`.`guid` FROM `wp_posts` WHERE `wp_posts`.`post_status` =  'publish' 
 AND `wp_posts`.`post_type` =  'post' ORDER BY `wp_posts`.`post_date` DESC LIMIT 0, $limit"; 
 $rs_blog = mysql_query($sSql,$con) or die("no connection");
 while($row_blog = mysql_fetch_array($rs_blog)){
  echo "<li><a href='".$row_blog['guid']."' title='".
  htmlspecialchars(str_replace("'"," ",$row_blog['post_title']))."' target='_blank'>&bull; ".htmlspecialchars($row_blog['post_title'])."</a></li>"; 
 }
 mysql_free_result($rs_blog); 
 echo "</ul>
 </div>";
 mysql_close($con);
}

Forbairt · #10 (**permalink**) 11-01-2008, 12:21 AM

Quote:

Originally Posted by GimmeDat

Thanks a mill. I'll give it a go.

Or give it a louie post .. so to speak

might end up re-using myself .. save me half an hour of work

cheers louie

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Most recent posts plugin?	blacknight	Forum Management	7	13-03-2007 03:10 AM
Need WordPress Plugin For Adding Images To Posts	Gavin	Blogs & Blogging	3	04-11-2006 02:43 PM

Sponsored links

Retrieve wordpress recent posts from external website

Retrieve wordpress recent posts from external website

Similar Threads

Sponsored links