Lost Password?


Go Back   CodeCall Programming Forum > Web Development Forum > PHP Forum

PHP Forum Use this forum to discuss all aspects of PHP Development. PHP is a server-side, cross-platform, HTML embedded scripting language that lets you create dynamic web pages.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-06-2008, 01:55 PM
Scottyf11 Scottyf11 is offline
Newbie
 
Join Date: Aug 2008
Posts: 3
Rep Power: 0
Scottyf11 is on a distinguished road
Default How to have PHP get data from websites and store in mySQL

I want to create a database that contains every stock ticker, and all types of financial information for each ticker. I need PHP to read an excel file for a ticker symbol, then query websites like reuters, yahoo finance, google finance to gather financial statement and other appropriate financial information. I then need PHP to write this information to the database, and continue until all tickers have been "researched". This project is going to be very intense, and I was hoping someone could help me get started. I don't need you to write the code (obviously), but maybe provide me with tutorials for this type of project.

Thanks!

Scott
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
  #2 (permalink)  
Old 08-06-2008, 02:23 PM
orjan's Avatar   
orjan orjan is offline
Programming Professional
 
Join Date: Sep 2007
Location: Sunne, Värmland, Sweden
Age: 33
Posts: 328
Last Blog:
Procedural Programming...
Rep Power: 9
orjan has a spectacular aura aboutorjan has a spectacular aura aboutorjan has a spectacular aura about
Default Re: How to have PHP get data from websites and store in mySQL

Well, first of all, is excel file necessary? wouldn't it be easier if you enter a stock ticker on the web page and puts it to search around for information?

maybe store requested tickers in a DB with relevant information from these places?

then to fetch this info, you need to find out how to get appropriate info from the pages, how to use curl or any other method. when you have fetch the the info page, you then need how to locate the attactive info on the page and store it to your database.

this is the very basic things to look in to in the first place.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT -5. The time now is 06:15 AM.

Contest Stats

WingedPanther ........ 2753.6
Xav ........ 2704
Brandon W ........ 1702.32
John ........ 1207.73
marwex89 ........ 1175.24
morefood2001 ........ 966.05
dcs ........ 655.75
Steve.L ........ 475.59
orjan ........ 418.58
Aereshaa ........ 383.54

Contest Rules

CodeCall Goal

Goal: 100,000 Posts
Complete: 97%

Ads