質問編集履歴
1
コード追加
test
CHANGED
File without changes
|
test
CHANGED
@@ -122,14 +122,14 @@
|
|
122
122
|
|
123
123
|
現状
|
124
124
|
|
125
|
+
![イメージ説明](58317f252d3550977f1ca76c10f6702e.png)
|
126
|
+
|
125
|
-
![イメージ説明](
|
127
|
+
![イメージ説明](092d3acc3d29512065a34f1c4a8b70ee.png)
|
126
128
|
|
127
129
|
```ここに言語を入力
|
128
130
|
|
129
131
|
controller
|
130
132
|
|
131
|
-
|
132
|
-
|
133
133
|
<?php
|
134
134
|
|
135
135
|
class EntityController extends AppController {
|
@@ -160,13 +160,29 @@
|
|
160
160
|
|
161
161
|
}
|
162
162
|
|
163
|
+
|
164
|
+
|
165
|
+
public function entity_tbl($db_id){
|
166
|
+
|
167
|
+
$this->Entity->setDataSource('hive');
|
168
|
+
|
169
|
+
$sql ="select * from TBLS where DB_ID =$db_id;";
|
170
|
+
|
171
|
+
$result= $this->Entity->query($sql);
|
172
|
+
|
173
|
+
$this->set('para', $result);
|
174
|
+
|
175
|
+
}
|
176
|
+
|
177
|
+
|
178
|
+
|
163
179
|
}
|
164
180
|
|
165
181
|
```
|
166
182
|
|
167
183
|
```
|
168
184
|
|
169
|
-
ctp
|
185
|
+
index.ctp
|
170
186
|
|
171
187
|
|
172
188
|
|
@@ -196,14 +212,72 @@
|
|
196
212
|
|
197
213
|
<li><?php echo h($name['DBS']['NAME']) ?></li>
|
198
214
|
|
215
|
+
<?php $db_id=$name['DBS']['DB_ID'] ?>
|
216
|
+
|
217
|
+
<!--<?php debug($db_id); ?>-->
|
218
|
+
|
199
219
|
<?php endforeach; ?>
|
200
220
|
|
201
221
|
</ul>
|
202
222
|
|
223
|
+
|
224
|
+
|
225
|
+
<?php echo $this->Html->link('テーブル一覧',array('action'=>'entity_tbl',$name['DBS']['DB_ID'])); ?>
|
226
|
+
|
227
|
+
|
228
|
+
|
229
|
+
|
230
|
+
|
203
231
|
</body>
|
204
232
|
|
205
233
|
</html>
|
206
234
|
|
235
|
+
```
|
236
|
+
|
237
|
+
```ここに言語を入力
|
238
|
+
|
239
|
+
entiti_tbl.ctp
|
240
|
+
|
241
|
+
|
242
|
+
|
243
|
+
<!DOCTYPE html>
|
244
|
+
|
245
|
+
<html>
|
246
|
+
|
247
|
+
<head>
|
248
|
+
|
249
|
+
<meta charset="utf-8">
|
250
|
+
|
251
|
+
<meta http-equiv="X-UA-Compatible" content="IE=edge">
|
252
|
+
|
253
|
+
<title></title>
|
254
|
+
|
255
|
+
<link rel="stylesheet" href="">
|
256
|
+
|
257
|
+
</head>
|
258
|
+
|
259
|
+
<body>
|
260
|
+
|
261
|
+
<h2>テーブル一覧</h2>
|
262
|
+
|
263
|
+
<ul>
|
264
|
+
|
265
|
+
<?php foreach($para as $name): ?>
|
266
|
+
|
267
|
+
<li><?php echo h($name['TBLS']['TBL_NAME']) ?></li>
|
268
|
+
|
269
|
+
<!--<?php $db_id=$name['DBS']['DB_ID'] ?>-->
|
270
|
+
|
271
|
+
<!--<?php debug($db_id); ?>-->
|
272
|
+
|
273
|
+
<?php endforeach; ?>
|
274
|
+
|
275
|
+
</ul>
|
276
|
+
|
277
|
+
</body>
|
278
|
+
|
279
|
+
</html>
|
280
|
+
|
207
281
|
|
208
282
|
|
209
283
|
```
|