1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
|
<?php
/**
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
* @category PHP
* @author V.Krishn <vkrishn4@gmail.com>
* @copyright Copyright (c) 2012-2024 V.Krishn <vkrishn4@gmail.com>
* @license GPL
* @link http://github.com/insteps/phputils
* @version 0.1.3
*
*/
/**
* Parse a CSV string into an array for php 4+.
* @param string $input String
* @param string $delimiter String
* @param string $enclosure String
* @return array
*/
function str_getcsv4($input, $delimiter = ',', $enclosure = '"') {
if ( ! preg_match("/[$enclosure]/", $input) ) {
return (array)preg_replace(array("/^\\s*/", "/\\s*$/"), '', explode($delimiter, $input));
}
$token = "##"; $token2 = "::";
//alternate tokens "\034\034", "\035\035", "%%";
$t1 = preg_replace(array("/\\\[$enclosure]/", "/$enclosure{2}/",
"/[$enclosure]\\s*[$delimiter]\\s*[$enclosure]\\s*/", "/\\s*[$enclosure]\\s*/"),
array($token2, $token2, $token, $token), trim(trim(trim($input), $enclosure)));
$a = explode($token, $t1);
foreach($a as $k=>$v) {
if ( preg_match("/^{$delimiter}/", $v) || preg_match("/{$delimiter}$/", $v) ) {
$a[$k] = trim($v, $delimiter); $a[$k] = preg_replace("/$delimiter/", "$token", $a[$k]);
}
}
$a = explode($token, implode($token, $a));
return (array)preg_replace(array("/^\\s/", "/\\s$/", "/$token2/"), array('', '', $enclosure), $a);
}
/**
* Parse a CSV string into an array for php 4+. (Alternate)
* @param string $input String
* @param string $delimiter String
* @param string $enclosure String
* @return array
*/
function str_getcsv4a($input, $delimiter = ',', $enclosure = '"') {
if ( ! preg_match("/[$enclosure]/", $input) ) {
return (array)preg_replace(array("/^\\s*/", "/\\s*$/"), '', explode($delimiter, $input));
}
$a = explode($delimiter, $input);
$on = NULL;
foreach($a as $k=>$v) {
if ( preg_match("/{$enclosure}$/", rtrim($v)) ) {
$on = 0;
$c[] = $v; $b[] = trim(trim(implode(',', $c)), $enclosure);
unset($c); continue;
}
if ( preg_match("/^{$enclosure}/", ltrim($v)) ) {
$on = 1; unset($c);
$v = ltrim(ltrim($v), $enclosure);
}
if ( $on ) { $c[] = $v; continue; }
$b[] = trim($a[$k]);
}
return (array)$b;
}
/**
* Process an Array to CSV string.
* @param string $fields Array
* @param string $mode String
* @param string $size Integer
* @return string
*/
function csvstr(array $fields, $mode='+', int $size=1) : string {
//$fp = fopen('php://memory', 'r'.$dbtable_mode); # ALT
$sizeMBs = $size * 1024 * 1024;
// output upto 1MB is kept in memory,
// if it becomes bigger it will be written to a temporary file
$fp = fopen("php://temp/maxmemory:$sizeMBs", 'r'.$mode);
if ( fputcsv($fp, $fields) === false ) {
return false;
}
rewind($fp);
$csv_line = stream_get_contents($fp); // string
fclose($fp);
return rtrim($csv_line);
}
if ( ! function_exists('str_getcsv')) {
function str_getcsv($input, $delimiter = ',', $enclosure = '"') {
//return str_getcsv4($input, $delimiter, $enclosure); //OLDER
return str_getcsv4a($input, $delimiter, $enclosure); //NEWER
}
}
|
