Hi,
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
A:
A generic easy way to export data from a mySQL database in XML format could be phpmyadmin.net
Benjamin Ortuzar
2010-01-13 10:52:38
A:
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.
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.
Pekka
2010-01-13 10:54:17
More like Pages with the HTML formatting. Right now, I'm looking into integrating the wordpress page with my site static page for easier management. Also, this allow the marketing team to change the static content with out assistant from engineering team.
Mickey Cheong
2010-01-13 11:00:39
See my edited answer.
Pekka
2010-01-13 11:04:06
Mickey Cheong
2010-01-13 11:22:47
I'm sure there are already plugins for that, no need to write it yourself. Check the repository: http://wordpress.org/extend/plugins/
Pekka
2010-01-13 11:34:59
Found it :) Is below
Mickey Cheong
2010-01-13 12:19:32
A:
It would be great if wp community had a plug in that exposed the wp content as a restful service. Does something like that exist?
hari
2010-01-13 11:11:55