I'm trying to get the daily prices of stocks from a webpage (Its a table) and store them in a MySQL database. Thats my initial goal in a much bigger project.
So i want to be able to fetch the table periodically (every work day preferably) and parse the table for specific fields and then store the table in a MySQL Database. I then want to do some calculations and present them on a web page (This will remain static, using the DB until the next parsing)
These are the tools i have at my disposal
PHP, MySQL and A Linux server that can run Cron Jobs ( +Bash Scripts then )
I might have a little more tools like Ruby installed on the server but i would like to limit it to that.
I have basic knowledge of what i am about to get into (HTML/PHP/MySQL) so my question won't be specific but i would like someone to direct me in a path to start.
No offense, but pointing me to a web page that teaches PHP/MySQL in general with no concrete link (or examples) to what i'm trying to do doesn't help much
PS>> If its easier.. for starters i might want to parse the HTML and store it in a flat file and then fetch numbers from the flat file to the webpage