What's the best way to pull data from Wordpress database? I think creating a plugin would be nice. Is there a tutorial out there that do the job? Or a plugin that does it? Pull content of开发者_开发问答 the page via JSON/XML.
Cheers, Mickey
Here's the link to the plugin:
http://wordpress.org/extend/plugins/json-api/
A generic easy way to export data from a mySQL database in XML format could be phpmyadmin.net
If you are looking to integrate HTML from Wordpress in a PHP-driven site, the easiest and fastest way is to include the WordPress main include, and use the native WP functions to get hold of the data.
- Wordpress Codex: Integrating Wordpress with your website
- Wordpress Codex: The Loop
Just one caveat from experience: Wordpress is fat. Including the wordpress header file will eat up 8-12 MB of your allocated per-script memory (usually somewhere between 16-64 MB) from the start. You may be able to steer around that, however, by loading the Wordpress data in a different script, or caching the requests (probably a good idea anyway).
WordPress also has basic built-in RSS export functionality.
精彩评论