回答編集履歴
2
こちらかがいいかも
answer
CHANGED
|
@@ -7,17 +7,19 @@
|
|
|
7
7
|
|
|
8
8
|
```PHP
|
|
9
9
|
// テーブルからカラム情報取得
|
|
10
|
+
//$column_XXXの部分は省略させていただきます。
|
|
11
|
+
|
|
10
12
|
$column = "show full columns from ".$table_name;
|
|
11
13
|
$column_data = $dbh->query($column);
|
|
12
14
|
foreach($column_data as $value){
|
|
13
|
-
$
|
|
15
|
+
$column_XXX = $value[0];//Field
|
|
14
|
-
$
|
|
16
|
+
$column_XXX = $value[1];//Type
|
|
15
|
-
$
|
|
17
|
+
$column_XXX = $value[2];//Collation
|
|
16
|
-
$
|
|
18
|
+
$column_XXX = $value[3];//Null
|
|
17
|
-
$
|
|
19
|
+
$column_XXX = $value[4];//Key
|
|
18
|
-
$
|
|
20
|
+
$column_XXX = $value[5];//Default
|
|
19
|
-
$
|
|
21
|
+
$column_XXX = $value[6];//Extra
|
|
20
|
-
$
|
|
22
|
+
$column_XXX = $value[7];//Privileges
|
|
21
|
-
$
|
|
23
|
+
$column_XXX = $value[8];//★★ここがcomment
|
|
22
24
|
}
|
|
23
25
|
```
|
1
こちらかがいいかも
answer
CHANGED
|
@@ -10,14 +10,14 @@
|
|
|
10
10
|
$column = "show full columns from ".$table_name;
|
|
11
11
|
$column_data = $dbh->query($column);
|
|
12
12
|
foreach($column_data as $value){
|
|
13
|
+
$column_data [] = $value[0];//Field
|
|
14
|
+
$column_data [] = $value[1];//Type
|
|
15
|
+
$column_data [] = $value[2];//Collation
|
|
16
|
+
$column_data [] = $value[3];//Null
|
|
13
|
-
$
|
|
17
|
+
$column_data [] = $value[4];//Key
|
|
14
|
-
$
|
|
18
|
+
$column_data [] = $value[5];//Default
|
|
15
|
-
$
|
|
19
|
+
$column_data [] = $value[6];//Extra
|
|
16
|
-
$column_type[] = $value[3];
|
|
17
|
-
$column_type[] = $value[4];
|
|
18
|
-
$column_name[] = $value[5];
|
|
19
|
-
$column_type[] = $value[6];
|
|
20
|
-
$
|
|
20
|
+
$column_data [] = $value[7];//Privileges
|
|
21
|
-
$
|
|
21
|
+
$column_data [] = $value[8];//★★ここがcomment
|
|
22
22
|
}
|
|
23
23
|
```
|