Getting data from WordPress database to use at out of WordPress

Question

I set up WordPress, everything is fine. It is under a sub-directory of main website and it use same database with the custom developed website. The path is like below:

http://www.blabla.com/blog/blabla-category-name/bla-post-title/

I need to list the latest three posts at main website (out of WordPress). I looked WordPress db, but could not see any cat name at table :/ so how can I generate such link to post from out of WordPress?

appreciate helps!!

just found this article online. working great!!

http://www.corvidworks.com/articles/wordpress-content-on-other-pages

Try taking a look at these articles: HOWTO: Display Wordpress posts on other pages or web sites Display Wordpress content from outside of Wordpress — Amber
– Amber, Commented Aug 4, 2009 at 9:56
This should help: codex.wordpress.org/Integrating_Wordpress_with_Your_Website — Mastergalen
– Mastergalen, Commented Aug 29, 2012 at 13:45

Joe Sergeant · Accepted Answer · 2009-08-04 10:03:53Z

1

You could parse the RSS feed that Wordpress generates using something like MagicParser. This would allow you to display the most recent posts on your homepage with relative ease.

The preferred method would be to use one of the methods as described by Dav, though.

answered Aug 4, 2009 at 10:03

Joe Sergeant

1414 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pascal · Accepted Answer · 2014-03-18 13:45:20Z

0

Try this sql

select te.name from wp_posts as p 
left join wp_term_relationships as r on ( p.ID = r.object_id )
left join wp_term_taxonomy as ta on ( r.term_taxonomy_id = ta.term_taxonomy_id )
left join wp_terms as te on ( ta.term_id = te.term_id )
where p.ID = 529
and ta.taxonomy = 'category'

where 529 is the post you want to find the category for.

answered Mar 18, 2014 at 13:45

Pascal

2,4154 gold badges28 silver badges41 bronze badges

Collectives™ on Stack Overflow

Getting data from WordPress database to use at out of WordPress

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related