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

2. //ini_set('memory_limit', '-1'); // 如果csv比较大的话，可以添加。
3. /*
4. * $file : csv file
5. * $csvDataArr : header of csv table, eg: arary('name','sex','age') or array(0,1,2)
6. * $specialhtml : whether do you want to convert special characters to html entities ?
7. * $removechar : which type do you want to remove special characters in array keys, manual or automatical ?
8. * edit http://bbs.it-home.org
9. */
10. class csv_to_array
11. {
12. private $counter;
13. private $handler;
14. private $length;
15. private $file;
16. private $seprator;
17. private $specialhtml;
18. private $removechar = 'manual';
19. private $csvDataArr;
20. private $csvData = array();
22. function __construct($file = '', $csvDataArr = '', $specialhtml = true, $length = 1000, $seprator = ',')
23. {
24. $this->counter = 0;
25. $this->length = $length;
26. $this->file = $file;
27. $this->seprator = $seprator;
28. $this->specialhtml = $specialhtml;
29. $this->csvDataArr = is_array($csvDataArr) ? $csvDataArr : array();
30. $this->handler = fopen($this->file, "r");
31. }
33. function get_array()
34. {
35. $getCsvArr = array();
36. $csvDataArr = array();
37. while(($data = fgetcsv($this->handler, $this->length, $this->seprator)) != FALSE)
38. {
39. $num = count($data);
40. $getCsvArr[$this->counter] = $data;
41. $this->counter++;
42. }
43. if(count($getCsvArr) > 0)
44. {
45. $csvDataArr = array_shift($getCsvArr);
46. if($this->csvDataArr) $csvDataArr = $this->csvDataArr;
48. $counter = 0;
49. foreach($getCsvArr as $csvValue)
50. {
51. $totalRec = count($csvValue);
52. for($i = 0; $i {
53. $key = $this->csvDataArr ? $csvDataArr[$i] : $this->remove_char($csvDataArr[$i]);
54. if($csvValue[$i]) $this->csvData[$counter][$key] = $this->put_special_char($csvValue[$i]);
55. }
56. $counter++;
57. }
58. }
59. return $this->csvData;
60. }
62. function put_special_char($value)
63. {
64. return $this->specialhtml ? str_replace(array('&','" ','\'',''),array('&','"',''','<','>'),$value) : $value;
65. }
67. function remove_char($value)
68. {
69. $result = $this->removechar == 'manual' ? $this->remove_char_manual($value) : $this->remove_char_auto($value);
70. return str_replace(' ','_',trim($result));
71. }
73. private function remove_char_manual($value)
74. {
75. return str_replace(array('&','"','\'','','(',')','%'),'',trim($value));
76. }
78. private function remove_char_auto($str,$x=0)
79. {
80. $x==0 ? $str=$this->make_semiangle($str) : '' ;
81. eregi('[[:punct:]]',$str,$arr);
82. $str = str_replace($arr[0],'',$str);
84. return eregi('[[:punct:]]',$str) ? $this->remove_char_auto($str,1) : $str;
85. }
87. private function make_semiangle($str)
88. {
89. $arr = array('０' => '0', '１' => '1', '２' => '2', '３' => '3', '４' => '4',
90. '５' => '5', '６' => '6', '７' => '7', '８' => '8', '９' => '9',
91. 'Ａ' => 'A', 'Ｂ' => 'B', 'Ｃ' => 'C', 'Ｄ' => 'D', 'Ｅ' => 'E',
92. 'Ｆ' => 'F', 'Ｇ' => 'G', 'Ｈ' => 'H', 'Ｉ' => 'I', 'Ｊ' => 'J',
93. 'Ｋ' => 'K', 'Ｌ' => 'L', 'Ｍ' => 'M', 'Ｎ' => 'N', 'Ｏ' => 'O',
94. 'Ｐ' => 'P', 'Ｑ' => 'Q', 'Ｒ' => 'R', 'Ｓ' => 'S', 'Ｔ' => 'T',
95. 'Ｕ' => 'U', 'Ｖ' => 'V', 'Ｗ' => 'W', 'Ｘ' => 'X', 'Ｙ' => 'Y',
96. 'Ｚ' => 'Z', 'ａ' => 'a', 'ｂ' => 'b', 'ｃ' => 'c', 'ｄ' => 'd',
97. 'ｅ' => 'e', 'ｆ' => 'f', 'ｇ' => 'g', 'ｈ' => 'h', 'ｉ' => 'i',
98. 'ｊ' => 'j', 'ｋ' => 'k', 'ｌ' => 'l', 'ｍ' => 'm', 'ｎ' => 'n',
99. 'ｏ' => 'o', 'ｐ' => 'p', 'ｑ' => 'q', 'ｒ' => 'r', 'ｓ' => 's',
100. 'ｔ' => 't', 'ｕ' => 'u', 'ｖ' => 'v', 'ｗ' => 'w', 'ｘ' => 'x',
101. 'ｙ' => 'y', 'ｚ' => 'z',
102. '（' => '(', '）' => ')', '〔' => '[', '〕' => ']', '【' => '[',
103. '】' => ']', '〖' => '[', '〗' => ']', '“' => '[', '”' => ']',
104. '‘' => '[', '’' => ']', '｛' => '{', '｝' => '}', '《' => ' '》' => '>',
105. '％' => '%', '＋' => '+', '—' => '-', '－' => '-', '～' => '-',
106. '：' => ':', '。' => '.', '、' => ',', '，' => '.', '、' => '.',
107. '；' => ',', '？' => '?', '！' => '!', '…' => '-', '‖' => '|',
108. '”' => '"', '’' => '`', '‘' => '`', '｜' => '|', '〃' => '"',
109. '　' => ' ','＄'=>'$','＠'=>'@','＃'=>'#','＾'=>'^','＆'=>'&','＊'=>'*');
111. return strtr($str, $arr);
112. }
114. function __destruct(){
115. fclose($this->handler);
116. }
117. }
118. // example:
119. $csv = new csv_to_array('user.csv');
120. echo "

     "; print_r($csv->get_array()); echo "

     ";
121. ?>

复制代码

2、使用一般函数

3. function csv_to_array($csv)
4. {
5. $len = strlen($csv);
8. $table = array();
9. $cur_row = array();
10. $cur_val = "";
11. $state = "first item";
14. for ($i = 0; $i {
15. //sleep(1000);
16. $ch = substr($csv,$i,1);
17. if ($state == "first item")
18. {
19. if ($ch == '"') $state = "we're quoted hea";
20. elseif ($ch == ",") //empty
21. {
22. $cur_row[] = ""; //done with first one
23. $cur_val = "";
24. $state = "first item";
25. }
26. elseif ($ch == "\n")
27. {
28. $cur_row[] = $cur_val;
29. $table[] = $cur_row;
30. $cur_row = array();
31. $cur_val = "";
32. $state = "first item";
33. }
34. elseif ($ch == "\r") $state = "wait for a line feed, if so close out row!";
35. else
36. {
37. $cur_val .= $ch;
38. $state = "gather not quote";
39. }
41. }
43. elseif ($state == "we're quoted hea")
44. {
45. if ($ch == '"') $state = "potential end quote found";
46. else $cur_val .= $ch;
47. }
48. elseif ($state == "potential end quote found")
49. {
50. if ($ch == '"')
51. {
52. $cur_val .= '"';
53. $state = "we're quoted hea";
54. }
55. elseif ($ch == ',')
56. {
57. $cur_row[] = $cur_val;
58. $cur_val = "";
59. $state = "first item";
60. }
61. elseif ($ch == "\n")
62. {
63. $cur_row[] = $cur_val;
64. $table[] = $cur_row;
65. $cur_row = array();
66. $cur_val = "";
67. $state = "first item";
68. }
69. elseif ($ch == "\r") $state = "wait for a line feed, if so close out row!";
70. else
71. {
72. $cur_val .= $ch;
73. $state = "we're quoted hea";
74. }
76. }
77. elseif ($state == "wait for a line feed, if so close out row!")
78. {
79. if ($ch == "\n")
80. {
81. $cur_row[] = $cur_val;
82. $cur_val = "";
83. $table[] = $cur_row;
84. $cur_row = array();
85. $state = "first item";
87. }
88. else
89. {
90. $cur_row[] = $cur_val;
91. $table[] = $cur_row;
92. $cur_row = array();
93. $cur_val = $ch;
94. $state = "gather not quote";
95. }
96. }
98. elseif ($state == "gather not quote")
99. {
100. if ($ch == ",")
101. {
102. $cur_row[] = $cur_val;
103. $cur_val = "";
104. $state = "first item";
106. }
107. elseif ($ch == "\n")
108. {
109. $cur_row[] = $cur_val;
110. $table[] = $cur_row;
111. $cur_row = array();
112. $cur_val = "";
113. $state = "first item";
114. }
115. elseif ($ch == "\r") $state = "wait for a line feed, if so close out row!";
116. else $cur_val .= $ch;
117. }
119. }
121. return $table;
122. }
124. //pass a csv string, get a php array
125. // example:
126. $arr = csv_to_array(file_get_contents('user.csv'));
127. echo "

     "; print_r($arr);   echo "

     "
128. ?>

复制代码

或者

3. $arrCSV = array();
4. // Open the CSV
5. if (($handle = fopen("user.csv", "r")) !==FALSE) {
6. // Set the parent array key to 0
7. $key = 0;
8. // While there is data available loop through unlimited times (0) using separator (,)
9. while (($data = fgetcsv($handle, 0, ",")) !==FALSE) {
10. // Count the total keys in each row
11. $c = count($data);
12. //Populate the array
13. for ($x=0;$x $key++;
14. } // end while
15. // Close the CSV file
16. fclose($handle);
17. } // end if
18. echo "

    "; print_r($arrCSV); echo "

    ";
19. ?>

复制代码

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