使用PHP过滤CSV

Question

Hi I have a CSV file that needs filtering, from A-C, D-F and so on

    Aaron, Male, [e-mail]
    Arianne, Female, [e-mail]
    Bea, Female, [e-mail]
    Carlos, Male, [e-mail]
    Drake, Male, [e-mail]
    Delilah, Female, [e-mail]
    Erica, Female, [e-mail]
    Flint, Male, [e-mail]

Im not good at PHP and I tried to fix it by doing this code below.

<?php
$file  = fopen('LoggedInUsers.csv', 'r');

$first = array('Aaron');
$last = array('Carlos');



while (($line = fgetcsv($file)) !== FALSE) {  
    list($name, $log, $department) = $line;

    $firstt = array('Aaron');
    if ($first < 0) {
    }
    $last = array ('Carlos');
    if ($last < 0) {
}
?>

Answer 1

What I would do is create a pseudo grouping structure first (an array) A-C, D-F, ... that would be used for grouping, then just check the current first letter on the iteration, then just push it inside according to its belonged format. Example:

$filters = array_chunk(range('a', 'z'), 3); // grouping structure
$file  = fopen('LoggedInUsers.csv', 'r');

$data = array();
while (($line = fgetcsv($file)) !== false) {
    list($name, $log, $department) = $line;
    foreach($filters as $batch =>$filter_batch) {
        // if the current name does belong to this structure, push it inside
        if(in_array(strtolower(substr($name, 0, 1)), $filter_batch)) {
            $data[$batch][] = $name;
        }
    }
}

echo '<pre>';
print_r($data);

So the output should be:

Array
(
    [0] => Array // batch of A-C
    (
        [0] => Aaron
        [1] => Arianne
        [2] => Bea
        [3] => Carlos
    )

    [1] => Array // batch of D-F
    (
        [0] => Drake
        [1] => Delilah
        [2] => Erica
        [3] => Flint
    )

)