回答編集履歴
1
修正
answer
CHANGED
|
@@ -1,16 +1,23 @@
|
|
|
1
1
|
とりあえずざっと走査すればよいような
|
|
2
2
|
|
|
3
|
+
//test.csv
|
|
4
|
+
```csv
|
|
5
|
+
"a","b","c","d","e","f","g"
|
|
6
|
+
"高橋","10","2","1","20","5","3"
|
|
7
|
+
"佐藤","15","4","3","21","7","4"
|
|
8
|
+
"鈴木","12","5","2","22","5","5"
|
|
9
|
+
"中村","14","6","4","44","8","6"
|
|
10
|
+
"国分","15","3","5","22","9","3"
|
|
11
|
+
"鈴木","16","4","6","18","3","1"
|
|
12
|
+
```
|
|
13
|
+
|
|
3
14
|
```PHP
|
|
4
15
|
<?PHP
|
|
16
|
+
$fp=fopen("test.csv","r");
|
|
17
|
+
while (($d = fgetcsv($fp, 1000, ",")) !== FALSE) {
|
|
5
|
-
$data
|
|
18
|
+
$data[]=$d;
|
|
6
|
-
["a","b","c","d","e","f","g"],
|
|
7
|
-
["高橋","10","2","1","20","5","3"],
|
|
8
|
-
["佐藤","15","4","3","21","7","4"],
|
|
9
|
-
["鈴木","12","5","2","22","5","5"],
|
|
10
|
-
["中村","14","6","4","44","8","6"],
|
|
11
|
-
["国分","15","3","5","22","9","3"],
|
|
12
|
-
["鈴木","16","4","6","18","3","1"],
|
|
13
|
-
|
|
19
|
+
}
|
|
20
|
+
fclose($fp);
|
|
14
21
|
function vlookup($data,$name,$col,$flg){
|
|
15
22
|
$ret=[];
|
|
16
23
|
foreach($data as $vals){
|
|
@@ -29,6 +36,8 @@
|
|
|
29
36
|
?>
|
|
30
37
|
```
|
|
31
38
|
※ファイル化配列への取り込みはfgetcsvなどご利用ください
|
|
39
|
+
→fgetcsv用にソースを修正しておきました
|
|
40
|
+
|
|
32
41
|
"v"の仕様が提示されてないので省略しました
|
|
33
42
|
最短取得・全取得はどちらがtureかわからなかったので
|
|
34
43
|
とりあえず最短取得=trueとしてあります
|