PHP fgetcsv() seems can not read the last field of any line from CSV file

Question

I've used fgetcsv() function to read data from a CSV file and import its information to MySQL. The data I have is something like this:

2,3,4,5,6,7,8,9,9,8,7,6,5,4,3,2,1
0,1,2,7,7,7,7,7,7,7,1,7,7,7,7,7,7

As you can see, each row has 17 fields and I must read them using their indexes from 0 to 17. But whenever I want to do it, I get an error that tells me there is not any index #17.
What is ther matter with it? I have to add a comma after the last field in each row ? If you answer is yes, why excel does not do it ? And how can I add a new , after each line of a CSV file ?

Tim Pietzcker · Accepted Answer · 2012-08-21 21:42:00Z

2

There are only 17 columns (as you seem to have counted yourself), so you get indices from 0 (first column) to 16 (17th column).

edited Aug 21, 2012 at 21:42

answered Aug 21, 2012 at 21:36

Tim Pietzcker

337k59 gold badges520 silver badges572 bronze badges

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

Collectives™ on Stack Overflow

PHP fgetcsv() seems can not read the last field of any line from CSV file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related