質問編集履歴
2
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -8,7 +8,20 @@
|
|
|
8
8
|
shopテーブル：ショップ情報
|
|
9
9
|
userテーブル：ユーザー情報
|
|
10
10
|
reserveテーブル：予約が入る
|
|
11
|
+
```ここに言語を入力
|
|
12
|
+
エラー
|
|
13
|
+
Notice: Undefined index: reserve_shop_id in C:\xampp\htdocs\reserve\shop\shop_home.php on line 20
|
|
11
14
|
|
|
15
|
+
Notice: Undefined index: count in C:\xampp\htdocs\reserve\shop\shop_home.php on line 21
|
|
16
|
+
|
|
17
|
+
Notice: Undefined index: time in C:\xampp\htdocs\reserve\shop\shop_home.php on line 22
|
|
18
|
+
|
|
19
|
+
Notice: Undefined index: reserve_comment in C:\xampp\htdocs\reserve\shop\shop_home.php on line 23
|
|
20
|
+
|
|
21
|
+
Notice: Undefined index: reserve_time in C:\xampp\htdocs\reserve\shop\shop_home.php on line 24
|
|
22
|
+
|
|
23
|
+
Notice: Undefined index: reserve_tel in C:\xampp\htdocs\reserve\shop\shop_home.php on line 25
|
|
24
|
+
```
|
|
12
25
|
### 該当のソースコード
|
|
13
26
|
|
|
14
27
|
```ここに言語名を入力
|
1
修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -15,7 +15,7 @@
|
|
|
15
15
|
<?php
|
|
16
16
|
error_reporting(E_ALL);
|
|
17
17
|
ini_set("display_errors",1);
|
|
18
|
-
define('PAGE_LIMIT',
|
|
18
|
+
define('PAGE_LIMIT', 2);
|
|
19
19
|
|
|
20
20
|
try {
|
|
21
21
|
session_start();
|
|
@@ -43,10 +43,10 @@
|
|
|
43
43
|
$reserve_stmt = $pdo->prepare($reserve_query);
|
|
44
44
|
$reserve_stmt->bindValue(':shop_id', $shop_id, PDO::PARAM_INT);
|
|
45
45
|
$reserve_stmt->execute();
|
|
46
|
-
|
|
46
|
+
//var_dump($shop_id); ->int(4)
|
|
47
47
|
// 予約情報の取り出し
|
|
48
48
|
$arr_reserve = [];
|
|
49
|
-
while ($rows = $reserve_stmt->
|
|
49
|
+
while ($rows = $reserve_stmt->fetchAll(PDO::FETCH_ASSOC)) {
|
|
50
50
|
$arr_reserve[] = [
|
|
51
51
|
'reserve_shop_id' => $rows['reserve_shop_id'],
|
|
52
52
|
'count' => $rows['count'],
|
|
@@ -58,22 +58,12 @@
|
|
|
58
58
|
$search = filter_input(INPUT_GET, 'search');
|
|
59
59
|
$p = !is_numeric(filter_input(INPUT_GET, 'p')) ? 0 : filter_input(INPUT_GET, 'p');
|
|
60
60
|
$name = filter_input(INPUT_GET, 'name', FILTER_SANITIZE_SPECIAL_CHARS);
|
|
61
|
-
$shop = filter_input(INPUT_GET, 'shop', FILTER_SANITIZE_SPECIAL_CHARS);
|
|
62
|
-
$user_id = filter_input(INPUT_GET, 'user_id', FILTER_SANITIZE_SPECIAL_CHARS);
|
|
63
|
-
$time = filter_input(INPUT_GET, 'time', FILTER_SANITIZE_SPECIAL_CHARS);
|
|
64
|
-
$count = filter_input(INPUT_GET, 'count', FILTER_SANITIZE_SPECIAL_CHARS);
|
|
65
61
|
$reserve_comment = filter_input(INPUT_GET, 'reserve_comment', FILTER_SANITIZE_SPECIAL_CHARS);
|
|
66
62
|
$reserve_time = filter_input(INPUT_GET, 'reserve_time', FILTER_SANITIZE_SPECIAL_CHARS);
|
|
67
63
|
$reserve_tel = filter_input(INPUT_GET, 'reserve_tel', FILTER_SANITIZE_SPECIAL_CHARS);
|
|
68
64
|
|
|
69
65
|
// 取得開始位置
|
|
70
66
|
$offset = $p * PAGE_LIMIT;
|
|
71
|
-
// SQL生成
|
|
72
|
-
$where = [];
|
|
73
|
-
$whereSql = null;
|
|
74
|
-
if ( $name ) {
|
|
75
|
-
$where[] = "name like :name";
|
|
76
|
-
}
|
|
77
67
|
|
|
78
68
|
$sql = $pdo->prepare('select SQL_CALC_FOUND_ROWS * from reserve '.$whereSql.' order by reserve_time desc limit :limit offset :offset');
|
|
79
69
|
$sql->bindValue(":offset", $offset, PDO::PARAM_INT);
|
|
@@ -81,9 +71,6 @@
|
|
|
81
71
|
|
|
82
72
|
$sql->execute();
|
|
83
73
|
|
|
84
|
-
// 結果取得
|
|
85
|
-
$result = $sql->fetchAll();
|
|
86
|
-
|
|
87
74
|
// Total件数
|
|
88
75
|
$totalRow = $pdo->query("SELECT FOUND_ROWS() as total");
|
|
89
76
|
$all = $totalRow->fetch(PDO::FETCH_ASSOC);
|