How to count length of csv file in when uploaded in php ?

Question

code:

<?php
    if(isset($_POST['upload']))
    {
        $filename = $_FILES['files']['name'];
        $path = "upload_enq/";
        $move = move_uploaded_file($_FILES['files']['tmp_name'],$path.$_FILES['files']['name']);
        $path_file = "upload_enq/".basename($_FILES['files']['name']);

        $c =0;
        $fileObj = fopen( $path_file, "rt" );
        if($fileObj){
            while(!feof($fileObj)){
                $content = fgets($fileObj);
                if($content)    
                $c++;
            }
        }
        fclose($fileObj);
        echo $c;
    }
?>
<form class="forms-sample" method="post" enctype="multipart/form-data">
    <input type="file" name="files" id="files" />
    <input type="submit" class="btn btn-success mr-2" name="upload" id="upload" value="Upload" />
</form>

In this code I have create a simple form where I am uploaded csv file and I want to count lenght of csv file. Now what happen when I uploaded csv file which having 295 rows but it shows wrong output it count 926 rows. So, How can I fix this issue ?Please help me.

Thank You

Please check this link. https://stackoverflow.com/questions/21447329/how-can-i-get-the-total-number-of-rows-in-a-csv-file-with-php — Sachin Tripathi, May 30 '18 at 06:14

Alive to die - Anant · Accepted Answer · 2018-05-30T05:59:28.367

As you said that you need the row count of the csv file, so use file()

$fp = file( $path_file, FILE_SKIP_EMPTY_LINES);
echo count($fp);

So the code will become short now

<?php
    if(isset($_POST['upload']))
    {
        $filename = $_FILES['files']['name'];
        $path = "upload_enq/";
        $move = move_uploaded_file($_FILES['files']['tmp_name'],$path.$_FILES['files']['name']);
        $path_file = "upload_enq/".basename($_FILES['files']['name']);

        $fp = file( $path_file);
        echo count($fp);
    }
?>

I have tested it on local:-

https://prnt.sc/jody8e

https://prnt.sc/jodyjl

https://prnt.sc/jodyoz

score 0 · Answer 2 · answered May 30 '18 at 05:49

0

As per my comments use Count function to get total number of rows in CSV file like this

$fileObj= file('filename.csv');
echo count($fileObj);

for more details read PHP Manual

answered May 30 '18 at 05:49

Bilal Ahmed

4,005
3
22
42

How to count length of csv file in when uploaded in php ?

2 Answers2