1. 使用类
注意: user.csv 第一行默认为数组的键, 且第一行不会被打印; (区别于下面的普通函数方法 )
例如:
name age gender
zhang 23 male
li 20 female
结果:
Array ( [0] => Array ( [name] => zhang [age] => 23 [gender] => male ) [1] => Array ( [name] => li [age] => 20 [gender] => female ) )
回到正题:
<?php //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 ? */ 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 < $totalRec ; $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' => '0', '1' => '1', '2' => '2', '3' => '3', '4' => '4', '5' => '5', '6' => '6', '7' => '7', '8' => '8', '9' => '9', 'A' => 'A', 'B' => 'B', 'C' => 'C', 'D' => 'D', 'E' => 'E', 'F' => 'F', 'G' => 'G', 'H' => 'H', 'I' => 'I', 'J' => 'J', 'K' => 'K', 'L' => 'L', 'M' => 'M', 'N' => 'N', 'O' => 'O', 'P' => 'P', 'Q' => 'Q', 'R' => 'R', 'S' => 'S', 'T' => 'T', 'U' => 'U', 'V' => 'V', 'W' => 'W', 'X' => 'X', 'Y' => 'Y', 'Z' => 'Z', 'a' => 'a', 'b' => 'b', 'c' => 'c', 'd' => 'd', 'e' => 'e', 'f' => 'f', 'g' => 'g', 'h' => 'h', 'i' => 'i', 'j' => 'j', 'k' => 'k', 'l' => 'l', 'm' => 'm', 'n' => 'n', 'o' => 'o', 'p' => 'p', 'q' => 'q', 'r' => 'r', 's' => 's', 't' => 't', 'u' => 'u', 'v' => 'v', 'w' => 'w', 'x' => 'x', 'y' => 'y', 'z' => 'z', '(' => '(', ')' => ')', '〔' => '[', '〕' => ']', '【' => '[', '】' => ']', '〖' => '[', '〗' => ']', '“' => '[', '”' => ']', '‘' => '[', '’' => ']', '{' => '{', '}' => '}', '《' => '<', '》' => '>', '%' => '%', '+' => '+', '—' => '-', '-' => '-', '~' => '-', ':' => ':', '。' => '.', '、' => ',', ',' => '.', '、' => '.', ';' => ',', '?' => '?', '!' => '!', '…' => '-', '‖' => '|', '”' => '"', '’' => '`', '‘' => '`', '|' => '|', '〃' => '"', ' ' => ' ','$'=>'$','@'=>'@','#'=>'#','^'=>'^','&'=>'&','*'=>'*'); return strtr($str, $arr); } function __destruct(){ fclose($this->handler); } } // example: $csv = new csv_to_array('user.csv'); echo "<pre>"; print_r($csv->get_array()); echo "</pre>";
2. 使用一般函数
<? function csv_to_array($csv) { $len = strlen($csv); $table = array(); $cur_row = array(); $cur_val = ""; $state = "first item"; for ($i = 0; $i < $len; $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 "<pre>"; print_r($arr); echo "</pre>"
或者
<? $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<$c;$x++) $arrCSV[$key][$x] = $data[$x]; $key++; } // end while // Close the CSV file fclose($handle); } // end if echo "<pre>"; print_r($arrCSV); echo "</pre>"; ?>