PHP csv를 배열로 (csv를 배열로) 방법 및 코드-PHP 튜토리얼-php.cn

PHP csv를 배열로 (csv를 배열로) 방법 및 코드

WBOY

풀어 주다： 2016-07-25 08:59:39

원래의

1577명이 탐색했습니다.

//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 < $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;
}
비공개 함수 make_semiangle($str)
{
$arr = array('0' => '0', '1' => '1', '2' => ; '2', '3' => '4',
'5' => '5', '７ ' => '7', '８' => '9',
'Ａ' => , 'Ｃ' => 'C', 'Ｄ' => 'E',
'Ｆ' => 'G', 'Ｈ' => 'I', 'Ｊ' => 'J',
'Ｋ' => => 'L', 'Ｍ' => 'N', 'Ｏ' => 'O',
'Ｐ' => 'Ｑ' => 'Q', 'Ｒ' => 'S', 'Ｔ' => U', 'Ｖ' => 'V', 'Ｗ' => 'W', 'Ｙ' => 'Y',
'Ｚ' = > 'Z', 'ａ' => 'b', 'ｄ' => 'd' ｅ' => 'e', 'ｆ' => 'g', 'ｈ' => 'i' 🎜> 'ｊ' => 'j', 'ｌ' => 'm', 'ｎ' => ',
'ｏ' => '오', 'ｐ' => 'p', 'ｑ' => 'q', 'ｒ' => 'r', 'ｓ' => 's',
'ｔ' => 't', 'ｕ' => '너', 'ｖ' => 'v', 'ｗ' => 'w', 'ｘ' => 'x',
'ｙ' => 'y', 'ｚ' => 'z',
'（' => '(', ')' => ')', '〔' => '[', '}' => ']', '【' => '[',
'】' => ']', '〖' => '[', '〗' => ']', '“' => '[', '”' => ']',
''' => '[', ''' => ']', '｛' => '{', '｝' => '}', ' 《' => '<',
'》' => '>',
'%' => '%', '+' => '', '—' => '-', '-' => '-', '~' => '-',
'：' => ':', '。' => '.', '、' => ',', '，' => '.', '、' => '.',
';' => ',', '?' => '?', '!' => '!', '…' => '-', '"' => '|',
'”' => '"', ''' => '`', ''' => '`', '|' => '|', '〃' => '"',
'　' = > '','＄'=>'$','＠'=>'@','＃'=>'#','＾'=>'^','&'=>' &','*'=>'*');
return strtr($str, $arr);
}
function __destruct(){
fclose($this->handler);
}
}
// 예:
$csv = new csv_to_array('user.csv');
echo "
```
"; print_r($csv->get_array()); echo "
```
";
?>
复代码