回答編集履歴
2
こちらかがいいかも
test
CHANGED
|
@@ -16,29 +16,33 @@
|
|
|
16
16
|
|
|
17
17
|
// テーブルからカラム情報取得
|
|
18
18
|
|
|
19
|
+
//$column_XXXの部分は省略させていただきます。
|
|
20
|
+
|
|
21
|
+
|
|
22
|
+
|
|
19
23
|
$column = "show full columns from ".$table_name;
|
|
20
24
|
|
|
21
25
|
$column_data = $dbh->query($column);
|
|
22
26
|
|
|
23
27
|
foreach($column_data as $value){
|
|
24
28
|
|
|
25
|
-
$column_
|
|
29
|
+
$column_XXX = $value[0];//Field
|
|
26
30
|
|
|
27
|
-
$column_
|
|
31
|
+
$column_XXX = $value[1];//Type
|
|
28
32
|
|
|
29
|
-
$column_
|
|
33
|
+
$column_XXX = $value[2];//Collation
|
|
30
34
|
|
|
31
|
-
$column_
|
|
35
|
+
$column_XXX = $value[3];//Null
|
|
32
36
|
|
|
33
|
-
$column_
|
|
37
|
+
$column_XXX = $value[4];//Key
|
|
34
38
|
|
|
35
|
-
$column_
|
|
39
|
+
$column_XXX = $value[5];//Default
|
|
36
40
|
|
|
37
|
-
$column_
|
|
41
|
+
$column_XXX = $value[6];//Extra
|
|
38
42
|
|
|
39
|
-
$column_
|
|
43
|
+
$column_XXX = $value[7];//Privileges
|
|
40
44
|
|
|
41
|
-
$column_
|
|
45
|
+
$column_XXX = $value[8];//★★ここがcomment
|
|
42
46
|
|
|
43
47
|
}
|
|
44
48
|
|
1
こちらかがいいかも
test
CHANGED
|
@@ -22,23 +22,23 @@
|
|
|
22
22
|
|
|
23
23
|
foreach($column_data as $value){
|
|
24
24
|
|
|
25
|
-
$column_
|
|
25
|
+
$column_data [] = $value[0];//Field
|
|
26
26
|
|
|
27
|
-
$column_t
|
|
27
|
+
$column_data [] = $value[1];//Type
|
|
28
28
|
|
|
29
|
-
$column_
|
|
29
|
+
$column_data [] = $value[2];//Collation
|
|
30
30
|
|
|
31
|
-
$column_t
|
|
31
|
+
$column_data [] = $value[3];//Null
|
|
32
32
|
|
|
33
|
-
$column_t
|
|
33
|
+
$column_data [] = $value[4];//Key
|
|
34
34
|
|
|
35
|
-
$column_
|
|
35
|
+
$column_data [] = $value[5];//Default
|
|
36
36
|
|
|
37
|
-
$column_t
|
|
37
|
+
$column_data [] = $value[6];//Extra
|
|
38
38
|
|
|
39
|
-
$column_
|
|
39
|
+
$column_data [] = $value[7];//Privileges
|
|
40
40
|
|
|
41
|
-
$column_t
|
|
41
|
+
$column_data [] = $value[8];//★★ここがcomment
|
|
42
42
|
|
|
43
43
|
}
|
|
44
44
|
|