csv reader php
$30-250 USD
Оплачується при отриманні
program to upload options data from sample file into mysql table below
[url removed, login to view] has definitions of each line
1st page has form with upload file box
it will insert into this table
CREATE TABLE `options` (
`optionid` int(11) NOT NULL auto_increment,
`StockId` int(11) NOT NULL,
`optiondate` date NOT NULL,
`expDate` date NOT NULL,
`optionType` char(1) default NULL,
`strike` double default NULL,
`lastsale` double(10,2) NOT NULL,
`volume` int(11) NOT NULL,
`bid` double(10,2) NOT NULL,
`ask` double(10,2) NOT NULL,
`openInterest` int(11) NOT NULL,
PRIMARY KEY (`optionid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
For the first line
A 110416C00025000,A,,,,,,0,25,16.85,18.2,0,2011
StockId is get from select StockId from StockSymbols where Symbol='A';
optiondate is 2011-03-16 from the file name [url removed, login to view]
expDate is 2011-04-16 for the first line from 110416
optionType is C
strike is 25.00
lastsale is blank which is 0
volume is 0
bid 16.85
ask is 18.2
openInterest is 0
for this line
MGLN 110416C00050000,MGLN,,,,,1.7,0,50,0.0,2.6,11,2011
mysql> select StockId from StockSymbols where Symbol='MGLN';
+---------+
| StockId |
+---------+
| 1427 |
+---------+
1 row in set (0.03 sec)
mysql>
StockId is 1427
optiondate is 2011-03-16 from the file name [url removed, login to view]
expDate is 2011-04-16 for the first line from 110416
optionType is C
strike is 50.00
lastsale is blank which is 1.7
volume is 0
bid 0.0
ask is 2.6
openInterest is 11
ID Проекту: #988399
Про проект
4 фрілансерів(-и) готові виконати цю роботу у середньому за $59
EXPERT HERE >>>> 6+ years experience ! More than 250 projects completed! References can be provided on request ! Ready to start working on your project !