简体中文（ZH-CN）English（EN）繁体中文（ZH-TW）日本語（JA）한국어（KO）
Home
Article
Q&A
Course
Topic
Download
Game
Dictionary

Home  >  Article  >  Backend Development  >  php csv to array (csv to array) method and code

php csv to array (csv to array) method and code

WBOY
WBOYOriginal
2016-07-25 08:59:391429browse
  2. //ini_set('memory_limit', '-1'); // If the csv is relatively large, you can add it.
  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 < $totalRec ; $i++)
  53. {
  54. $key = $this->csvDataArr ? $csvDataArr[$i] : $this->remove_char($csvDataArr[$i]);
  55. if($csvValue[$i]) $this->csvData[$counter][$key] = $this->put_special_char($csvValue[$i]);
  56. }
  57. $counter++;
  58. }
  59. }
  60. return $this->csvData;
  61. }
  63. function put_special_char($value)
  64. {
  65. return $this->specialhtml ? str_replace(array('&','" ','\'','<','>'),array('&','"',''','<','>'),$value) : $value;
  66. }
  68. function remove_char($value)
  69. {
  70. $result = $this->removechar == 'manual' ? $this->remove_char_manual($value) : $this->remove_char_auto($value);
  71. return str_replace(' ','_',trim($result));
  72. }
  74. private function remove_char_manual($value)
  75. {
  76. return str_replace(array('&','"','\'','<','>','(',')','%'),'',trim($value));
  77. }
  79. private function remove_char_auto($str,$x=0)
  80. {
  81. $x==0 ? $str=$this->make_semiangle($str) : '' ;
  82. eregi('[[:punct:]]',$str,$arr);
  83. $str = str_replace($arr[0],'',$str);
  85. return eregi('[[:punct:]]',$str) ? $this->remove_char_auto($str,1) : $str;
  86. }
  88. private function make_semiangle($str)
  89. {
  90. $arr = array('０' => '0', '１' => '1', '２' => '2', '３' => '3', '４' => '4',
  91. '５' => '5', '６' => '6', '７' => '7', '８' => '8', '９' => '9',
  92. 'Ａ' => 'A', 'Ｂ' => 'B', 'Ｃ' => 'C', 'Ｄ' => 'D', 'Ｅ' => 'E',
  93. 'Ｆ' => 'F', 'Ｇ' => 'G', 'Ｈ' => 'H', 'Ｉ' => 'I', 'Ｊ' => 'J',
  94. 'Ｋ' => 'K', 'Ｌ' => 'L', 'Ｍ' => 'M', 'Ｎ' => 'N', 'Ｏ' => 'O',
  95. 'Ｐ' => 'P', 'Ｑ' => 'Q', 'Ｒ' => 'R', 'Ｓ' => 'S', 'Ｔ' => 'T',
  96. 'Ｕ' => 'U', 'Ｖ' => 'V', 'Ｗ' => 'W', 'Ｘ' => 'X', 'Ｙ' => 'Y',
  97. 'Ｚ' => 'Z', 'ａ' => 'a', 'ｂ' => 'b', 'ｃ' => 'c', 'ｄ' => 'd',
  98. 'ｅ' => 'e', 'ｆ' => 'f', 'ｇ' => 'g', 'ｈ' => 'h', 'ｉ' => 'i',
  99. 'ｊ' => 'j', 'ｋ' => 'k', 'ｌ' => 'l', 'ｍ' => 'm', 'ｎ' => 'n',
  100. 'ｏ' => 'o', 'ｐ' => 'p', 'ｑ' => 'q', 'ｒ' => 'r', 'ｓ' => 's',
  101. 'ｔ' => 't', 'ｕ' => 'u', 'ｖ' => 'v', 'ｗ' => 'w', 'ｘ' => 'x',
  102. 'ｙ' => 'y', 'ｚ' => 'z',
  103. '（' => '(', '）' => ')', '〔' => '[', '〕' => ']', '【' => '[',
  104. '】' => ']', '〖' => '[', '〗' => ']', '“' => '[', '”' => ']',
  105. '‘' => '[', '’' => ']', '｛' => '{', '｝' => '}', '《' => '<',
  106. '》' => '>',
  107. '％' => '%', '＋' => '+', '—' => '-', '－' => '-', '～' => '-',
  108. '：' => ':', '。' => '.', '、' => ',', '，' => '.', '、' => '.',
  109. '；' => ',', '？' => '?', '！' => '!', '…' => '-', '‖' => '|',
  110. '”' => '"', '’' => '`', '‘' => '`', '｜' => '|', '〃' => '"',
  111. '　' => ' ','＄'=>'$','＠'=>'@','＃'=>'#','＾'=>'^','＆'=>'&','＊'=>'*');
  113. return strtr($str, $arr);
  114. }
  116. function __destruct(){
  117. fclose($this->handler);
  118. }
  119. }
  120. // example:
  121. $csv = new csv_to_array('user.csv');
  122. echo "
    "; print_r($csv->get_array()); echo "
    ";
  123. ?>
复制代码

2. Use general functions

  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 < $len; $i++)
  15. {
  16. //sleep(1000);
  17. $ch = substr($csv,$i,1);
  18. if ($state == "first item")
  19. {
  20. if ($ch == '"') $state = "we're quoted hea";
  21. elseif ($ch == ",") //empty
  22. {
  23. $cur_row[] = ""; //done with first one
  24. $cur_val = "";
  25. $state = "first item";
  26. }
  27. elseif ($ch == "n")
  28. {
  29. $cur_row[] = $cur_val;
  30. $table[] = $cur_row;
  31. $cur_row = array();
  32. $cur_val = "";
  33. $state = "first item";
  34. }
  35. elseif ($ch == "r") $state = "wait for a line feed, if so close out row!";
  36. else
  37. {
  38. $cur_val .= $ch;
  39. $state = "gather not quote";
  40. }
  42. }
  44. elseif ($state == "we're quoted hea")
  45. {
  46. if ($ch == '"') $state = "potential end quote found";
  47. else $cur_val .= $ch;
  48. }
  49. elseif ($state == "potential end quote found")
  50. {
  51. if ($ch == '"')
  52. {
  53. $cur_val .= '"';
  54. $state = "we're quoted hea";
  55. }
  56. elseif ($ch == ',')
  57. {
  58. $cur_row[] = $cur_val;
  59. $cur_val = "";
  60. $state = "first item";
  61. }
  62. elseif ($ch == "n")
  63. {
  64. $cur_row[] = $cur_val;
  65. $table[] = $cur_row;
  66. $cur_row = array();
  67. $cur_val = "";
  68. $state = "first item";
  69. }
  70. elseif ($ch == "r") $state = "wait for a line feed, if so close out row!";
  71. else
  72. {
  73. $cur_val .= $ch;
  74. $state = "we're quoted hea";
  75. }
  77. }
  78. elseif ($state == "wait for a line feed, if so close out row!")
  79. {
  80. if ($ch == "n")
  81. {
  82. $cur_row[] = $cur_val;
  83. $cur_val = "";
  84. $table[] = $cur_row;
  85. $cur_row = array();
  86. $state = "first item";
  88. }
  89. else
  90. {
  91. $cur_row[] = $cur_val;
  92. $table[] = $cur_row;
  93. $cur_row = array();
  94. $cur_val = $ch;
  95. $state = "gather not quote";
  96. }
  97. }
  99. elseif ($state == "gather not quote")
  100. {
  101. if ($ch == ",")
  102. {
  103. $cur_row[] = $cur_val;
  104. $cur_val = "";
  105. $state = "first item";
  107. }
  108. elseif ($ch == "n")
  109. {
  110. $cur_row[] = $cur_val;
  111. $table[] = $cur_row;
  112. $cur_row = array();
  113. $cur_val = "";
  114. $state = "first item";
  115. }
  116. elseif ($ch == "r") $state = "wait for a line feed, if so close out row!";
  117. else $cur_val .= $ch;
  118. }
  120. }
  122. return $table;
  123. }
  125. //pass a csv string, get a php array
  126. // example:
  127. $arr = csv_to_array(file_get_contents('user.csv'));
  128. echo "
    "; print_r($arr);   echo "
    "
  129. ?>
复制代码

或者

  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<$c;$x++) $arrCSV[$key][$x] = $data[$x];
  14. $key++;
  15. } // end while
  16. // Close the CSV file
  17. fclose($handle);
  18. } // end if
  19. echo "
    "; print_r($arrCSV); echo "
    ";
  20. ?>
复制代码

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



Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：PHP directory traversal and deletion function examplesNext article：PHP directory traversal and deletion function examples

Related articles

See more