質問編集履歴
5
変更
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -92,7 +92,7 @@
|
|
|
92
92
|
</div>
|
|
93
93
|
|
|
94
94
|
<div class="main">
|
|
95
|
-
<p><?= $
|
|
95
|
+
<p><?= $rows['shop_name'];?></p> ←$rowsに変更
|
|
96
96
|
<h4>入店の可否</h4>
|
|
97
97
|
<p><?php
|
|
98
98
|
$pt = $rows[0]['yesno']; ←変更
|
4
$rows[]=$shop_row; ←追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -65,7 +65,7 @@
|
|
|
65
65
|
$shop_name = $row['shop_name'];
|
|
66
66
|
$yesno = $row['yesno'];
|
|
67
67
|
$shop_comment = $row['shop_comment'];
|
|
68
|
-
|
|
68
|
+
$rows[]=$shop_row; ←追加
|
|
69
69
|
}
|
|
70
70
|
|
|
71
71
|
} catch (PDOException $e) {
|
|
@@ -92,18 +92,18 @@
|
|
|
92
92
|
</div>
|
|
93
93
|
|
|
94
94
|
<div class="main">
|
|
95
|
-
<p><?= $row['shop_name'];?></p>
|
|
95
|
+
<p><?= $row['shop_name'];?></p> ←$rowsに変更
|
|
96
96
|
<h4>入店の可否</h4>
|
|
97
97
|
<p><?php
|
|
98
|
-
$pt = $
|
|
98
|
+
$pt = $rows[0]['yesno']; ←変更
|
|
99
99
|
$col = [1 => "black", 2 => "red"];
|
|
100
100
|
$tx = [1 => "〇", 2 => "✖"];
|
|
101
101
|
echo "<font color='".$col[$pt]."'>"; ←ここのエラー
|
|
102
102
|
echo $tx[$pt]; ←ここのエラー
|
|
103
103
|
echo "</font>";
|
|
104
104
|
?></p>
|
|
105
|
-
<p>コメント:<?= $
|
|
105
|
+
<p>コメント:<?= $rows['shop_comment'];?></p> ←$rowsに変更
|
|
106
|
-
<a href="user_reserve_form.php?shop_id=<?= $
|
|
106
|
+
<a href="user_reserve_form.php?shop_id=<?= $rows['shop_id'];?>">予約する</a> ←$rowsに変更
|
|
107
107
|
</div>
|
|
108
108
|
|
|
109
109
|
</div>
|
3
$shop_query = "SELECT * FROM shop where yesno in(1,2)";に変更
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -50,7 +50,7 @@
|
|
|
50
50
|
}
|
|
51
51
|
|
|
52
52
|
// ②shopIDからshop名を取り出す
|
|
53
|
-
$shop_query = "SELECT * FROM shop";
|
|
53
|
+
$shop_query = "SELECT * FROM shop where yesno in(1,2)";
|
|
54
54
|
$shop_result = $pdo->query($shop_query);
|
|
55
55
|
|
|
56
56
|
if (!$shop_result) {
|
2
エラーモードの追加、while内にprint_rを追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -23,6 +23,7 @@
|
|
|
23
23
|
try {
|
|
24
24
|
$pdo = new PDO('mysql:host=localhost;dbname=reserve;charset=utf8','root','',
|
|
25
25
|
array(PDO::ATTR_EMULATE_PREPARES => false));
|
|
26
|
+
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
|
|
26
27
|
|
|
27
28
|
if(!isset($_SESSION['user'])) {
|
|
28
29
|
header("Location: user_index.php");
|
|
@@ -64,10 +65,9 @@
|
|
|
64
65
|
$shop_name = $row['shop_name'];
|
|
65
66
|
$yesno = $row['yesno'];
|
|
66
67
|
$shop_comment = $row['shop_comment'];
|
|
68
|
+
print_r($row); ←追加
|
|
67
69
|
}
|
|
68
70
|
|
|
69
|
-
print_r($row); ←追加
|
|
70
|
-
|
|
71
71
|
} catch (PDOException $e) {
|
|
72
72
|
var_dump($e);
|
|
73
73
|
die();
|
1
print_r($row);の追加
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -17,7 +17,8 @@
|
|
|
17
17
|
```ここに言語名を入力
|
|
18
18
|
user_shopinfo.php
|
|
19
19
|
<?php
|
|
20
|
+
error_reporting(E_ALL);
|
|
20
|
-
|
|
21
|
+
ini_set("display_errors",1);
|
|
21
22
|
session_start();
|
|
22
23
|
try {
|
|
23
24
|
$pdo = new PDO('mysql:host=localhost;dbname=reserve;charset=utf8','root','',
|
|
@@ -63,8 +64,10 @@
|
|
|
63
64
|
$shop_name = $row['shop_name'];
|
|
64
65
|
$yesno = $row['yesno'];
|
|
65
66
|
$shop_comment = $row['shop_comment'];
|
|
67
|
+
}
|
|
66
68
|
|
|
67
|
-
|
|
69
|
+
print_r($row); ←追加
|
|
70
|
+
|
|
68
71
|
} catch (PDOException $e) {
|
|
69
72
|
var_dump($e);
|
|
70
73
|
die();
|