使用PHP计算文件中有多少行[关闭]

Question

I'm new in PHP and I really need your help. I have a CSV-file (named *"Test.csv") in this form:

"ID";"Nom de famille";"Prénom";"Age";"Téléphone mobile";"Téléphone";"Téléphone 2";"Fax";"Adresse de messagerie";"Commentaires"

I need PHP code that can count how many lines in a specific CSV-file are and also store the "Age" field of each line in an array.

Answer 1

The most robust solution I can think of is just reading the file record by record because CSV data may contain newlines inside the values:

$ages = array(); $records = 0;
$f = fopen('data.csv', 'rt');
while (($row = fgetcsv($f, 4096, ';')) !== false) {
    // skip first record and empty ones
    if ($records > 0 && isset($row[3])) {
        $ages[] = $row[3]; // age is in fourth column
    }
    ++$records;
}
fclose($f);

// * $ages contains an array of all ages
// * $records contains the number of csv data records in the file 
//   which is not necessarily the same as lines
// * count($ages) contains the number of non-empty records)