Auto Updating PHP Pages

[andrewgarn]

How hard is this to implement?

 

I want to write a PHP script that will update every day (automatically without the page loading manually in a browser) from a html page.

 

It would stick the information retrieved from the html page and insert it into a MySQL database which would then be echoed onto the page using mysql select queries when a user loads the page.

 

I can do all the mysql stuff.

 

But i dont know how to make the dynamic updating part work? Can anyone explain if this is possible / where I should look to learn this?

[redarrow]

cron

 

http://www.modwest.com/help/kb5-125.html

[andrewgarn]

I was looking for a little more detail than that, like do I need to install something on the server or can a PHP function do it automatically?

 

I run an apache server on Windows Vista

[Fadion]

If u are on a linux environment then u can use cron to schedule the execution of your php script. Your hosting provider (if ure on virtual or dedicated hosting thats not a problem) should have any guide on how to create a cron job, but it shouldnt be difficult. If u cant find it, then ask the hosting company. Otherwise if ure on windows, i know only that it can be done with Scheduled Tasks, but have no idea on windows server technology.

 

And no u dont need to install anything and its not a php function obviously.

 

EDIT: Oops i just saw that ure on windows vista. Is that a local environment as why in the world should u use vista for a production server?

[andrewgarn]

Ok so basically I need a linux server or a deidicated host on the web?

 

I don't have any money to pay for web hosting at the moment, do you know of any free hosting sites that support 777 chmod? and well as supporting php with mySQL connections either to a local database or to db4free.net?

 

Thanks

[redarrow]

try this on windows m8

 

http://cronw.sourceforge.net/