PHP mysqldb::limitpage Examples

Example #1

File: read_board.php Project: laiello/jejunubus

    $result = $db->read($page);
    while ($row_array = mysql_fetch_array($result)) {
        echo "<div class=\"viewform\"> \n       \t\t <div class=\"name\"> 작성자 : {$row_array['name']} </div>\n       \t\t <div class=\"content\"> {$row_array['content']} </div>\n       \t\t </div>";
    }
} else {
    $result = $db->read($page);
    while ($row_array = mysql_fetch_array($result)) {
        echo "<div class=\"viewform\"> \n                 <div class=\"name\"> 작성자 : {$row_array['name']} </div>\n                 <div class=\"content\"> {$row_array['content']} </div>\n                 </div>";
    }
}
//하단 Page정보 나타내기
echo "<div id=\"pageform\">";
//Page가 1일때
if ($page == 1) {
    //DB에 저장된 게시물의 Page가 1 Page밖에 없을경우
    if ($page == $db->limitpage()) {
    }
    //DB에 저장된 게시물의 Page가 1 Page가 넘어갈 경우
    if ($page < $db->limitpage()) {
        $nextpage = $page + 1;
        echo "<div class=\"nextpage\"><a href=\"http://jejunubus.hosting.paran.com/jejunubus1.0/board.php?page=" . $nextpage . "\">" . ">" . "</a></div>";
    }
} else {
    if ($page == $db->limitpage()) {
        $backpage = $page - 1;
        echo "<div class=\"backpage\"><a href=\"http://jejunubus.hosting.paran.com/jejunubus1.0/board.php?page=" . $backpage . "\">" . "<" . "</a></div>";
    } else {
        $nextpage = $page + 1;
        $backpage = $page - 1;
        echo "<div class=\"backpage\"><a href=\"http://jejunubus.hosting.paran.com/jejunubus1.0/board.php?page=" . $backpage . "\">" . "<" . "</a></div>";
        echo "<div class=\"nextpage\"><a href=\"http://jejunubus.hosting.paran.com/jejunubus1.0/board.php?page=" . $nextpage . "\">" . ">" . "</a></div>";