teratail
回答率
85.48%
質問するログイン新規登録
トップPHPに関する質問複数のドロップダウンリストについて

編集履歴

回答編集履歴

3

typo

2016/12/02 13:39

投稿

yambejp
yambejp

スコア114769

test CHANGED
@@ -240,7 +240,7 @@
240
240
 
241
241
  $sql.="AND item_id=? ";
242
242
 
243
- $= $pdo->prepare($sql);
243
+ $stmt= $pdo->prepare($sql);
244
244
 
245
245
  $stmt->execute([$item]);
246
246
 

2

調整

2016/12/02 13:39

投稿

yambejp
yambejp

スコア114769

test CHANGED
@@ -190,200 +190,74 @@
190
190
 
191
191
  ```
192
192
 
193
-
193
+ #sub調整
194
194
 
195
195
  - sub.php
196
196
 
197
197
  ```PHP
198
198
 
199
- <?PHP
200
-
201
199
  $item =filter_input(INPUT_POST,"item" ,FILTER_DEFAULT,["options"=>["default"=>null]]);
202
200
 
203
201
  $shop =filter_input(INPUT_POST,"shop" ,FILTER_DEFAULT,["options"=>["default"=>null]]);
204
202
 
205
203
  $hatukbn=filter_input(INPUT_POST,"hatukbn",FILTER_DEFAULT,["options"=>["default"=>null]]);
206
204
 
207
-
208
-
209
205
  if(!is_null($hatukbn) and !is_null($shop) and !is_null($item)){
210
206
 
211
- $data=[
212
-
213
- 1=>[
214
-
215
- 1=>[
216
-
217
- 1=>[["value"=>1,"text"=>"TEN1-1-1-1"],["value"=>2,"text"=>"TEN1-1-1-2"],["value"=>3,"text"=>"TEN1-1-1-3"]],
218
-
219
- 2=>[["value"=>1,"text"=>"TEN1-1-2-1"],["value"=>2,"text"=>"TEN1-1-2-2"],["value"=>3,"text"=>"TEN1-1-2-3"]],
220
-
221
- 3=>[["value"=>1,"text"=>"TEN1-1-3-1"],["value"=>2,"text"=>"TEN1-1-3-2"],["value"=>3,"text"=>"TEN1-1-3-3"]],
222
-
223
- ],
224
-
225
- 2=>[
226
-
227
- 1=>[["value"=>1,"text"=>"TEN1-2-1-1"],["value"=>2,"text"=>"TEN1-2-1-2"],["value"=>3,"text"=>"TEN1-2-1-3"]],
228
-
229
- 2=>[["value"=>1,"text"=>"TEN1-2-2-1"],["value"=>2,"text"=>"TEN1-2-2-2"],["value"=>3,"text"=>"TEN1-2-2-3"]],
230
-
231
- 3=>[["value"=>1,"text"=>"TEN1-2-3-1"],["value"=>2,"text"=>"TEN1-2-3-2"],["value"=>3,"text"=>"TEN1-2-3-3"]],
232
-
233
- ],
234
-
235
- 3=>[
236
-
237
- 1=>[["value"=>1,"text"=>"TEN1-3-1-1"],["value"=>2,"text"=>"TEN1-3-1-2"],["value"=>3,"text"=>"TEN1-3-1-3"]],
238
-
239
- 2=>[["value"=>1,"text"=>"TEN1-3-2-1"],["value"=>2,"text"=>"TEN1-3-2-2"],["value"=>3,"text"=>"TEN1-3-2-3"]],
240
-
241
- 3=>[["value"=>1,"text"=>"TEN1-3-3-1"],["value"=>2,"text"=>"TEN1-3-3-2"],["value"=>3,"text"=>"TEN1-3-3-3"]],
242
-
243
- ],
244
-
245
- ],
246
-
247
- 2=>[
248
-
249
- 1=>[
250
-
251
- 1=>[["value"=>1,"text"=>"TEN2-1-1-1"],["value"=>2,"text"=>"TEN2-1-1-2"],["value"=>3,"text"=>"TEN2-1-1-3"]],
252
-
253
- 2=>[["value"=>1,"text"=>"TEN2-1-2-1"],["value"=>2,"text"=>"TEN2-1-2-2"],["value"=>3,"text"=>"TEN2-1-2-3"]],
254
-
255
- 3=>[["value"=>1,"text"=>"TEN2-1-3-1"],["value"=>2,"text"=>"TEN2-1-3-2"],["value"=>3,"text"=>"TEN2-1-3-3"]],
256
-
257
- ],
258
-
259
- 2=>[
260
-
261
- 1=>[["value"=>1,"text"=>"TEN2-2-1-1"],["value"=>2,"text"=>"TEN2-2-1-2"],["value"=>3,"text"=>"TEN2-2-1-3"]],
262
-
263
- 2=>[["value"=>1,"text"=>"TEN2-2-2-1"],["value"=>2,"text"=>"TEN2-2-2-2"],["value"=>3,"text"=>"TEN2-2-2-3"]],
264
-
265
- 3=>[["value"=>1,"text"=>"TEN2-2-3-1"],["value"=>2,"text"=>"TEN2-2-3-2"],["value"=>3,"text"=>"TEN2-2-3-3"]],
266
-
267
- ],
268
-
269
- 3=>[
270
-
271
- 1=>[["value"=>1,"text"=>"TEN2-3-1-1"],["value"=>2,"text"=>"TEN2-3-1-2"],["value"=>3,"text"=>"TEN2-3-1-3"]],
272
-
273
- 2=>[["value"=>1,"text"=>"TEN2-3-2-1"],["value"=>2,"text"=>"TEN2-3-2-2"],["value"=>3,"text"=>"TEN2-3-2-3"]],
274
-
275
- 3=>[["value"=>1,"text"=>"TEN2-3-3-1"],["value"=>2,"text"=>"TEN2-3-3-2"],["value"=>3,"text"=>"TEN2-3-3-3"]],
276
-
277
- ],
278
-
279
- ],
280
-
281
- 3=>[
282
-
283
- 1=>[
284
-
285
- 1=>[["value"=>1,"text"=>"TEN3-1-1-1"],["value"=>2,"text"=>"TEN3-1-1-2"],["value"=>3,"text"=>"TEN3-1-1-3"]],
286
-
287
- 2=>[["value"=>1,"text"=>"TEN3-1-2-1"],["value"=>2,"text"=>"TEN3-1-2-2"],["value"=>3,"text"=>"TEN3-1-2-3"]],
288
-
289
- 3=>[["value"=>1,"text"=>"TEN3-1-3-1"],["value"=>2,"text"=>"TEN3-1-3-2"],["value"=>3,"text"=>"TEN3-1-3-3"]],
290
-
291
- ],
292
-
293
- 2=>[
294
-
295
- 1=>[["value"=>1,"text"=>"TEN3-2-1-1"],["value"=>2,"text"=>"TEN3-2-1-2"],["value"=>3,"text"=>"TEN3-2-1-3"]],
296
-
297
- 2=>[["value"=>1,"text"=>"TEN3-2-2-1"],["value"=>2,"text"=>"TEN3-2-2-2"],["value"=>3,"text"=>"TEN3-2-2-3"]],
298
-
299
- 3=>[["value"=>1,"text"=>"TEN3-2-3-1"],["value"=>2,"text"=>"TEN3-2-3-2"],["value"=>3,"text"=>"TEN3-2-3-3"]],
300
-
301
- ],
302
-
303
- 3=>[
304
-
305
- 1=>[["value"=>1,"text"=>"TEN3-3-1-1"],["value"=>2,"text"=>"TEN3-3-1-2"],["value"=>3,"text"=>"TEN3-3-1-3"]],
306
-
307
- 2=>[["value"=>1,"text"=>"TEN3-3-2-1"],["value"=>2,"text"=>"TEN3-3-2-2"],["value"=>3,"text"=>"TEN3-3-2-3"]],
308
-
309
- 3=>[["value"=>1,"text"=>"TEN3-3-3-1"],["value"=>2,"text"=>"TEN3-3-3-2"],["value"=>3,"text"=>"TEN3-3-3-3"]],
310
-
311
- ],
312
-
313
- ],
314
-
315
- ];
316
-
317
- print json_encode($data[$item][$shop][$hatukbn]);
318
-
319
- exit;
207
+ $sql ="SELECT ten_id as value,ten_name as text FROM テーブルA ";
208
+
209
+ $sql.="WHERE 1 ";
210
+
211
+ $sql.="AND item_id=? ";
212
+
213
+ $sql.="AND shop_id=? ";
214
+
215
+ $sql.="AND hatukbn_id=? ";
216
+
217
+ $stmt = $pdo->prepare($sql);
218
+
219
+ $stmt->execute([$item,$shop,$hatukbn]);
220
+
221
+ }elseif(!is_null($shop) and !is_null($item)){
222
+
223
+ $sql ="SELECT hatukbn_id as value,hatukbn_name as text FROM テーブルB ";
224
+
225
+ $sql.="WHERE 1 ";
226
+
227
+ $sql.="AND item_id=? ";
228
+
229
+ $sql.="AND shop_id=? ";
230
+
231
+ $stmt = $pdo->prepare($sql);
232
+
233
+ $stmt->execute([$item,$shop]);
234
+
235
+ }elseif(!is_null($item)){
236
+
237
+ $sql ="SELECT shop_id as value,shop_name as text FROM テーブルC ";
238
+
239
+ $sql.="WHERE 1 ";
240
+
241
+ $sql.="AND item_id=? ";
242
+
243
+ $= $pdo->prepare($sql);
244
+
245
+ $stmt->execute([$item]);
320
246
 
321
247
  }
322
248
 
249
+ if($stmt){
250
+
251
+ $rows=$stmt->fetchAll(PDO::FETCH_ASSOC);
252
+
323
- if(!is_null($shop) and !is_null($item)){
253
+ print json_encode($rows);
324
-
254
+
325
- $data=[
255
+ }else{
326
-
327
- 1=>[
256
+
328
-
329
- 1=>[["value"=>1,"text"=>"HATU1-1-1"],["value"=>2,"text"=>"HATU1-1-2"],["value"=>3,"text"=>"HATU1-1-3"]],
330
-
331
- 2=>[["value"=>1,"text"=>"HATU1-2-1"],["value"=>2,"text"=>"HATU1-2-2"],["value"=>3,"text"=>"HATU1-2-3"]],
332
-
333
- 3=>[["value"=>1,"text"=>"HATU1-3-1"],["value"=>2,"text"=>"HATU1-3-2"],["value"=>3,"text"=>"HATU1-3-3"]],
334
-
335
- ],
336
-
337
- 2=>[
338
-
339
- 1=>[["value"=>1,"text"=>"HATU2-1-1"],["value"=>2,"text"=>"HATU2-1-2"],["value"=>3,"text"=>"HATU2-1-3"]],
340
-
341
- 2=>[["value"=>1,"text"=>"HATU2-2-1"],["value"=>2,"text"=>"HATU2-2-2"],["value"=>3,"text"=>"HATU2-2-3"]],
342
-
343
- 3=>[["value"=>1,"text"=>"HATU2-3-1"],["value"=>2,"text"=>"HATU2-3-2"],["value"=>3,"text"=>"HATU2-3-3"]],
344
-
345
- ],
346
-
347
- 3=>[
348
-
349
- 1=>[["value"=>1,"text"=>"HATU3-1-1"],["value"=>2,"text"=>"HATU3-1-2"],["value"=>3,"text"=>"HATU3-1-3"]],
350
-
351
- 2=>[["value"=>1,"text"=>"HATU3-2-1"],["value"=>2,"text"=>"HATU3-2-2"],["value"=>3,"text"=>"HATU3-2-3"]],
352
-
353
- 3=>[["value"=>1,"text"=>"HATU3-3-1"],["value"=>2,"text"=>"HATU3-3-2"],["value"=>3,"text"=>"HATU3-3-3"]],
354
-
355
- ],
356
-
357
- ];
358
-
359
- print json_encode($data[$item][$shop]);
257
+ print json_encode((object)[]);
360
-
361
- exit;
362
258
 
363
259
  }
364
260
 
365
-
366
-
367
- if(!is_null($item)){
368
-
369
- $data=[
370
-
371
- 1=>[["value"=>1,"text"=>"SHOP1-1"],["value"=>2,"text"=>"SHOP1-2"],["value"=>3,"text"=>"SHOP1-3"]],
372
-
373
- 2=>[["value"=>1,"text"=>"SHOP2-1"],["value"=>2,"text"=>"SHOP2-2"],["value"=>3,"text"=>"SHOP2-3"]],
374
-
375
- 3=>[["value"=>1,"text"=>"SHOP3-1"],["value"=>2,"text"=>"SHOP3-2"],["value"=>3,"text"=>"SHOP3-3"]],
376
-
377
- ];
378
-
379
- print json_encode($data[$item]);
380
-
381
- exit;
382
-
383
- }
384
-
385
- print json_encode((object)[]);
386
-
387
261
  ?>
388
262
 
389
263
  ```

1

調整

2016/12/02 08:38

投稿

yambejp
yambejp

スコア114769

test CHANGED
File without changes