回答編集履歴
2
修正
answer
CHANGED
|
@@ -42,7 +42,7 @@
|
|
|
42
42
|
$sql->bindValue(":offset", $offset, PDO::PARAM_INT);
|
|
43
43
|
$sql->bindValue(":limit", PAGE_LIMIT, PDO::PARAM_INT);
|
|
44
44
|
if ( $name ) {
|
|
45
|
-
$sql->bindValue(":name", "%" . $name . "%", PDO::PARAM_STR);
|
|
45
|
+
$sql->bindValue(":name", "%" . addcslashes($name, '\_%') . "%", PDO::PARAM_STR);
|
|
46
46
|
}
|
|
47
47
|
$sql->execute();
|
|
48
48
|
|
1
修正
answer
CHANGED
|
@@ -88,20 +88,20 @@
|
|
|
88
88
|
<tbody>
|
|
89
89
|
<? foreach($result as $key => $value) : ?>
|
|
90
90
|
<tr>
|
|
91
|
-
<td><?= $value['
|
|
91
|
+
<td><?= $value['name'] ?></td>
|
|
92
92
|
</tr>
|
|
93
93
|
<? endforeach; ?>
|
|
94
94
|
</tbody>
|
|
95
95
|
</table>
|
|
96
96
|
<!-- ページネーション -->
|
|
97
97
|
<? if ( $p > 0 ) : ?>
|
|
98
|
-
<a href="
|
|
98
|
+
<a href="index.php?search=1&name=<?= $name ?>&p=<?= $p-1 ?>" class="pull-left">戻る</a>
|
|
99
99
|
<? else : ?>
|
|
100
100
|
<span class="pull-left">最新</span>
|
|
101
101
|
<? endif; ?>
|
|
102
102
|
|
|
103
103
|
<? if ( $all['TOTAL'] - (PAGE_LIMIT * $p ) > PAGE_LIMIT ) : ?>
|
|
104
|
-
<a href="
|
|
104
|
+
<a href="index.php?search=1&name=<?= $name ?>&p=<?= $p+1 ?>" class="pull-right">次へ</a>
|
|
105
105
|
<? else : ?>
|
|
106
106
|
<span class="pull-right">末尾</span>
|
|
107
107
|
<? endif; ?>
|