foreach - Browsing CSV archive

Question

I need to scroll through a CSV file to capture a value and print it on the screen.

Example:

Column "N" line "2", in this case it is cell N2 that is written: 2,98

How to print this N2 cell on the screen? How to get there?

<?php
$h = fopen("produtividade do trabalho.csv","r");
$i = fgetcsv($h, null, ",");
foreach ($i as $indice => $valor) {
  echo var_dump($i);
}
?>

In the code above he prints this for me:

array(1) { [0]=> string(278) "trabalho;"Código do projeto";"Código do item";"Data de início do trabalho real";"Data final do trabalho real";"Nome da linha";"Desempenho";"Disponibilidade";"Eficiência da linha";"Unidades produzidas";"Unidades previstas";"Unidade de medida";"Unidades padrão por hora";"Duração"" }

In which case, that’s all that’s on line 1.

Answer 1

You need to open csv and go through array.

See this example removed from the PHP site itself with a slight change:

    $row = 1;
if (($handle = fopen("csv.csv", "r")) !== FALSE)
{
    //Passagem pelas linhas
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
    {
        $num = count($data);
        $row++;
        // Passagem pelas colunas
        for ($col = 0; $col < $num; $col++)
        {
            //Printando apenas a coluna 14
            if ($col == 14)
            {
                echo 'Exibindo valor para linha:'.$row.' e para a coluna: '.$data[$col] . "<br />\n";
            }
        }
    }
    fclose($handle);
}

Answer 2

In your case, the problem is in the fgetcsv function call. The third parameter is the delimiter, which you are passing the comma (,), but according to your example, this csv is separated by semicolon (;).

So to correct, just exchange the comma for the point-and-comma :)

$i = fgetcsv($h, null, ";");

Official documentation of fgetcsv: php.net/manual/en/Function.fgetcsv.php

To get the N column, just retrieve inside the foreach the position 13 of the variable $value: $value[13]

Answer 3

The handling of files .csv can be made easily. There is a package called CSV that you can install via composer. I recently published an answer on this problem.

This package turns the file information into one array which can be easily covered.

<?php
    use League\Csv\Reader;
    require '../vendor/autoload.php';

    $csv = Reader::createFromPath('caminho/arquivo.csv');
    $csv->setDelimiter(';');

    //remove da busca o cabeçalho do arquivo
    $headers = $csv->fetchOne(0);

    //Retorna todos os resultados
    $linhas = $csv->fetchAll();

    //Retorna o valor
    $valor = $linhas[0][13];
?>

Rows and columns start with index 0.