質問編集履歴
1
修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -282,66 +282,6 @@
|
|
|
282
282
|
|
|
283
283
|
|
|
284
284
|
|
|
285
|
-
|
|
286
|
-
|
|
287
|
-
|
|
288
|
-
|
|
289
|
-
$per_page = 5; //1pageに何件表示するか
|
|
290
|
-
|
|
291
|
-
|
|
292
|
-
|
|
293
|
-
if(isset($_GET['page'])){
|
|
294
|
-
|
|
295
|
-
$page = $_GET['page']; //htmlでリンクを押下時それぞれのページを取得
|
|
296
|
-
|
|
297
|
-
}else{
|
|
298
|
-
|
|
299
|
-
$page = 1; //もし、それ以外の値が入ってきたら1pageに飛ばす
|
|
300
|
-
|
|
301
|
-
}
|
|
302
|
-
|
|
303
|
-
|
|
304
|
-
|
|
305
|
-
try{
|
|
306
|
-
|
|
307
|
-
$dbh = new PDO('mysql:host='.DB_HOST.';dbname='.DB_NAME,DB_USER,DB_PASS);
|
|
308
|
-
|
|
309
|
-
}catch(PDOException $e){
|
|
310
|
-
|
|
311
|
-
echo $e->getMessage();
|
|
312
|
-
|
|
313
|
-
exit;
|
|
314
|
-
|
|
315
|
-
}
|
|
316
|
-
|
|
317
|
-
|
|
318
|
-
|
|
319
|
-
$offset = $per_page * ($page -1); //offsetを計算 現在のページ -1 * 何件表示するか
|
|
320
|
-
|
|
321
|
-
$sql = "select * from comments limit ".$offset.",".$per_page; //
|
|
322
|
-
|
|
323
|
-
|
|
324
|
-
|
|
325
|
-
$comments = array();
|
|
326
|
-
|
|
327
|
-
foreach($dbh->query($sql) as $row){
|
|
328
|
-
|
|
329
|
-
array_push($comments,$row);
|
|
330
|
-
|
|
331
|
-
}
|
|
332
|
-
|
|
333
|
-
|
|
334
|
-
|
|
335
|
-
$total = $dbh->query("select count(*) from comments")->fetchColumn(); //カラム数をカウント
|
|
336
|
-
|
|
337
|
-
$totalPages = ceil($total/$per_page); //何ページ必要かを計算
|
|
338
|
-
|
|
339
|
-
|
|
340
|
-
|
|
341
|
-
|
|
342
|
-
|
|
343
|
-
|
|
344
|
-
|
|
345
285
|
// データベースへの接続を閉じる
|
|
346
286
|
|
|
347
287
|
mysqli_close( $link );
|