質問編集履歴
5
変更
test
CHANGED
File without changes
|
test
CHANGED
@@ -186,7 +186,7 @@
|
|
186
186
|
|
187
187
|
<div class="main">
|
188
188
|
|
189
|
-
<p><?= $row['shop_name'];?></p> ←$rowsに変更
|
189
|
+
<p><?= $rows['shop_name'];?></p> ←$rowsに変更
|
190
190
|
|
191
191
|
<h4>入店の可否</h4>
|
192
192
|
|
4
$rows[]=$shop_row; ←追加
test
CHANGED
File without changes
|
test
CHANGED
@@ -132,7 +132,7 @@
|
|
132
132
|
|
133
133
|
$shop_comment = $row['shop_comment'];
|
134
134
|
|
135
|
-
p
|
135
|
+
$rows[]=$shop_row; ←追加
|
136
136
|
|
137
137
|
}
|
138
138
|
|
@@ -186,13 +186,13 @@
|
|
186
186
|
|
187
187
|
<div class="main">
|
188
188
|
|
189
|
-
<p><?= $row['shop_name'];?></p>
|
189
|
+
<p><?= $row['shop_name'];?></p> ←$rowsに変更
|
190
190
|
|
191
191
|
<h4>入店の可否</h4>
|
192
192
|
|
193
193
|
<p><?php
|
194
194
|
|
195
|
-
$pt = $row['s
|
195
|
+
$pt = $rows[0]['yesno']; ←変更
|
196
196
|
|
197
197
|
$col = [1 => "black", 2 => "red"];
|
198
198
|
|
@@ -206,9 +206,9 @@
|
|
206
206
|
|
207
207
|
?></p>
|
208
208
|
|
209
|
-
<p>コメント:<?= $row['shop_comment'];?></p>
|
209
|
+
<p>コメント:<?= $rows['shop_comment'];?></p> ←$rowsに変更
|
210
|
-
|
210
|
+
|
211
|
-
<a href="user_reserve_form.php?shop_id=<?= $row['shop_id'];?>">予約する</a>
|
211
|
+
<a href="user_reserve_form.php?shop_id=<?= $rows['shop_id'];?>">予約する</a> ←$rowsに変更
|
212
212
|
|
213
213
|
</div>
|
214
214
|
|
3
$shop_query = "SELECT * FROM shop where yesno in(1,2)";に変更
test
CHANGED
File without changes
|
test
CHANGED
@@ -102,7 +102,7 @@
|
|
102
102
|
|
103
103
|
// ②shopIDからshop名を取り出す
|
104
104
|
|
105
|
-
$shop_query = "SELECT * FROM shop";
|
105
|
+
$shop_query = "SELECT * FROM shop where yesno in(1,2)";
|
106
106
|
|
107
107
|
$shop_result = $pdo->query($shop_query);
|
108
108
|
|
2
エラーモードの追加、while内にprint_rを追加
test
CHANGED
File without changes
|
test
CHANGED
@@ -48,6 +48,8 @@
|
|
48
48
|
|
49
49
|
array(PDO::ATTR_EMULATE_PREPARES => false));
|
50
50
|
|
51
|
+
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
52
|
+
|
51
53
|
|
52
54
|
|
53
55
|
if(!isset($_SESSION['user'])) {
|
@@ -130,11 +132,9 @@
|
|
130
132
|
|
131
133
|
$shop_comment = $row['shop_comment'];
|
132
134
|
|
135
|
+
print_r($row); ←追加
|
136
|
+
|
133
|
-
}
|
137
|
+
}
|
134
|
-
|
135
|
-
|
136
|
-
|
137
|
-
print_r($row); ←追加
|
138
138
|
|
139
139
|
|
140
140
|
|
1
print_r($row);の追加
test
CHANGED
File without changes
|
test
CHANGED
@@ -36,7 +36,9 @@
|
|
36
36
|
|
37
37
|
<?php
|
38
38
|
|
39
|
+
error_reporting(E_ALL);
|
40
|
+
|
39
|
-
|
41
|
+
ini_set("display_errors",1);
|
40
42
|
|
41
43
|
session_start();
|
42
44
|
|
@@ -128,9 +130,13 @@
|
|
128
130
|
|
129
131
|
$shop_comment = $row['shop_comment'];
|
130
132
|
|
131
|
-
|
132
|
-
|
133
|
-
}
|
133
|
+
}
|
134
|
+
|
135
|
+
|
136
|
+
|
137
|
+
print_r($row); ←追加
|
138
|
+
|
139
|
+
|
134
140
|
|
135
141
|
} catch (PDOException $e) {
|
136
142
|
|