How to get the line number per row in CSV file using PHP

Question

I have a CSV file that can viewed in WEB using PHP and HTML table using the code below.

I want to get the line number per row of the CSV file using PHP. I am able to get the total line number using COUNT, but I don't need the total; what I need is the line number per row.

How can I get that?

Here is my Code :


         style="background-color:#DDDDDD">
 
             
                  Field 1
                  Field 2
                  Field 3
                  
                  Field 4
                  Field 5
                  
                  
                  Field 6
                  Field 7
                  Field 8
                  Field 9
                  Field 10
                  Field 11
                  Field 12
                  Field 13
                  
                  Field 14
                  Field 15
                  Field 16
                  
               
 
              
       


       Delete

krowe · Accepted Answer

Here is how I'd write this:

'Field 1', 'name'=>'val1', 'type'=>'text'),
    array('title'=>'Field 2', 'name'=>'val2',),
    array('title'=>'Field 3', 'name'=>'val3',),
    array(),
    array('title'=>'Field 4', 'name'=>'val4',),
    array('title'=>'Field 5', 'name'=>'val5',),
    array(),
    array(),
    array('title'=>'Field 6', 'name'=>'val6',),
    array('title'=>'Field 7', 'name'=>'val7',),
    array('title'=>'Field 8', 'name'=>'val8',),
    array('title'=>'Field 9', 'name'=>'val9',),
    array('title'=>'Field 10', 'name'=>'val10',),
    array('title'=>'Field 11', 'name'=>'val11',),
    array('title'=>'Field 12', 'name'=>'val12',),
    array('title'=>'Field 13', 'name'=>'val13',),
    array(),
    array('title'=>'Field 14', 'name'=>'val14',),
    array('title'=>'Field 15', 'name'=>'val15',),
    array('title'=>'Field 16', 'name'=>'val16',),
    array(),
);

if(filter_has_var(INPUT_GET, 'del'))
    csv_delete_record($csv_file, filter_input(INPUT_GET, 'del', FILTER_SANITIZE_NUMBER_INT));

csv_table($csv_file, $cols, true);
csv_table_form($cols, $csv_form_action);

/**
 * This function writes a table given a CSV file and a column definition.
 * 
 * Be sure that the column array is correct for the CSV file.
 * 
 * @param string $handle The CSV file name.
 * @param mixed $cols The column definition array.
 */
function csv_table($filename, $cols, $show_delete=false) {
    if(($handle=fopen($filename, "c+"))!==FALSE) {
        // This is a much better way to provide alternating table row styles for several reasons
        // This should probably be put in your CSS file instead of here though.
        echo "
	

";
        echo "	";
        foreach($cols as $col) {
            echo '";
          for($c=0; $c<$num; $c++) echo "
		';
            if(isset($col['title'])) {
                echo $col['title'];
                // We can go ahead and fill out the defaults here
                if(!isset($col['name'])) $col['name']=str_replace(' ', '-', $col['title']);
                if(!isset($col['type'])) $col['type']='text';
                if(!isset($col['id'])) $col['id']=$col['name'];
            }
        }
        echo "
";
        $row=0;
        while(($data=fgetcsv($handle, 10000, ','))!==FALSE) {
          $row++;
          $num=count($data);
          echo "		
".$data[$c];
          if($show_delete) echo " Delete"; // This may need tweaking for your site
              echo "
";      
        }
        fclose($handle);
        echo "	
";
    }
}
/**
 * This creates a form in a table layout to match a csv_table() table.
 * 
 * @param mixed $cols The column definition array.
 * @param string $form_action where to send the form post
 */
function csv_table_form($cols, $form_action) {
    echo "	
".
        "		";
        "			
";
    foreach($cols as $col) {
        echo "
		
";
        if(isset($col['name'])) echo "";
    }
    echo "		
	
";
}
/**
 * Delete a row from a file. It is meant for CSV files but works for any file with newlines.
 * 
 * This can be improved by just opening the file once in read-write mode but that'd take a little more effort.
 * 
 * @param string $filename
 * @param int $row_number The line of the file to remove
 */
function csv_delete_record($filename, $row_number) {
    $lines=file($filename);
    if(isset($lines[$row_number])) unset($lines[$row_number]);
    $lines=implode("
", $lines);
    if($h=fopen($filename, 'a')) {
        fputcsv($h, $lines, '-');
        fclose($h);
    }
}

How to get the line number per row in CSV file using PHP

Answers (1)

Related Questions