Advertisement

07.09.2008 at 02:31PM PDT, ID: 23551984
[x]
Attachment Details

Parse HTML Table and store in MySQL

Asked by adecold in PHP Scripting Language, Scripting Languages, Web Development

Tags: PHP BASH MySQL

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

ThanksStart Free Trial
[+][-]07.09.2008 at 04:04PM PDT, ID: 21969144

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: PHP Scripting Language, Scripting Languages, Web Development
Tags: PHP BASH MySQL
Sign Up Now!
Solution Provided By: pmessana
Participating Experts: 3
Solution Grade: A
 
 
[+][-]07.09.2008 at 04:06PM PDT, ID: 21969161

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]07.09.2008 at 04:29PM PDT, ID: 21969284

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]07.09.2008 at 06:21PM PDT, ID: 21969720

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]07.09.2008 at 06:36PM PDT, ID: 21969772

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.09.2008 at 07:00PM PDT, ID: 21969856

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]07.09.2008 at 07:04PM PDT, ID: 21969880

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.09.2008 at 07:55PM PDT, ID: 21970149

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
[+][-]07.10.2008 at 07:20AM PDT, ID: 21973661

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628