?
Solved

Automate Wordpress Entry from Database

Posted on 2009-04-02
1
Medium Priority
?
462 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 3

Accepted Solution

by:
Denisvt earned 1500 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

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

718 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