recherche

Maison >développement back-end >tutoriel php >php csv to array(csv 转数组)方法与代码

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

WBOY
WBOYoriginal
2016-07-25 08:59:391545parcourir
  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的需求还是不少，建议大家多练习，多掌握。



Déclaration：
Le contenu de cet article est volontairement contribué par les internautes et les droits d'auteur appartiennent à l'auteur original. Ce site n'assume aucune responsabilité légale correspondante. Si vous trouvez un contenu suspecté de plagiat ou de contrefaçon, veuillez contacter admin@php.cn
Article précédent：php 目录遍历与删除的函数示例 Article suivant：php5 Cookie与 Session用法区别与示例

Articles Liés

Voir plus