Automated Release Of Content

giving it a go :-)

[kamakaze]

I am starting back to college soon and since I won't have lot of time to add/release content for my websites I am working on a automated system built with php/mysql to release content for me in a timely manner that I have created while I have the extra time.

Has anyone every done anything like this before?

My plan:

- Use windows pc that has php and mysql installed to run system

- Run php script (from the command line) that will pull x amount of articles from the local mysql database and insert them into the actual website database

- The same php script will then recompile my rss feed xml file and then sleep for x amount of time and then the whole process starts over again.

Now some might ask just why not add all the content at once instead of relasing it periodically. My answer is this: I already have a good amount of content and since I dont want the site to appear dormant I will release content in this manor. Also, I am doing this for SEO reasons as well.

[bill]

A lot of blog software will do this for you. MovableType lets you indicate a future date, and then you run a cron job on the server to publish these future posts on the dates indicated.

[emodo]

drupal has a addon which allows you to choose a time to publish articles.

I tend to upload a bunch of articles at once and I use this to stagger the appearance of articles for google.

[kamakaze]

Thanks for your replies. Yeah I figured that they are modules and other things out there for this but I am a true NERD and wanted to create my own. :-)

[munchiez]

Like the idea, but would it be simpler to add all of the articles at once then give the table that holds them a "birth" date field? Then all you need to do is modify your sql to only display articles after this date.