indexrec.php

来自「火花留言本」· PHP 代码 · 共 40 行

<?php
$currentPage = $_SERVER["PHP_SELF"];

$maxRows_RecBoard = 8;
$pageNum_RecBoard = 0;
if (isset($_GET['pageNum_RecBoard'])) {
  $pageNum_RecBoard = $_GET['pageNum_RecBoard'];
}
$startRow_RecBoard = $pageNum_RecBoard * $maxRows_RecBoard;

mysql_select_db($database_connBoard, $connBoard);
$query_RecBoard = "SELECT * FROM board WHERE open=1 ORDER BY digiB_id DESC";
$query_limit_RecBoard = sprintf("%s LIMIT %d, %d", $query_RecBoard, $startRow_RecBoard, $maxRows_RecBoard);
$RecBoard = mysql_query($query_limit_RecBoard, $connBoard) or die(mysql_error());
$row_RecBoard = mysql_fetch_assoc($RecBoard);

if (isset($_GET['totalRows_RecBoard'])) {
  $totalRows_RecBoard = $_GET['totalRows_RecBoard'];
} else {
  $all_RecBoard = mysql_query($query_RecBoard);
  $totalRows_RecBoard = mysql_num_rows($all_RecBoard);
}
$totalPages_RecBoard = ceil($totalRows_RecBoard/$maxRows_RecBoard)-1;

$queryString_RecBoard = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_RecBoard") == false && 
        stristr($param, "totalRows_RecBoard") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_RecBoard = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_RecBoard = sprintf("&totalRows_RecBoard=%d%s", $totalRows_RecBoard, $queryString_RecBoard);
?>