Solved

Automate Wordpress Entry from Database

Posted on 2009-04-02
1
451 Views
Last Modified: 2012-05-06
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.
0
Comment
Question by:netvirtue
1 Comment
 
LVL 3

Accepted Solution

by:
Denisvt earned 500 total points
ID: 24110506
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

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
So you have coded your own WordPress plugin and now you want to allow users to upload images to a folder in the plugin folder rather than the default media location? Follow along and this article will show you how to do just that!
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question