csv reader php

В роботі Опубліковано %project.relative_time Оплачується при отриманні
В роботі Оплачується при отриманні

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

MySQL PHP

ID Проекту: #988399

Про проект

4 заявок(-ки) Дистанційний проект Остання активність Mar 17, 2011

4 фрілансерів(-и) готові виконати цю роботу у середньому за $59

SiliconMind

Kindly Check PM

$30 USD за 0 дні(-в)
(92 відгуків(и))
6.9
eperfections

EXPERT HERE >>>> 6+ years experience ! More than 250 projects completed! References can be provided on request ! Ready to start working on your project !

$100 USD за 2 дні(-в)
(230 відгуків(и))
7.2
hungit

hello i can do your work

$45 USD за 0 дні(-в)
(21 відгуків(и))
5.1
usedless

Hi mate, please check pmb.

$60 USD за 0 дні(-в)
(3 відгуків(и))
2.6