php csv to array(csv 转数组)方法与代码

    //ini_set('memory_limit', '-1'); // 如果csv比较大的话，可以添加。
    /*
     *  $file : csv file
     *  $csvDataArr : header of csv table, eg: arary('name','sex','age') or array(0,1,2)
     *  $specialhtml : whether do you want to convert special characters to html entities ?
     *  $removechar : which type do you want to remove special characters in array keys, manual or automatical ?
     *  edit http://bbs.it-home.org
     */
    class csv_to_array
    {
        private $counter;
        private $handler;
        private $length;
        private $file;
        private $seprator;
        private $specialhtml;
        private $removechar = 'manual';
        private $csvDataArr;
        private $csvData = array();

        function __construct($file = '', $csvDataArr = '', $specialhtml = true, $length = 1000, $seprator = ',')
        {
            $this->counter = 0;
            $this->length = $length;
            $this->file = $file;
            $this->seprator =  $seprator;
            $this->specialhtml =  $specialhtml;
            $this->csvDataArr = is_array($csvDataArr) ? $csvDataArr : array();
            $this->handler = fopen($this->file, "r");
        }

        function get_array()
        {
            $getCsvArr = array();
            $csvDataArr = array();
            while(($data = fgetcsv($this->handler, $this->length, $this->seprator)) != FALSE)
            {
                $num = count($data);
                $getCsvArr[$this->counter] = $data;
                $this->counter++;
            }
            if(count($getCsvArr) > 0)
            {
                $csvDataArr = array_shift($getCsvArr);
                if($this->csvDataArr) $csvDataArr = $this->csvDataArr;

                $counter = 0;
                foreach($getCsvArr as $csvValue)
                {
                    $totalRec = count($csvValue);
                    for($i = 0; $i                     {
                        $key = $this->csvDataArr ? $csvDataArr[$i] : $this->remove_char($csvDataArr[$i]);
                        if($csvValue[$i]) $this->csvData[$counter][$key] = $this->put_special_char($csvValue[$i]);
                    }
                    $counter++;
                }
            }
            return $this->csvData;
        }

        function put_special_char($value)
        {
            return $this->specialhtml ? str_replace(array('&','" ','\'',''),array('&','"',''','<','>'),$value) : $value;
        }

        function remove_char($value)
        {
            $result = $this->removechar == 'manual' ? $this->remove_char_manual($value) : $this->remove_char_auto($value);
            return str_replace(' ','_',trim($result));
        }

        private function remove_char_manual($value)
        {
            return str_replace(array('&','"','\'','','(',')','%'),'',trim($value));
        }

        private function remove_char_auto($str,$x=0)
        {
            $x==0 ? $str=$this->make_semiangle($str) : '' ;
            eregi('[[:punct:]]',$str,$arr);
            $str = str_replace($arr[0],'',$str);

            return eregi('[[:punct:]]',$str) ? $this->remove_char_auto($str,1) : $str;
        }

        private function make_semiangle($str)
        {
            $arr = array('０' => '0', '１' => '1', '２' => '2', '３' => '3', '４' => '4',
            '５' => '5', '６' => '6', '７' => '7', '８' => '8', '９' => '9',
            'Ａ' => 'A', 'Ｂ' => 'B', 'Ｃ' => 'C', 'Ｄ' => 'D', 'Ｅ' => 'E',
            'Ｆ' => 'F', 'Ｇ' => 'G', 'Ｈ' => 'H', 'Ｉ' => 'I', 'Ｊ' => 'J',
            'Ｋ' => 'K', 'Ｌ' => 'L', 'Ｍ' => 'M', 'Ｎ' => 'N', 'Ｏ' => 'O',
            'Ｐ' => 'P', 'Ｑ' => 'Q', 'Ｒ' => 'R', 'Ｓ' => 'S', 'Ｔ' => 'T',
            'Ｕ' => 'U', 'Ｖ' => 'V', 'Ｗ' => 'W', 'Ｘ' => 'X', 'Ｙ' => 'Y',
            'Ｚ' => 'Z', 'ａ' => 'a', 'ｂ' => 'b', 'ｃ' => 'c', 'ｄ' => 'd',
            'ｅ' => 'e', 'ｆ' => 'f', 'ｇ' => 'g', 'ｈ' => 'h', 'ｉ' => 'i',
            'ｊ' => 'j', 'ｋ' => 'k', 'ｌ' => 'l', 'ｍ' => 'm', 'ｎ' => 'n',
            'ｏ' => 'o', 'ｐ' => 'p', 'ｑ' => 'q', 'ｒ' => 'r', 'ｓ' => 's',
            'ｔ' => 't', 'ｕ' => 'u', 'ｖ' => 'v', 'ｗ' => 'w', 'ｘ' => 'x',
            'ｙ' => 'y', 'ｚ' => 'z',
            '（' => '(', '）' => ')', '〔' => '[', '〕' => ']', '【' => '[',
            '】' => ']', '〖' => '[', '〗' => ']', '“' => '[', '”' => ']',
            '‘' => '[', '’' => ']', '｛' => '{', '｝' => '}', '《' => '            '》' => '>',
            '％' => '%', '＋' => '+', '—' => '-', '－' => '-', '～' => '-',
            '：' => ':', '。' => '.', '、' => ',', '，' => '.', '、' => '.',
            '；' => ',', '？' => '?', '！' => '!', '…' => '-', '‖' => '|',
            '”' => '"', '’' => '`', '‘' => '`', '｜' => '|', '〃' => '"',
            '　' => ' ','＄'=>'$','＠'=>'@','＃'=>'#','＾'=>'^','＆'=>'&','＊'=>'*');

            return strtr($str, $arr);
        }

        function __destruct(){
            fclose($this->handler);
        }
    }
    // example:
    $csv = new csv_to_array('user.csv');
    echo ""; print_r($csv->get_array()); echo "";
?>

2、使用一般函数

    function csv_to_array($csv)
    {
        $len = strlen($csv);


        $table = array();
        $cur_row = array();
        $cur_val = "";
        $state = "first item";


        for ($i = 0; $i         {
            //sleep(1000);
            $ch = substr($csv,$i,1);
            if ($state == "first item")
            {
                if ($ch == '"') $state = "we're quoted hea";
                elseif ($ch == ",") //empty
                {
                    $cur_row[] = ""; //done with first one
                    $cur_val = "";
                    $state = "first item";
                }
                elseif ($ch == "\n")
                {
                    $cur_row[] = $cur_val;
                    $table[] = $cur_row;
                    $cur_row = array();
                    $cur_val = "";
                    $state = "first item";
                }
                elseif ($ch == "\r") $state = "wait for a line feed, if so close out row!";
                else
                {
                    $cur_val .= $ch;
                    $state = "gather not quote";
                }

            }

            elseif ($state == "we're quoted hea")
            {
                if ($ch == '"') $state = "potential end quote found";
                else $cur_val .= $ch;
            }
            elseif ($state == "potential end quote found")
            {
                if ($ch == '"')
                {
                    $cur_val .= '"';
                    $state = "we're quoted hea";
                }
                elseif ($ch == ',')
                {
                    $cur_row[] = $cur_val;
                    $cur_val = "";
                    $state = "first item";
                }
                elseif ($ch == "\n")
                {
                    $cur_row[] = $cur_val;
                    $table[] = $cur_row;
                    $cur_row = array();
                    $cur_val = "";
                    $state = "first item";
                }
                elseif ($ch == "\r") $state = "wait for a line feed, if so close out row!";
                else
                {
                    $cur_val .= $ch;
                    $state = "we're quoted hea";
                }

            }
            elseif ($state == "wait for a line feed, if so close out row!")
            {
                if ($ch == "\n")
                {
                    $cur_row[] = $cur_val;
                    $cur_val = "";
                    $table[] = $cur_row;
                    $cur_row = array();
                    $state = "first item";

                }
                else
                {
                    $cur_row[] = $cur_val;
                    $table[] = $cur_row;
                    $cur_row = array();
                    $cur_val = $ch;
                    $state = "gather not quote";
                }
            }

            elseif ($state == "gather not quote")
            {
                if ($ch == ",")
                {
                    $cur_row[] = $cur_val;
                    $cur_val = "";
                    $state = "first item";

                }
                elseif ($ch == "\n")
                {
                    $cur_row[] = $cur_val;
                    $table[] = $cur_row;
                    $cur_row = array();
                    $cur_val = "";
                    $state = "first item";
                }
                elseif ($ch == "\r") $state = "wait for a line feed, if so close out row!";
                else $cur_val .= $ch;
            }

        }

        return $table;
    }

    //pass a csv string, get a php array
    // example:
    $arr = csv_to_array(file_get_contents('user.csv'));
    echo ""; print_r($arr);   echo ""
?>

或者

    $arrCSV = array();
    // Open the CSV
    if (($handle = fopen("user.csv", "r")) !==FALSE) {
        // Set the parent array key to 0
        $key = 0;
        // While there is data available loop through unlimited times (0) using separator (,)
        while (($data = fgetcsv($handle, 0, ",")) !==FALSE) {
           // Count the total keys in each row
           $c = count($data);
           //Populate the array
           for ($x=0;$x           $key++;
        } // end while
        // Close the CSV file
        fclose($handle);
    } // end if
    echo ""; print_r($arrCSV); echo "";
?>

至于哪种更好用，看自己的实际需求与个人爱好了，实际工作中csv转array的需求还是不少，建议大家多练习，多掌握。