質問編集履歴

4

セキュリティの関わる問題なので削除させていただきました。

2018/06/18 10:18

投稿

amaguri
amaguri

スコア227

test CHANGED
@@ -1 +1 @@
1
- cakephp conntrollerしたデータがlayoutでprintで表示されない
1
+ セキュリティの関わる問題なの削除させていただきました
test CHANGED
@@ -1,399 +1 @@
1
- やりたいこと
2
-
3
- conntorollerで処理したデータをlayoutで表示したい。
4
-
5
-
6
-
7
- 取得したデータはこちらになります。
8
-
9
- controller側でのデータの取得はできています。
10
-
11
- ```ここに言語を入力
12
-
13
- app/controllers/entity_controller.php (line 120)
14
-
15
- default
16
-
17
- app/controllers/entity_controller.php (line 120)
18
-
19
- temp
20
-
21
- app/controllers/entity_controller.php (line 120)
22
-
23
- infra
24
-
25
- app/controllers/entity_controller.php (line 120)
26
-
27
- tpcds_text_10
28
-
29
- app/controllers/entity_controller.php (line 120)
30
-
31
- tpcds_bin_partitioned_orc_10
32
-
33
- app/controllers/entity_controller.php (line 120)
34
-
35
- tpcds_text_100
36
-
37
- app/controllers/entity_controller.php (line 120)
38
-
39
- tpcds_bin_partitioned_orc_100
40
-
41
- app/controllers/entity_controller.php (line 120)
42
-
43
- tpcds_text_1000
44
-
45
- app/controllers/entity_controller.php (line 120)
46
-
47
-
48
-
49
- ```
50
-
51
-
52
-
53
- ```ここに言語を入力
54
-
55
- <html>
56
-
57
- <head>
58
-
59
- <title>hive configuration</title>
60
-
61
- <link href="/WebHive/css/main.css" rel="stylesheet">
62
-
63
- </head>
64
-
65
-
66
-
67
- <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" >
68
-
69
- <a name='page_top'></a>
70
-
71
-
72
-
73
- <?php echo $this->element('banner'); ?>
74
-
75
-
76
-
77
- <table width="100%" height="100%" cellspacing="0" cellpadding="0">
78
-
79
- <tr height="5" bgcolor="#dfe9f6" class="noprint">
80
-
81
- <td colspan="2">
82
-
83
- <table width="100%">
84
-
85
- <tr>
86
-
87
- <td align="left">
88
-
89
- <?php echo APP_TITLE ?><?php echo $app_title_msg; ?>
90
-
91
- </td>
92
-
93
- <td align="right">
94
-
95
- <?php echo $user['User']['username']."さん"; ?>&nbsp;&nbsp;
96
-
97
- |<a href='/WebHive/users/logout'>LOGOUT</a>
98
-
99
- |<a href='/WebHive/'>WebHive</a>
100
-
101
- |<a href="/WebHive/help" onclick="window.open('/WebHive/help','_blank','width=900,height=500,scrollbars=yes'); return false;">変更履歴</a>|
102
-
103
- </td>
104
-
105
- </tr>
106
-
107
- </table>
108
-
109
- </td>
110
-
111
- </tr>
112
-
113
- <tr class="noprint">
114
-
115
- <td bgcolor="#efefef" colspan="1" height="8" style="background-image: url(/WebHive/img/shadow_gray.gif); background-repeat: repeat-x; border-right: #aaaaaa 1px solid;">
116
-
117
- <img src="/WebHive/img/transparent_line.gif" width="200" height="2" border="0"><br>
118
-
119
- </td>
120
-
121
- <td bgcolor="#ffffff" colspan="1" height="8" style="background-image: url(/WebHive/img/shadow.gif); background-repeat: repeat-x;">
122
-
123
- </td>
124
-
125
- </tr>
126
-
127
-
128
-
129
-
130
-
131
- <tr>
132
-
133
- <td valign="top" style="padding: 5px; border-right: #aaaaaa 1px solid;">
134
-
135
- <script type="text/javascript">
136
-
137
- <!--
138
-
139
- function applyGraphPreviewFilterChange(objForm) {
140
-
141
- strURL = '?action=preview';
142
-
143
- strURL = strURL + '&database_id=' + objForm.database_id.value;
144
-
145
- strURL = strURL + '&table_id=' + objForm.table_id.value;
146
-
147
- strURL = strURL + '&filter=' + objForm.filter.value;
148
-
149
- document.location = strURL;
150
-
151
- }
152
-
153
- -->
154
-
155
- </script>
156
-
157
- <table width='100%' style='background-color: #f5f5f5; border: 1px solid #bbbbbb;' align='center' cellpadding='3'>
158
-
159
- <tr bgcolor="E5E5E5" class="noprint">
160
-
161
- <form name="form_graph_view" method="post">
162
-
163
- <td class="noprint">
164
-
165
- <table width="100%" cellpadding="0" cellspacing="0">
166
-
167
-
168
-
169
- <tr class="noprint">
170
-
171
- <td nowrap style='white-space: nowrap;' width="40">
172
-
173
- &nbsp;<strong>Database:</strong>&nbsp;
174
-
175
- </td>
176
-
177
- <td width="1">
178
-
179
- <select name="database_id" onChange="applyGraphPreviewFilterChange(document.form_graph_view)">
180
-
181
- <?php
182
-
183
- foreach($dbs as $name){
184
-
185
- $p_database=$name['DBS']['NAME'];
186
-
187
- $para['database']=$p_database;
188
-
189
- debug($para['database']);
190
-
191
- }
192
-
193
- print($para['database']);
194
-
195
- ?>
196
-
197
- </select>
198
-
199
- </td>
200
-
201
- <td nowrap style='white-space: nowrap;' width="40">
202
-
203
- &nbsp;<strong>Table:</strong>&nbsp;
204
-
205
- </td>
206
-
207
- <td width="1">
208
-
209
- <select name="table_id" onChange="applyGraphPreviewFilterChange(document.form_graph_view)">
210
-
211
- <?php print($para['table']); ?>
212
-
213
- </select>
214
-
215
- </td>
216
-
217
-
218
-
219
- <td nowrap style='white-space: nowrap;' width="50">
220
-
221
- &nbsp;&nbsp;<strong>&nbsp;Filter:</strong>&nbsp;
222
-
223
- </td>
224
-
225
- <td width="1">
226
-
227
- <input type="text" name="filter" size="40" value="<?php print($para['filter']); ?>">
228
-
229
- </td>
230
-
231
-
232
-
233
- <td style='white-space:nowrap;' nowrap>
234
-
235
- &nbsp;<input type="image" src="/WebHive/img/button_go.gif" alt="Go" border="0" align="absmiddle">
236
-
237
- <input type="image" src="/WebHive/img/button_clear.gif" name="clear" alt="Clear" border="0" align="absmiddle">
238
-
239
- </td>
240
-
241
- <td nowrap style='white-space: nowrap;' width="10">
242
-
243
- <a href="/WebHive/entity/download?database_id=<?php print($para['database_id']); ?>">DOWNLOAD</a>
244
-
245
- </td>
246
-
247
- </tr>
248
-
249
- </table>
250
-
251
- </td>
252
-
253
- </form>
254
-
255
- </tr>
256
-
257
-
258
-
259
- </table><table width='100%' style='background-color: #f5f5f5; border: 1px solid #bbbbbb;' align='center' cellpadding='3'>
260
-
261
- </table><br>
262
-
263
- <table width='100%' style='background-color: #f5f5f5; border: 1px solid #bbbbbb;' align='center' cellpadding='1'>
264
-
265
- <tr bgcolor='#17385b' class='noprint'>
266
-
267
- <td colspan='2'>
268
-
269
- <table width='100%' cellspacing='0' cellpadding='3' border='0'>
270
-
271
- <tr>
272
-
273
- <td align='left' class='textHeaderDark' width='15%'>
274
-
275
- <?php print($para['previous']); ?>
276
-
277
- </td>
278
-
279
- <td align='center' class='textHeaderDark' width='70%'>
280
-
281
- <?php print($para['rows']); ?>
282
-
283
- </td>
284
-
285
- <td align='right' class='textHeaderDark' width='15%'>
286
-
287
- <?php print($para['next']); ?>
288
-
289
- </td>
290
-
291
- </tr>
292
-
293
- </table>
294
-
295
- </td>
296
-
297
- </tr>
298
-
299
-
300
-
301
- <tr style='background-color: #F2F2F2;'>
302
-
303
- <td align='center' width='100%'>
304
-
305
- <table align='center' cellpadding='0' width='100%'>
306
-
307
- <tr>
308
-
309
- <td align='center'>
310
-
311
- <?php print($para['data']); ?>
312
-
313
- </td>
314
-
315
- </tr>
316
-
317
- </table>
318
-
319
- </td>
320
-
321
- <td align='center' width='50%'>
322
-
323
- </td>
324
-
325
- </tr>
326
-
327
-
328
-
329
- <tr bgcolor='#17385b' class='noprint'>
330
-
331
- <td colspan='2'>
332
-
333
- <table width='100%' cellspacing='0' cellpadding='3' border='0'>
334
-
335
- <tr>
336
-
337
- <td align='left' class='textHeaderDark' width='15%'>
338
-
339
- <?php print($para['previous']); ?>
340
-
341
- </td>
342
-
343
- <td align='center' class='textHeaderDark' width='70%'>
344
-
345
- <?php print($para['rows']); ?>
346
-
347
- </td>
348
-
349
- <td align='right' class='textHeaderDark' width='15%'>
350
-
351
- <?php print($para['next']); ?>
352
-
353
- </td>
354
-
355
- </tr>
356
-
357
- </table>
358
-
359
- </td>
360
-
361
- </tr>
362
-
363
- </table> <br>
364
-
365
- </td>
366
-
367
- </tr>
368
-
369
- </table>
370
-
371
-
372
-
373
- </body>
374
-
375
- </html>
376
-
377
- ```
378
-
379
- 下記部分でデータの表示がていません
1
+ セキュリティ関わる問題なので削除させていただきした
380
-
381
- ```ここに言語を入力
382
-
383
- <?php
384
-
385
- foreach($dbs as $name){
386
-
387
- $p_database=$name['DBS']['NAME'];
388
-
389
- $para['database']=$p_database;
390
-
391
- debug($para['database']);
392
-
393
- }
394
-
395
- print($para['database']);
396
-
397
- ?>
398
-
399
- ```

3

修正

2018/06/18 10:18

投稿

amaguri
amaguri

スコア227

test CHANGED
@@ -1 +1 @@
1
- cakephp conntrollerで渡したデータがlayoutで表示されない
1
+ cakephp conntrollerで渡したデータがlayoutでprintで表示されない
test CHANGED
@@ -378,8 +378,6 @@
378
378
 
379
379
  下記の部分でのデータの表示ができていません。
380
380
 
381
- this->setで渡しているのですがうまくデータが渡せていないんでしょうか?
382
-
383
381
  ```ここに言語を入力
384
382
 
385
383
  <?php

2

修正

2016/10/25 04:05

投稿

amaguri
amaguri

スコア227

test CHANGED
@@ -1 +1 @@
1
- cakephp layoutで表示されない
1
+ cakephp conntrollerで渡したデータがlayoutで表示されない
test CHANGED
@@ -2,428 +2,400 @@
2
2
 
3
3
  conntorollerで処理したデータをlayoutで表示したい。
4
4
 
5
+
6
+
7
+ 取得したデータはこちらになります。
8
+
9
+ controller側でのデータの取得はできています。
10
+
5
11
  ```ここに言語を入力
6
12
 
7
- <select name="database_id" onChange="applyGraphPreviewFilterChange(document.form_graph_view)">
8
-
9
- <?php print($para['database']); ?>
13
+ app/controllers/entity_controller.php (line 120)
14
+
15
+ default
16
+
17
+ app/controllers/entity_controller.php (line 120)
18
+
19
+ temp
20
+
21
+ app/controllers/entity_controller.php (line 120)
22
+
23
+ infra
24
+
25
+ app/controllers/entity_controller.php (line 120)
26
+
27
+ tpcds_text_10
28
+
29
+ app/controllers/entity_controller.php (line 120)
30
+
31
+ tpcds_bin_partitioned_orc_10
32
+
33
+ app/controllers/entity_controller.php (line 120)
34
+
35
+ tpcds_text_100
36
+
37
+ app/controllers/entity_controller.php (line 120)
38
+
39
+ tpcds_bin_partitioned_orc_100
40
+
41
+ app/controllers/entity_controller.php (line 120)
42
+
43
+ tpcds_text_1000
44
+
45
+ app/controllers/entity_controller.php (line 120)
46
+
47
+
10
48
 
11
49
  ```
12
50
 
13
- の部分が表示されませんなぜでしょうか?
51
+
14
-
15
- 取得したデータはこちらになります。
16
-
17
- データの取得はできています。
18
52
 
19
53
  ```ここに言語を入力
20
54
 
21
- app/controllers/entity_controller.php (line 120)
22
-
23
- default
24
-
25
- app/controllers/entity_controller.php (line 120)
26
-
27
- temp
28
-
29
- app/controllers/entity_controller.php (line 120)
30
-
31
- infra
32
-
33
- app/controllers/entity_controller.php (line 120)
34
-
35
- tpcds_text_10
36
-
37
- app/controllers/entity_controller.php (line 120)
38
-
39
- tpcds_bin_partitioned_orc_10
40
-
41
- app/controllers/entity_controller.php (line 120)
42
-
43
- tpcds_text_100
44
-
45
- app/controllers/entity_controller.php (line 120)
46
-
47
- tpcds_bin_partitioned_orc_100
48
-
49
- app/controllers/entity_controller.php (line 120)
50
-
51
- tpcds_text_1000
52
-
53
- app/controllers/entity_controller.php (line 120)
54
-
55
-
55
+ <html>
56
+
57
+ <head>
58
+
59
+ <title>hive configuration</title>
60
+
61
+ <link href="/WebHive/css/main.css" rel="stylesheet">
62
+
63
+ </head>
64
+
65
+
66
+
67
+ <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" >
68
+
69
+ <a name='page_top'></a>
70
+
71
+
72
+
73
+ <?php echo $this->element('banner'); ?>
74
+
75
+
76
+
77
+ <table width="100%" height="100%" cellspacing="0" cellpadding="0">
78
+
79
+ <tr height="5" bgcolor="#dfe9f6" class="noprint">
80
+
81
+ <td colspan="2">
82
+
83
+ <table width="100%">
84
+
85
+ <tr>
86
+
87
+ <td align="left">
88
+
89
+ <?php echo APP_TITLE ?><?php echo $app_title_msg; ?>
90
+
91
+ </td>
92
+
93
+ <td align="right">
94
+
95
+ <?php echo $user['User']['username']."さん"; ?>&nbsp;&nbsp;
96
+
97
+ |<a href='/WebHive/users/logout'>LOGOUT</a>
98
+
99
+ |<a href='/WebHive/'>WebHive</a>
100
+
101
+ |<a href="/WebHive/help" onclick="window.open('/WebHive/help','_blank','width=900,height=500,scrollbars=yes'); return false;">変更履歴</a>|
102
+
103
+ </td>
104
+
105
+ </tr>
106
+
107
+ </table>
108
+
109
+ </td>
110
+
111
+ </tr>
112
+
113
+ <tr class="noprint">
114
+
115
+ <td bgcolor="#efefef" colspan="1" height="8" style="background-image: url(/WebHive/img/shadow_gray.gif); background-repeat: repeat-x; border-right: #aaaaaa 1px solid;">
116
+
117
+ <img src="/WebHive/img/transparent_line.gif" width="200" height="2" border="0"><br>
118
+
119
+ </td>
120
+
121
+ <td bgcolor="#ffffff" colspan="1" height="8" style="background-image: url(/WebHive/img/shadow.gif); background-repeat: repeat-x;">
122
+
123
+ </td>
124
+
125
+ </tr>
126
+
127
+
128
+
129
+
130
+
131
+ <tr>
132
+
133
+ <td valign="top" style="padding: 5px; border-right: #aaaaaa 1px solid;">
134
+
135
+ <script type="text/javascript">
136
+
137
+ <!--
138
+
139
+ function applyGraphPreviewFilterChange(objForm) {
140
+
141
+ strURL = '?action=preview';
142
+
143
+ strURL = strURL + '&database_id=' + objForm.database_id.value;
144
+
145
+ strURL = strURL + '&table_id=' + objForm.table_id.value;
146
+
147
+ strURL = strURL + '&filter=' + objForm.filter.value;
148
+
149
+ document.location = strURL;
150
+
151
+ }
152
+
153
+ -->
154
+
155
+ </script>
156
+
157
+ <table width='100%' style='background-color: #f5f5f5; border: 1px solid #bbbbbb;' align='center' cellpadding='3'>
158
+
159
+ <tr bgcolor="E5E5E5" class="noprint">
160
+
161
+ <form name="form_graph_view" method="post">
162
+
163
+ <td class="noprint">
164
+
165
+ <table width="100%" cellpadding="0" cellspacing="0">
166
+
167
+
168
+
169
+ <tr class="noprint">
170
+
171
+ <td nowrap style='white-space: nowrap;' width="40">
172
+
173
+ &nbsp;<strong>Database:</strong>&nbsp;
174
+
175
+ </td>
176
+
177
+ <td width="1">
178
+
179
+ <select name="database_id" onChange="applyGraphPreviewFilterChange(document.form_graph_view)">
180
+
181
+ <?php
182
+
183
+ foreach($dbs as $name){
184
+
185
+ $p_database=$name['DBS']['NAME'];
186
+
187
+ $para['database']=$p_database;
188
+
189
+ debug($para['database']);
190
+
191
+ }
192
+
193
+ print($para['database']);
194
+
195
+ ?>
196
+
197
+ </select>
198
+
199
+ </td>
200
+
201
+ <td nowrap style='white-space: nowrap;' width="40">
202
+
203
+ &nbsp;<strong>Table:</strong>&nbsp;
204
+
205
+ </td>
206
+
207
+ <td width="1">
208
+
209
+ <select name="table_id" onChange="applyGraphPreviewFilterChange(document.form_graph_view)">
210
+
211
+ <?php print($para['table']); ?>
212
+
213
+ </select>
214
+
215
+ </td>
216
+
217
+
218
+
219
+ <td nowrap style='white-space: nowrap;' width="50">
220
+
221
+ &nbsp;&nbsp;<strong>&nbsp;Filter:</strong>&nbsp;
222
+
223
+ </td>
224
+
225
+ <td width="1">
226
+
227
+ <input type="text" name="filter" size="40" value="<?php print($para['filter']); ?>">
228
+
229
+ </td>
230
+
231
+
232
+
233
+ <td style='white-space:nowrap;' nowrap>
234
+
235
+ &nbsp;<input type="image" src="/WebHive/img/button_go.gif" alt="Go" border="0" align="absmiddle">
236
+
237
+ <input type="image" src="/WebHive/img/button_clear.gif" name="clear" alt="Clear" border="0" align="absmiddle">
238
+
239
+ </td>
240
+
241
+ <td nowrap style='white-space: nowrap;' width="10">
242
+
243
+ <a href="/WebHive/entity/download?database_id=<?php print($para['database_id']); ?>">DOWNLOAD</a>
244
+
245
+ </td>
246
+
247
+ </tr>
248
+
249
+ </table>
250
+
251
+ </td>
252
+
253
+ </form>
254
+
255
+ </tr>
256
+
257
+
258
+
259
+ </table><table width='100%' style='background-color: #f5f5f5; border: 1px solid #bbbbbb;' align='center' cellpadding='3'>
260
+
261
+ </table><br>
262
+
263
+ <table width='100%' style='background-color: #f5f5f5; border: 1px solid #bbbbbb;' align='center' cellpadding='1'>
264
+
265
+ <tr bgcolor='#17385b' class='noprint'>
266
+
267
+ <td colspan='2'>
268
+
269
+ <table width='100%' cellspacing='0' cellpadding='3' border='0'>
270
+
271
+ <tr>
272
+
273
+ <td align='left' class='textHeaderDark' width='15%'>
274
+
275
+ <?php print($para['previous']); ?>
276
+
277
+ </td>
278
+
279
+ <td align='center' class='textHeaderDark' width='70%'>
280
+
281
+ <?php print($para['rows']); ?>
282
+
283
+ </td>
284
+
285
+ <td align='right' class='textHeaderDark' width='15%'>
286
+
287
+ <?php print($para['next']); ?>
288
+
289
+ </td>
290
+
291
+ </tr>
292
+
293
+ </table>
294
+
295
+ </td>
296
+
297
+ </tr>
298
+
299
+
300
+
301
+ <tr style='background-color: #F2F2F2;'>
302
+
303
+ <td align='center' width='100%'>
304
+
305
+ <table align='center' cellpadding='0' width='100%'>
306
+
307
+ <tr>
308
+
309
+ <td align='center'>
310
+
311
+ <?php print($para['data']); ?>
312
+
313
+ </td>
314
+
315
+ </tr>
316
+
317
+ </table>
318
+
319
+ </td>
320
+
321
+ <td align='center' width='50%'>
322
+
323
+ </td>
324
+
325
+ </tr>
326
+
327
+
328
+
329
+ <tr bgcolor='#17385b' class='noprint'>
330
+
331
+ <td colspan='2'>
332
+
333
+ <table width='100%' cellspacing='0' cellpadding='3' border='0'>
334
+
335
+ <tr>
336
+
337
+ <td align='left' class='textHeaderDark' width='15%'>
338
+
339
+ <?php print($para['previous']); ?>
340
+
341
+ </td>
342
+
343
+ <td align='center' class='textHeaderDark' width='70%'>
344
+
345
+ <?php print($para['rows']); ?>
346
+
347
+ </td>
348
+
349
+ <td align='right' class='textHeaderDark' width='15%'>
350
+
351
+ <?php print($para['next']); ?>
352
+
353
+ </td>
354
+
355
+ </tr>
356
+
357
+ </table>
358
+
359
+ </td>
360
+
361
+ </tr>
362
+
363
+ </table> <br>
364
+
365
+ </td>
366
+
367
+ </tr>
368
+
369
+ </table>
370
+
371
+
372
+
373
+ </body>
374
+
375
+ </html>
56
376
 
57
377
  ```
58
378
 
59
-
379
+ 下記の部分でのデータの表示ができていません。
380
+
381
+ this->setで渡しているのですがうまくデータが渡せていないんでしょうか?
60
382
 
61
383
  ```ここに言語を入力
62
384
 
63
385
  <?php
64
386
 
65
- class EntityController extends AppController {
66
-
67
- var $name = 'Entity';
68
-
69
- var $components = array('RequestHandler','Auth','Common');
70
-
71
- var $user;
72
-
73
-
74
-
75
- function index() {
76
-
77
-
78
-
79
- $this->Entity->setDataSource('hive');
80
-
81
-
82
-
83
- //変数初期化
84
-
85
- $this->layout='entity';
86
-
87
- $p_database="";
88
-
89
-
90
-
91
- //データベース一覧
92
-
93
- $sql ="select * from DBS;";
94
-
95
- $para= $this->Entity->query($sql);
96
-
97
- debug($para);
98
-
99
- foreach($para as $name){
387
+ foreach($dbs as $name){
100
-
388
+
101
- $p_database=$name['DBS']['NAME']
389
+ $p_database=$name['DBS']['NAME'];
102
-
390
+
103
- $para['database']=$p_database;
391
+ $para['database']=$p_database;
104
-
392
+
105
- debug($para['database']);
393
+ debug($para['database']);
106
394
 
107
395
  }
108
396
 
109
-
110
-
111
- $this->set('para', $para);
397
+ print($para['database']);
112
-
113
-
114
-
398
+
115
- }
399
+ ?>
116
400
 
117
401
  ```
118
-
119
- ```ここに言語を入力
120
-
121
- <html>
122
-
123
- <head>
124
-
125
- <title>hive configuration</title>
126
-
127
- <link href="/WebHive/css/main.css" rel="stylesheet">
128
-
129
- </head>
130
-
131
-
132
-
133
- <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" >
134
-
135
- <a name='page_top'></a>
136
-
137
-
138
-
139
- <?php echo $this->element('banner'); ?>
140
-
141
-
142
-
143
- <table width="100%" height="100%" cellspacing="0" cellpadding="0">
144
-
145
- <tr height="5" bgcolor="#dfe9f6" class="noprint">
146
-
147
- <td colspan="2">
148
-
149
- <table width="100%">
150
-
151
- <tr>
152
-
153
- <td align="left">
154
-
155
- <?php echo APP_TITLE ?><?php echo $app_title_msg; ?>
156
-
157
- </td>
158
-
159
- <td align="right">
160
-
161
- <?php echo $user['User']['username']."さん"; ?>&nbsp;&nbsp;
162
-
163
- |<a href='/WebHive/users/logout'>LOGOUT</a>
164
-
165
- |<a href='/WebHive/'>WebHive</a>
166
-
167
- |<a href="/WebHive/help" onclick="window.open('/WebHive/help','_blank','width=900,height=500,scrollbars=yes'); return false;">変更履歴</a>|
168
-
169
- </td>
170
-
171
- </tr>
172
-
173
- </table>
174
-
175
- </td>
176
-
177
- </tr>
178
-
179
- <tr class="noprint">
180
-
181
- <td bgcolor="#efefef" colspan="1" height="8" style="background-image: url(/WebHive/img/shadow_gray.gif); background-repeat: repeat-x; border-right: #aaaaaa 1px solid;">
182
-
183
- <img src="/WebHive/img/transparent_line.gif" width="200" height="2" border="0"><br>
184
-
185
- </td>
186
-
187
- <td bgcolor="#ffffff" colspan="1" height="8" style="background-image: url(/WebHive/img/shadow.gif); background-repeat: repeat-x;">
188
-
189
- </td>
190
-
191
- </tr>
192
-
193
-
194
-
195
-
196
-
197
- <tr>
198
-
199
- <td valign="top" style="padding: 5px; border-right: #aaaaaa 1px solid;">
200
-
201
- <script type="text/javascript">
202
-
203
- <!--
204
-
205
- function applyGraphPreviewFilterChange(objForm) {
206
-
207
- strURL = '?action=preview';
208
-
209
- strURL = strURL + '&database_id=' + objForm.database_id.value;
210
-
211
- strURL = strURL + '&table_id=' + objForm.table_id.value;
212
-
213
- strURL = strURL + '&filter=' + objForm.filter.value;
214
-
215
- document.location = strURL;
216
-
217
- }
218
-
219
- -->
220
-
221
- </script>
222
-
223
- <table width='100%' style='background-color: #f5f5f5; border: 1px solid #bbbbbb;' align='center' cellpadding='3'>
224
-
225
- <tr bgcolor="E5E5E5" class="noprint">
226
-
227
- <form name="form_graph_view" method="post">
228
-
229
- <td class="noprint">
230
-
231
- <table width="100%" cellpadding="0" cellspacing="0">
232
-
233
-
234
-
235
- <tr class="noprint">
236
-
237
- <td nowrap style='white-space: nowrap;' width="40">
238
-
239
- &nbsp;<strong>Database:</strong>&nbsp;
240
-
241
- </td>
242
-
243
- <td width="1">
244
-
245
- <select name="database_id" onChange="applyGraphPreviewFilterChange(document.form_graph_view)">
246
-
247
- <?php print($para['database']); ?>
248
-
249
- </select>
250
-
251
- </td>
252
-
253
- <td nowrap style='white-space: nowrap;' width="40">
254
-
255
- &nbsp;<strong>Table:</strong>&nbsp;
256
-
257
- </td>
258
-
259
- <td width="1">
260
-
261
- <select name="table_id" onChange="applyGraphPreviewFilterChange(document.form_graph_view)">
262
-
263
- <?php print($para['table']); ?>
264
-
265
- </select>
266
-
267
- </td>
268
-
269
-
270
-
271
- <td nowrap style='white-space: nowrap;' width="50">
272
-
273
- &nbsp;&nbsp;<strong>&nbsp;Filter:</strong>&nbsp;
274
-
275
- </td>
276
-
277
- <td width="1">
278
-
279
- <input type="text" name="filter" size="40" value="<?php print($para['filter']); ?>">
280
-
281
- </td>
282
-
283
-
284
-
285
- <td style='white-space:nowrap;' nowrap>
286
-
287
- &nbsp;<input type="image" src="/WebHive/img/button_go.gif" alt="Go" border="0" align="absmiddle">
288
-
289
- <input type="image" src="/WebHive/img/button_clear.gif" name="clear" alt="Clear" border="0" align="absmiddle">
290
-
291
- </td>
292
-
293
- <td nowrap style='white-space: nowrap;' width="10">
294
-
295
- <a href="/WebHive/entity/download?database_id=<?php print($para['database_id']); ?>">DOWNLOAD</a>
296
-
297
- </td>
298
-
299
- </tr>
300
-
301
- </table>
302
-
303
- </td>
304
-
305
- </form>
306
-
307
- </tr>
308
-
309
-
310
-
311
- </table><table width='100%' style='background-color: #f5f5f5; border: 1px solid #bbbbbb;' align='center' cellpadding='3'>
312
-
313
- </table><br>
314
-
315
- <table width='100%' style='background-color: #f5f5f5; border: 1px solid #bbbbbb;' align='center' cellpadding='1'>
316
-
317
- <tr bgcolor='#17385b' class='noprint'>
318
-
319
- <td colspan='2'>
320
-
321
- <table width='100%' cellspacing='0' cellpadding='3' border='0'>
322
-
323
- <tr>
324
-
325
- <td align='left' class='textHeaderDark' width='15%'>
326
-
327
- <?php print($para['previous']); ?>
328
-
329
- </td>
330
-
331
- <td align='center' class='textHeaderDark' width='70%'>
332
-
333
- <?php print($para['rows']); ?>
334
-
335
- </td>
336
-
337
- <td align='right' class='textHeaderDark' width='15%'>
338
-
339
- <?php print($para['next']); ?>
340
-
341
- </td>
342
-
343
- </tr>
344
-
345
- </table>
346
-
347
- </td>
348
-
349
- </tr>
350
-
351
-
352
-
353
- <tr style='background-color: #F2F2F2;'>
354
-
355
- <td align='center' width='100%'>
356
-
357
- <table align='center' cellpadding='0' width='100%'>
358
-
359
- <tr>
360
-
361
- <td align='center'>
362
-
363
- <?php print($para['data']); ?>
364
-
365
- </td>
366
-
367
- </tr>
368
-
369
- </table>
370
-
371
- </td>
372
-
373
- <td align='center' width='50%'>
374
-
375
- </td>
376
-
377
- </tr>
378
-
379
-
380
-
381
- <tr bgcolor='#17385b' class='noprint'>
382
-
383
- <td colspan='2'>
384
-
385
- <table width='100%' cellspacing='0' cellpadding='3' border='0'>
386
-
387
- <tr>
388
-
389
- <td align='left' class='textHeaderDark' width='15%'>
390
-
391
- <?php print($para['previous']); ?>
392
-
393
- </td>
394
-
395
- <td align='center' class='textHeaderDark' width='70%'>
396
-
397
- <?php print($para['rows']); ?>
398
-
399
- </td>
400
-
401
- <td align='right' class='textHeaderDark' width='15%'>
402
-
403
- <?php print($para['next']); ?>
404
-
405
- </td>
406
-
407
- </tr>
408
-
409
- </table>
410
-
411
- </td>
412
-
413
- </tr>
414
-
415
- </table> <br>
416
-
417
- </td>
418
-
419
- </tr>
420
-
421
- </table>
422
-
423
-
424
-
425
- </body>
426
-
427
- </html>
428
-
429
- ```

1

修正

2016/10/25 03:43

投稿

amaguri
amaguri

スコア227

test CHANGED
File without changes
test CHANGED
@@ -14,39 +14,45 @@
14
14
 
15
15
  取得したデータはこちらになります。
16
16
 
17
+ データの取得はできています。
18
+
17
19
  ```ここに言語を入力
18
20
 
21
+ app/controllers/entity_controller.php (line 120)
22
+
23
+ default
24
+
25
+ app/controllers/entity_controller.php (line 120)
26
+
27
+ temp
28
+
29
+ app/controllers/entity_controller.php (line 120)
30
+
19
- Array
31
+ infra
20
-
21
- (
32
+
22
-
23
- [0] => Array
24
-
25
- (
26
-
27
- [DBS] => Array
28
-
29
- (
30
-
31
- [DB_ID] => 1
32
-
33
- [DESC] => Default Hive database
34
-
35
- [DB_LOCATION_URI] => maprfs:/user/hive/warehouse
33
+ app/controllers/entity_controller.php (line 120)
34
+
36
-
35
+ tpcds_text_10
36
+
37
+ app/controllers/entity_controller.php (line 120)
38
+
37
- [NAME] => default
39
+ tpcds_bin_partitioned_orc_10
40
+
38
-
41
+ app/controllers/entity_controller.php (line 120)
42
+
43
+ tpcds_text_100
44
+
45
+ app/controllers/entity_controller.php (line 120)
46
+
47
+ tpcds_bin_partitioned_orc_100
48
+
49
+ app/controllers/entity_controller.php (line 120)
50
+
39
- [OWNER_NAME] =>
51
+ tpcds_text_1000
40
-
52
+
41
- [OWNER_TYPE] =>
53
+ app/controllers/entity_controller.php (line 120)
42
-
43
- )
54
+
44
-
45
-
46
-
47
- )
55
+
48
-
49
-
50
56
 
51
57
  ```
52
58
 
@@ -92,11 +98,15 @@
92
98
 
93
99
  foreach($para as $name){
94
100
 
95
- $p_database=$name['DBS']['DB_ID']
101
+ $p_database=$name['DBS']['NAME']
102
+
103
+ $para['database']=$p_database;
104
+
105
+ debug($para['database']);
96
106
 
97
107
  }
98
108
 
99
- $para['database']=$p_database;
109
+
100
110
 
101
111
  $this->set('para', $para);
102
112