3 回答

TA贡献2019条经验 获得超9个赞
请尝试以下代码。它正在工作。
<?php
function readCSV($csvFile)
{
$line_of_text = [];
$file_handle = fopen($csvFile, 'r');
while (!feof($file_handle)) {
$tmp = fgetcsv($file_handle, 1024);
if (isset($line_of_text[$tmp[0]])) {
foreach ($tmp as $k => $v) {
if (array_key_exists($k, $line_of_text[$tmp[0]])) {
if (!is_array($line_of_text[$tmp[0]][$k])) {
$kVal = $line_of_text[$tmp[0]][$k];
$line_of_text[$tmp[0]][$k] = [];
$line_of_text[$tmp[0]][$k][] = $kVal;
}
$line_of_text[$tmp[0]][$k][] = $v;
$line_of_text[$tmp[0]][$k] = array_unique($line_of_text[$tmp[0]][$k]);
$line_of_text[$tmp[0]][$k] = array_filter($line_of_text[$tmp[0]][$k]);
if (count($line_of_text[$tmp[0]][$k]) == 1) {
$line_of_text[$tmp[0]][$k] = array_values($line_of_text[$tmp[0]][$k]);
$line_of_text[$tmp[0]][$k] = $line_of_text[$tmp[0]][$k][0];
}
if (empty($line_of_text[$tmp[0]][$k])) {
$line_of_text[$tmp[0]][$k] = null;
}
} else {
$line_of_text[$tmp[0]][$k] = null;
}
}
$line_of_text[$tmp[0]][0] = $tmp[0];
} else {
$line_of_text[$tmp[0]] = $tmp;
}
}
fclose($file_handle);
return array_filter(array_values($line_of_text));
}
// Set path to CSV file
$csvFile = 'test.csv';
$csv = readCSV($csvFile);
echo "<pre>";
print_r($csv);
?>
=> 输出
Array
(
[0] => Array
(
[0] => 15304
[1] => 15-04478-27247
[2] => ersmith0
[3] => eric smith
[4] => myemail@gmail.com
[5] =>
[6] => 2 Any Close
[7] =>
[8] => Manchester
[9] => Greater Manchester
[10] => M1 5BB
[11] => United Kingdom
[12] => eric smith
[13] => +44 7719 123456
[14] => 27 Any Close
[15] =>
[16] => Manchester
[17] => Greater Manchester
[18] => M1 5BB
[19] => United Kingdom
[20] => Array
(
[0] => 302804801330
[1] => 302804815489
)
[21] => Array
(
[0] => CAUTION DRIVEN BY A BIKER - Fun Vinyl Decal Sticker 4x4/Car/Lorry/Van/Camper
[1] => Warning Biker With an Attitude Annoy At Your Own Risk Car Vinyl Decal Sticker
)
[22] =>
[23] => No
[24] => Array
(
[0] => 2
[1] => 1
)
[25] => Array
(
[0] => £3.90
[1] => £1.95
)
[26] => £0.00
[27] =>
[28] => £0.00
[29] => £0.00
[30] => £3.90
[31] => No
[32] => PayPal
[33] => 30-Jan-20
[34] => 30-Jan-20
[35] =>
[36] =>
[37] =>
[38] => 31-Jan-20
[39] => No
[40] =>
[41] =>
[42] => 5LD0123456789U
[43] => Royal Mail 1st Class
[44] =>
[45] => Array
(
[0] => 1711351782020
[1] => 1711351781020
)
[46] =>
[47] => No
[48] =>
[49] => No
[50] =>
[51] => No
)
[1] => Array
(
[0] => 15305
[1] => 25-04445-36722
[2] => pod69
[3] => mart badger
[4] => martsemailddr34@gmail.com
[5] =>
[6] => Via Riccione N. 35/30
[7] =>
[8] => Sa Tiacca Quartu S. Elena
[9] => CA
[10] => 09445
[11] => Italy
[12] => Badger Mart
[13] => +39 987 654 3211
[14] => Via Riccione N. 35/30
[15] =>
[16] => Sa Tiacca Quartu S. Elena
[17] => CA
[18] => 09445
[19] => Italy
[20] => 302667176336
[21] => 2x Funny Car & Van or Camper WV Eyelash Vinyl Sticker Decal, Signs - Any Colour!
[22] =>
[23] => No
[24] => 2
[25] => £1.99
[26] => £3.14
[27] =>
[28] => £0.00
[29] => £0.00
[30] => £7.12
[31] => No
[32] => PayPal
[33] => 23-Jan-20
[34] => 23-Jan-20
[35] => 24-Jan-20
[36] =>
[37] =>
[38] => 24-Jan-20
[39] => Yes
[40] =>
[41] =>
[42] => 25C157351T6888860U
[43] => Royal Mail International Standard
[44] =>
[45] => 1709118816020
[46] =>
[47] => No
[48] =>
[49] => No
[50] =>
[51] => No
)
[2] => Array
(
[0] => 15306
[1] => 20-04482-41274
[2] => wideboiy38887
[3] => Paul Lastname
[4] => wideboiysemail@hotmail.co.uk
[5] => Yellow please
[6] => 10
[7] => Broomstick Lane
[8] => Okehampton
[9] => Devon
[10] => EX19 2FT
[11] => United Kingdom
[12] => Paul Lastname
[13] => +44 7866 401983
[14] => 105
[15] => Broomstick Lane
[16] => Okehampton
[17] => Devon
[18] => EX19 2FT
[19] => United Kingdom
[20] => 302755568952
[21] => Junglist Soldier Car Window Laptop Wall Gift Drum Bass dnb Jungle Vinyl Sticker
[22] =>
[23] => No
[24] => 1
[25] => £1.99
[26] => £0.00
[27] =>
[28] => £0.00
[29] => £0.00
[30] => £1.99
[31] => No
[32] => PayPal
[33] => 01-Feb-20
[34] => 01-Feb-20
[35] => 03-Feb-20
[36] =>
[37] =>
[38] =>
[39] => No
[40] =>
[41] =>
[42] => 7SD68673EE789782X
[43] => Royal Mail 1st Class
[44] =>
[45] => 1711667179020
[46] =>
[47] => No
[48] =>
[49] => No
[50] =>
[51] => No
)
)

TA贡献1835条经验 获得超7个赞
您可以像这样处理数组
$arr = [];
//$csv is your array
foreach($csv as $key => $value){
$arr[$value[0]][] = $value;
}
print_r($arr);
此代码将附加所有具有相同第 [0] 索引的嵌套数组。
然后您可以使用其他 php 函数来使您的数组独一无二。
如果你想要一个合并数组的结果,你可以尝试下面的代码。
$arr = [];
//$csv is your array
foreach($csv as $key => $value){
if(!array_key_exists($value[0],$arr)){
$arr[$value[0]] = [];
}
$arr[$value[0]] = array_merge($arr[$value[0]],$value);
}
print_r($arr);
我还没有测试过代码,所以如果有任何错误请更正。

TA贡献1852条经验 获得超7个赞
如果发生以下情况,我认为这可能会导致与您喜欢的不同:
假设我们有 3 条这样的记录:
$original = [0] => [
[0] => 'id0',
[1] => 'name 0',
[2] => 'street 0'
],
[1] => [
[0] => 'id0',
[1] => 'name 1',
[2] =>
],
[2] => [
[0] => 'id0',
[1] =>,
[2] => 'street 2'
]
如果我遵循我认为你的意思,你最终会得到以下结构:
$new = [0] => [
[0] => 'id0',
[1] => [
[0] => 'name 0',
[1] => 'name 1'
],
[2] => [
[0] => 'street 0',
[1] => 'street 2'
]
]
你能看到 $new[0][1][1] 来自 $original[1][1],而在数组 $new[0][2][1] 的相同位置来自 $original[ 2][2]
我认为问题在于您现在将 $original[X][1] 与 $original[X][2] 对齐,如果您在某种表格/概览中打印它们最终彼此相邻但不相关。
==
至于如何解决你的问题,我会建议这样的事情:
function readCsv($csvFileName) {
$file_handle = fopen($csvFile, 'r');
$records = [];
fgetcsv($file_handle);
while (!feof($file_handle) ) {
$line = fgetcsv($file_handle, 1024);
$id = $line[0];
if (!$records[$id]) $records[$id] = [];
$records[$id][] = $line;
}
fclose($file_handle);
return $records;
}
function printCsvColumn($rowName, $sales) {
$uniqueSales = array_unique($sales);
$uniqueNotNullSales = array_filter($uniqueSales, 'strlen');
foreach ($uniqueNotNullSales as $sale) {
echo $rowName . ': ' . $sale[$rowName];
}
}
function printCsv($records) {
foreach ($records as $sales) {
foreach ($sales[0] as $rowName=>$rowValue) {
printCsvColumn($rowName, $sales);
}
}
}
如果您了解 OOP,您可以创建类和对象来为您表示此逻辑,这样您就不会以这种函数式的方式获取和迭代整个代码中的数据。
- 3 回答
- 0 关注
- 102 浏览
添加回答
举报