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.
php project worth 50usd
Moderator: General Moderators
Re: php project worth 50usd
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!
But i have no idea about the 4th one!
Re: php project worth 50usd
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
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
Re: php project worth 50usd
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 
Re: php project worth 50usd
Thanks and good luck