回答編集履歴
1
PDO::PARAM_INTを追加
test
CHANGED
@@ -36,9 +36,9 @@
|
|
36
36
|
|
37
37
|
order by FLOOR(UNIX_TIMESTAMP(created) / 2400) desc, pv desc limit :offset, :pagelimit");
|
38
38
|
|
39
|
-
$stmt->bindParam(':offset', $offset);
|
39
|
+
$stmt->bindParam(':offset', $offset, PDO::PARAM_INT);
|
40
40
|
|
41
|
-
$stmt->bindParam(':pagelimit', $pagelimit);
|
41
|
+
$stmt->bindParam(':pagelimit', $pagelimit, PDO::PARAM_INT);
|
42
42
|
|
43
43
|
$stmt->execute();
|
44
44
|
|