我讀了一個(gè) csv 文件并得到了這個(gè)數(shù)組 $rowsArray( [0] => Array ( [0] => Name [1] => Company [2] => Email [3] => City )[1] => Array ( [0] => Foo [1] => Foo & co [2] => foo@mail.com [3] => NY )[2] => Array ( [0] => Bar [1] => Bar & co [2] => bar@mail.com [3] => Las Vegas ))我會(huì)嘗試通過(guò)僅過(guò)濾第一個(gè)數(shù)組中包含的某些字段來(lái)將其轉(zhuǎn)換為關(guān)聯(lián)數(shù)組。結(jié)果應(yīng)該是這樣Array([0] => Array ( ['Name'] => Foo ['Company'] => Foo & co ['Email] => foo@mail.com ) [1] => Array ( ['Name'] => Bar ['Company'] => Bar & co ['Email] => bar@mail.com ))不幸的是，我以各種方式嘗試過(guò)，但沒(méi)有成功。$name = array_search('Name', $rows[0]);$company = array_search('Company', $rows[0]);$email = array_search('Email', $rows[0]);$rows = unset($rows[0]);$array = array();foreach ( $rows as $r => $row ) { foreach ( $row as $c => $cell ) { if ($c == $name) { $array = array( 'name' => $cell ); } if ($c == $company) { $array = array( 'company' => $cell ); } if ($c == $email) { $array = array( 'email' => $cell ); } }}你能給我一些建議嗎？謝謝
2 回答
白衣染霜花
TA貢獻(xiàn)1796條經(jīng)驗(yàn) 獲得超10個(gè)贊
你可以試試下面的代碼。它將基于 csv 文件使該動(dòng)態(tài)的標(biāo)題名稱和值。
$header = array();
foreach($array as $key=>$value){
if($key == 0){
$header = array_values($value);
}else{
$final_result[]= array_combine($header, array_values($value));
}
}
echo "<pre>";
print_r($final_result);
小怪獸愛(ài)吃肉
TA貢獻(xiàn)1852條經(jīng)驗(yàn) 獲得超1個(gè)贊
在閱讀文件時(shí)嘗試構(gòu)建您想要的內(nèi)容，而不必重新排列您一開(kāi)始不想要的內(nèi)容。
// loose the titles line
fgetcsv($file, 1000, ',')
$rows= [];
while ( $line = fgetcsv($file, 1000, ',') !== FALSE) {
$rows[] = ['Name'=> $line[0], 'Company'=> $line[1], 'Email'=> $line[2] ];
}
- 2 回答
- 0 關(guān)注
- 190 瀏覽
添加回答
舉報(bào)
0/150
提交
取消