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