I gang

csv reader php

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

Færdigheder: MySQL, PHP

Se mere: csv reader php, php csv reader, mysql stricknet, mysql csv reader, php reader csv, php csv sample, php table csv, optiontype php, php create table, create table php, create symbol, csv reader mysql, php file reader, php symbol, null, insert date, file reader, php upload file csv, csv form, php create csv file, sample php page, php insert select, insert txt, php upload file form, insert mysql table

Om arbejdsgiveren:
( 197 bedømmelser ) Hacienda Heights, United States

Projekt-ID: #988399

4 freelancere byder i gennemsnit $59 for dette job

SiliconMind

Kindly Check PM

$30 USD in 0 dage
(92 bedømmelser)
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 in 2 dage
(230 bedømmelser)
7.2
hungit

hello i can do your work

$45 USD in 0 dage
(21 bedømmelser)
5.1
usedless

Hi mate, please check pmb.

$60 USD in 0 dage
(3 bedømmelser)
2.6