質問編集履歴
1
追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -24,9 +24,6 @@
|
|
24
24
|
</head>
|
25
25
|
|
26
26
|
<body>
|
27
|
-
<?php
|
28
|
-
// header部分
|
29
|
-
include 'templates/header.php'; ?>
|
30
27
|
<main class="top_box">
|
31
28
|
<?php foreach ($result as $review): ?>
|
32
29
|
<div class=tweetBox>
|
@@ -105,7 +102,66 @@
|
|
105
102
|
</script>
|
106
103
|
</body>
|
107
104
|
```
|
105
|
+
### 追記
|
106
|
+
```php
|
107
|
+
// DBから取得
|
108
|
+
public function reviewAll($page = 0): array
|
109
|
+
{
|
110
|
+
$sql = 'SELECT u.name AS user_name, s.* FROM Shrines_review AS s JOIN users AS u on u.id = s.user_id ORDER BY id DESC';
|
111
|
+
$sql .= ' LIMIT 10 OFFSET '.(10 * $page);
|
112
|
+
$sth = $this->dbh->prepare($sql);
|
113
|
+
$sth->execute();
|
114
|
+
$result = $sth->fetchAll(PDO::FETCH_ASSOC);
|
108
115
|
|
116
|
+
return $result;
|
117
|
+
}
|
118
|
+
// 取得結果
|
119
|
+
var_dump($result);
|
120
|
+
array(2) {
|
121
|
+
[0]=>
|
122
|
+
array(9) {
|
123
|
+
["user_name"]=>
|
124
|
+
string(27) "テスト管理ユーザー"
|
125
|
+
["id"]=>
|
126
|
+
string(1) "4"
|
127
|
+
["title"]=>
|
128
|
+
string(12) "テスト2"
|
129
|
+
["recommends"]=>
|
130
|
+
string(1) "4"
|
131
|
+
["description"]=>
|
132
|
+
string(12) "テスト2"
|
133
|
+
["image"]=>
|
134
|
+
string(52) "img/20220120103123084AME0226_TP_Vのコピー.jpg"
|
135
|
+
["created_at"]=>
|
136
|
+
string(19) "2022-01-20 10:31:23"
|
137
|
+
["updated_at"]=>
|
138
|
+
string(19) "2022-01-20 10:31:23"
|
139
|
+
["user_id"]=>
|
140
|
+
string(2) "35"
|
141
|
+
}
|
142
|
+
[1]=>
|
143
|
+
array(9) {
|
144
|
+
["user_name"]=>
|
145
|
+
string(27) "テスト管理ユーザー"
|
146
|
+
["id"]=>
|
147
|
+
string(1) "3"
|
148
|
+
["title"]=>
|
149
|
+
string(12) "テスト3"
|
150
|
+
["recommends"]=>
|
151
|
+
string(1) "3"
|
152
|
+
["description"]=>
|
153
|
+
string(12) "テスト3"
|
154
|
+
["image"]=>
|
155
|
+
string(34) "img/20220119050135python_18894.png"
|
156
|
+
["created_at"]=>
|
157
|
+
string(19) "2022-01-19 17:01:35"
|
158
|
+
["updated_at"]=>
|
159
|
+
string(19) "2022-01-20 14:00:32"
|
160
|
+
["user_id"]=>
|
161
|
+
string(2) "35"
|
162
|
+
}
|
163
|
+
}
|
164
|
+
```
|
109
165
|
あるサイトにて見つけたコードを参考にし表示させようとしたが
|
110
166
|
今度は星マークすら表示されなくなった。
|
111
167
|
画像のルートパス
|