Use CSV as Array in PHP, input value and output value

Question

So I would like to use a CSV file as a array.

This is part of the huge CSV file I have.

1-1,Poh,ਪੋਹ,19
1-2,Poh,ਪੋਹ,20
1-3,Poh,ਪੋਹ,21
1-4,Poh,ਪੋਹ,22
1-5,Poh,ਪੋਹ,23
1-6,Poh,ਪੋਹ,24

So in PHP, I would call for 1-4. How can I call 1-4, and then get the output of the 3 values after it, in this case it is Poh,ਪੋਹ,22.

Then I make it so $1 = Poh, $2 = ਪੋਹ, $3 = 22.

How would I go doing this?

Have you tried any code? What error did you encounter?

Passerby
– Passerby

2016-01-18 02:47:43 +00:00
Commented Jan 18, 2016 at 2:47 — Passerby
– Passerby, Commented Jan 18, 2016 at 2:47
php.net/manual/en/function.str-getcsv.php

Matt
– Matt

2016-01-18 02:50:37 +00:00
Commented Jan 18, 2016 at 2:50 — Matt
– Matt, Commented Jan 18, 2016 at 2:50
@Matt, what do I do, I already tried that

Sarabveer
– Sarabveer

2016-01-18 02:51:59 +00:00
Commented Jan 18, 2016 at 2:51 — Sarabveer
– Sarabveer, Commented Jan 18, 2016 at 2:51

Sarabveer · Accepted Answer · 2016-01-18 03:45:54Z

2

You can do it like this:

$lines = file('.../xx.csv');
foreach ($lines as $raw_line) {
  $line = explode(',', $raw_line);
  $csv[$line[0]] = [$line[1], $line[2], $line[3]];
}
// then you can access to:
$csv['1-4'][0] // --> Poh
$csv['1-4'][1] // --> ਪੋਹ
$csv['1-4'][2] // --> 22

edited Jan 18, 2016 at 3:45

Sarabveer

296 bronze badges

answered Jan 18, 2016 at 2:54

cFreed

4,4641 gold badge26 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

Matt Over a year ago

I was thinking the exact same thing, but it may cause issues if he has comma values within the columns that are escaped but by the looks of it, that may not be an issue.

cFreed Over a year ago

@Matt Thanks for correcting my typo. Regarding the commas, I agree. Anyway, since this comes from CSV, if commas can be included, the OP will be forced to use delimited mode, and yes, this code should be revised accordingly.

Sarabveer Over a year ago

@cFreed Where is $csv defined?

cFreed Over a year ago

@SarabveerSingh $csv is populated at line 3 in the above code.

Sarabveer Over a year ago

@cFreed Parse error: syntax error, unexpected '$csv' (T_VARIABLE)

|

Collectives™ on Stack Overflow

Use CSV as Array in PHP, input value and output value

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related