Automate Wordpress Entry from Database

I'm looking for a way to automate a blog entry from an external database.

Whenever a new entry is added to the database, I'd like to create a blog entry.

Does anyone know of a plug-in or PHP script that will do this?  Something where I point to specific tables and columns.  When a new row is added, the data is extracted from the fields and put into the blog.

I'm using MySQL for the Database and PHP.

Thank you.
netvirtueAsked:
Who is Participating?
 
DenisvtConnect With a Mentor Commented:
Using a custom script would be fairly easy for that depending on your PHP level.
You'd run a PHP script as a cronjob that would connect to the remote DB, check which records are new, create posts accordingly, and save a log in order to not create double posts.

WP also has XML (RPC) plugins that you could use the other way round: after whatever you have that adds a record to your remote DB, make it connect to your WP's RPC and create the new blog there.

Another thing that comes to mind is to use WP's post-by-email feature: I guess it'd be pretty easy to send an email on your remote site whenever a new record is added, and that email would be crafted to create a new post by emailing your Wordpress.

Hope that helps !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.