Importing CSV to php

thesnoopy

Hi I need help I have a CSV file that I need to add to a web page

sample CSV file

my csv looks like this

HARRISON V MEDINA,SCOTT HARRISON,MANUEL MEDINA,1,12,2,2,34,14,48,9,14,3,12,53,17,70,10
HARRISON V MEDINA,SCOTT HARRISON,MANUEL MEDINA,2,19,5,6,43,24,67,9,13,8,10,81,21,102,10
HARRISON V MEDINA,SCOTT HARRISON,MANUEL MEDINA,3,17,3,7,44,20,64,10,14,13,9,74,27,101,9
HARRISON V MEDINA,SCOTT HARRISON,MANUEL MEDINA,4,13,2,2,43,15,58,9,19,3,16,55,22,77,10
HARRISON V MEDINA,SCOTT HARRISON,MANUEL MEDINA,5,21,2,11,54,23,77,10,16,6,12,62,22,84,9
HARRISON V MEDINA,SCOTT HARRISON,MANUEL MEDINA,6,10,1,1,43,11,54,9,24,5,16,59,29,88,10
HARRISON V MEDINA,SCOTT HARRISON,MANUEL MEDINA,7,18,2,6,59,20,79,9,21,11,11,49,32,81,10
HARRISON V MEDINA,SCOTT HARRISON,MANUEL MEDINA,8,17,1,3,37,18,55,9,26,5,16,41,31,72,10
HARRISON V MEDINA,SCOTT HARRISON,MANUEL MEDINA,9,22,2,5,46,24,70,10,9,3,5,60,12,72,9
HARRISON V MEDINA,SCOTT HARRISON,MANUEL MEDINA,10,11,0,2,39,11,50,9,22,7,15,54,29,83,10
HARRISON V MEDINA,SCOTT HARRISON,MANUEL MEDINA,11,15,2,2,39,17,56,9,22,5,10,57,27,84,10
HARRISON V MEDINA,SCOTT HARRISON,MANUEL MEDINA,12,18,0,3,53,18,71,9,34,10,18,59,44,103,10

I would like it to look something like this http://www.frankwarren.tv/fw4/samplestats.html

Can someone advice how I would go about doing it.

Many thanks

bpat1434

[man]explode/man to get an array of values

Then create a function to output the information.

~Brett

AstroTeg

Explode will work, especially with a file thesnoopy has provided as an example. The caution would be if there's extra commas, it'll botch up the array. For example:

HARRISON V MEDINA,SCOTT HARRISON,MANUEL MEDINA,1,12,2,2,34,14,48,9,14,3,12,53,17,70,10
HARRISON V, MEDINA,SCOTT HARRISON,MANUEL MEDINA,1,12,2,2,34,14,48,9,14,3,12,53,17,70,10

Both are exactly the same, except line 2 contains a comma after the V. Explode will consider "HARRISON V" as the first element instead of "HARRISON V, MEDINA." The work around is to include quotes around the data...

And (and the point of this post), I might recommend using [man]fgetcsv[/man] for this since it'll take into account the quotes, if they're in the file or not.

thesnoopy

Many Thanks for your quick replies.

I have limited knowledge with PHP and this will be my first time at writing from scratch.

I've tried the sample codes in fgetcsv but non eseen to work but my main problem will be is getting the information to look like this http://www.frankwarren.tv/fw4/samplestats.html