Count rows with data in csv using PHP

Question

I want to count total number of rows with data in csv. I did following:

<?php echo count(file('example.csv',FILE_IGNORE_NEW_LINES |` `FILE_SKIP_EMPTY_LINES)); ?>

Here, if all the values are only in first column then output is correct. eg. Row1Col1='a' & Row4Col1='b' o/p=2 correct because data in rows are

Row1->'a',Row2->'',Row3->'',Row4->'b'

But if values are in different column then get wrong output. eg. Ro1Col3='a' & Row4Col1='b' o/p=4 wrong (want correct output is 2) because data in rows are

Row1->'a', Row2->',,' Row3->',,' Row4->'b'.

Thanks, Jaydeep

Community · Accepted Answer · 2017-05-23 11:45:07Z

1

You could try the PHP function function.str_getcsv

You can use function.array_filter to remove any null elements within your CSV.

<?php

    $csv_complete_contents = array_map('str_getcsv', file('example.csv'));
    $csv_complete_filtered = array_filter(array_map('array_filter', $csv_complete_contents));
    $csv_num_rows = count($csv_complete_filtered);

    echo $csv_num_rows;

?>

edited May 23, 2017 at 11:45

CommunityBot

11 silver badge

answered Mar 30, 2016 at 6:01

classicjonesynz

4,0505 gold badges44 silver badges80 bronze badges

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

Collectives™ on Stack Overflow

Count rows with data in csv using PHP

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related