Solved

Automate Wordpress Entry from Database

Posted on 2009-04-02
1
448 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
Comment Utility
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

In order to have all security and back ups taken care of, WordPress users can sign up for services with WP Engine.
This article discusses how to create an extensible mechanism for linked drop downs.
The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

744 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now