php project worth 50usd

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
popuskin
Forum Newbie
Posts: 6
Joined: Thu Sep 04, 2008 8:01 am

php project worth 50usd

Post by popuskin »

I need your help concerning a project of mine.
This is the scenerio.

There is a website where I normally download pricelist in excel format.
I normally save the excel pricelist as a .csv and use a php script to write the .csv file into mysql databse.
My website automatically gets refreshed by the new info from the newly converted .csv into mysql
Now all this is somehow time consuming.

My Question:
1) Is it possible to have a php script automatically download this excel file. - the excel file has a constant name.
2) Save the downloaded excel file as a .csv
3) Have my already php script run the script for the insertion of the .csv into mysql
4) Finally, I want the pricelist to reflect on other websites once i give them access. - How would this be possible?
What variable will they put on thier website to have the information displayed there?
All this to be done automatically without any single manual work.
All this to be done at 3.00PM every day except saturdays and sundays.
oscardog
Forum Contributor
Posts: 245
Joined: Thu Oct 23, 2008 4:43 pm

Re: php project worth 50usd

Post by oscardog »

Well the first 2 or 3 can be done with a Cron job i imagine, certainly the first one.

But i have no idea about the 4th one!
popuskin
Forum Newbie
Posts: 6
Joined: Thu Sep 04, 2008 8:01 am

Re: php project worth 50usd

Post by popuskin »

Thanks for the reply.

How do we go about it now? do u want to help find the third solution and we make it business or you just want to teach me how to go about the first probable ones?

Thanks
oscardog
Forum Contributor
Posts: 245
Joined: Thu Oct 23, 2008 4:43 pm

Re: php project worth 50usd

Post by oscardog »

To be honest, im not that knowledgeable, im relatively new to PHP and have never really looked at Cron Jobs but im sure if you keep checking here someone will be able to help solve your problem :)
popuskin
Forum Newbie
Posts: 6
Joined: Thu Sep 04, 2008 8:01 am

Re: php project worth 50usd

Post by popuskin »

Thanks and good luck
Post Reply