[php] PHP 및 fgetcsv 함수를 사용하여 CSV 파일에서 배열을 만드는 방법

오래된 질문이지만 여전히 PHP 5.2 사용자와 관련이 있습니다. str_getcsv는 PHP 5.3에서 사용할 수 있습니다. fgetcsv 자체와 함께 작동하는 작은 함수를 작성했습니다.

아래는 https://gist.github.com/4152628의 내 기능입니다 .

function parse_csv_file($csvfile) {
    $csv = Array();
    $rowcount = 0;
    if (($handle = fopen($csvfile, "r")) !== FALSE) {
        $max_line_length = defined('MAX_LINE_LENGTH') ? MAX_LINE_LENGTH : 10000;
        $header = fgetcsv($handle, $max_line_length);
        $header_colcount = count($header);
        while (($row = fgetcsv($handle, $max_line_length)) !== FALSE) {
            $row_colcount = count($row);
            if ($row_colcount == $header_colcount) {
                $entry = array_combine($header, $row);
                $csv[] = $entry;
            }
            else {
                error_log("csvreader: Invalid number of columns at line " . ($rowcount + 2) . " (row " . ($rowcount + 1) . "). Expected=$header_colcount Got=$row_colcount");
                return null;
            }
            $rowcount++;
        }
        //echo "Totally $rowcount rows found\n";
        fclose($handle);
    }
    else {
        error_log("csvreader: Could not read CSV \"$csvfile\"");
        return null;
    }
    return $csv;
}

보고

CSV 읽기 시작

Array
(
    [0] => Array
        (
            [vid] =>
            [agency] =>
            [division] => Division
            [country] =>
            [station] => Duty Station
            [unit] => Unit / Department
            [grade] =>
            [funding] => Fund Code
            [number] => Country Office Position Number
            [wnumber] => Wings Position Number
            [title] => Position Title
            [tor] => Tor Text
            [tor_file] =>
            [status] =>
            [datetime] => Entry on Wings
            [laction] =>
            [supervisor] => Supervisor Index Number
            [asupervisor] => Alternative Supervisor Index
            [author] =>
            [category] =>
            [parent] => Reporting to Which Position Number
            [vacant] => Status (Vacant / Filled)
            [index] => Index Number
        )

    [1] => Array
        (
            [vid] =>
            [agency] => WFP
            [division] => KEN Kenya, The Republic Of
            [country] =>
            [station] => Nairobi
            [unit] => Human Resources Officer P4
            [grade] => P-4
            [funding] => 5000001
            [number] => 22018154
            [wnumber] =>
            [title] => Human Resources Officer P4
            [tor] =>
            [tor_file] =>
            [status] =>
            [datetime] =>
            [laction] =>
            [supervisor] =>
            [asupervisor] =>
            [author] =>
            [category] => Professional
            [parent] =>
            [vacant] =>
            [index] => xxxxx
        )
) 

답변

function getdata($csvFile){
    $file_handle = fopen($csvFile, 'r');
    while (!feof($file_handle) ) {
        $line_of_text[] = fgetcsv($file_handle, 1024);
    }
    fclose($file_handle);
    return $line_of_text;
}


// Set path to CSV file
$csvFile = 'test.csv';

$csv = getdata($csvFile);
echo '<pre>';
print_r($csv);
echo '</pre>';

Array
(
    [0] => Array
        (
            [0] => Project
            [1] => Date
            [2] => User
            [3] => Activity
            [4] => Issue
            [5] => Comment
            [6] => Hours
        )

    [1] => Array
        (
            [0] => test
            [1] => 04/30/2015
            [2] => test
            [3] => test
            [4] => test
            [5] =>
            [6] => 6.00
        ));

function csv_to_array($file_name) {
        $data =  $header = array();
        $i = 0;
        $file = fopen($file_name, 'r');
        while (($line = fgetcsv($file)) !== FALSE) {
            if( $i==0 ) {
                $header = $line;
            } else {
                $data[] = $line;
            }
            $i++;
        }
        fclose($file);
        foreach ($data as $key => $_value) {
            $new_item = array();
            foreach ($_value as $key => $value) {
                $new_item[ $header[$key] ] =$value;
            }
            $_data[] = $new_item;
        }
        return $_data;
    }