php my sql 分页帮助需要链接并推进下一个偏移量

Question

嗨，我正在尝试对 php mysql 数据库进行分页，但我不知道是什么使结果移至下一页，它卡在记录行零处，我该如何更改才能使其移至下一页一组结果？这是卡在导航链接上的偏移量吗？它是否必须调用 mysql 查询？这是如何工作的？

    //pagination
    //find out how many rows are in the table 

    $sql = "SELECT * FROM hotels_database";
    $result = mysql_query($sql, $con) or trigger_error("SQL", E_USER_ERROR);
    $r = mysql_fetch_row($result);
    $numrows = $r[0];


    // number of rows to show per page
    $rowsperpage = 2;
    // find out total pages
    $totalpages = ceil($numrows / $rowsperpage);

    // get the current page or set a default
    if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {
    // cast var as int
    $currentpage = preg_replace('#[^0-9]#i','', $_GET['currentpage']);
    } else {
    // default page num
    $currentpage = 1;
    } // end if



    // if current page is greater than total pages...
    if ($currentpage > $totalpages) {
    // set current page to last page
    $currentpage = $totalpages;
    } // end if
    // if current page is less than first page...
    if ($currentpage < 1) {
    // set current page to first page
    $currentpage = 1;
    } // end if

    // the offset of the list, based on current page 
    $offset = ($currentpage - 1) * $rowsperpage;

    // get the info from the db 
    $sql = "SELECT * FROM hotels_database LIMIT $offset, $rowsperpage";
    $result = mysql_query($sql, $con) or trigger_error("SQL", E_USER_ERROR);

    // while there are rows to be fetched...
    while ($list = mysql_fetch_assoc($result)) {
    // echo data


    for ($stars=1;$stars<=floor($list['stars']);$stars++){
    $star_string .= "<img src='images/star.jpg'/>";

    }

    if (($list['stars']-floor($list['stars']))> 0){
    $star_string .= "<img src='images/half_star.jpg'/>";
    }

    $hotels_database .= "<div style='display:table-row;height:70px;'><div style='width:60px;height:60px;display:table-cell;float:left;'><img src='".$list['pic']."' width='60px'/></div>"."<div style='width:280px;display:table-cell;vertical-align:top;text-align:left;padding-left:5px;font-size:12px;'><a href='#' class='database_link'>".$list['hotel']."</a>".$star_string."<br/><span style='font-size:10px;'>".$list['addy']."</span><br/>Guest score: <span style='color:red;font-size:14px;'>".$list['score']."</span> out of 10"."<br/>"."<li class='database_arrow'>Display Amenities & More Info</li>"."</div>"."<div style='width:78px;height:60px;display:table-cell;vertical-align:top;'><span style='font-family:arial;color:green;font-size:15px;'>$".$list['price']."</span><br/>per night<div style='border-radius:10px;background-color:#1284d3;height:25px;width:70px;left:10px;top:10px;position:relative;border:1px black solid;color:white;font-family:arial;line-height:8px;'><br/>select</div><br/></div>"."</div><hr style='color:#c8ff78;'/>";

    $star_string="";
    } // end while

    /******  build the pagination links ******/
    // range of num links to show



    //pagination
    /*     

是的，所以我不知道如何转到下一个偏移量，在这种情况下我应该使用什么href？为什么当前页面查询字符串没有显示在我的 addy 栏中？请看一下，

Answer 1

正如 D.N 所说，代码会有所帮助，但总的来说，它会起作用

if(isset($_GET['offset']) {

$offset = $_get['offset'];

}

其他{

$offset = 0;

}

然后在 SQL 调用中添加:

'无论调用是什么'“limit $limit offset $offset”