javascript - 向下滚动以加载更多搜索数据

我在一起搜索了mysql数据库的以下代码，但我只知道如何创建指向下一页的链接。当我滚动到底部时，有什么方法可以加载更多数据。如果是这样，如何使用以下代码实现它？

$currentPage = $_SERVER["PHP_SELF"];

$maxRows_searchHH = 20;
$pageNum_searchHH = 0;
if (isset($_GET['pageNum_searchHH'])) {
  $pageNum_searchHH = $_GET['pageNum_searchHH'];
}
$startRow_searchHH = $pageNum_searchHH * $maxRows_searchHH;

$colname_searchHH = "-1";
if (isset($_GET['searchString'])) {
  $colname_searchHH = $_GET['searchString'];
}
mysql_select_db($database_conn_happyhours, $conn_happyhours);
$query_searchHH = sprintf("SELECT name, address, hhName, phone, dayOfTheWeek, hours, `description`, imageURL, website, cost, googleMap FROM happyhours WHERE address LIKE %s ORDER BY name ASC", GetSQLValueString("%" . $colname_searchHH . "%", "text"));
$query_limit_searchHH = sprintf("%s LIMIT %d, %d", $query_searchHH, $startRow_searchHH, $maxRows_searchHH);
$searchHH = mysql_query($query_limit_searchHH, $conn_happyhours) or die(mysql_error());
$row_searchHH = mysql_fetch_assoc($searchHH);

if (isset($_GET['totalRows_searchHH'])) {
  $totalRows_searchHH = $_GET['totalRows_searchHH'];
} else {
  $all_searchHH = mysql_query($query_searchHH);
  $totalRows_searchHH = mysql_num_rows($all_searchHH);
}
$totalPages_searchHH = ceil($totalRows_searchHH/$maxRows_searchHH)-1;

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

最佳答案

您想要的就是无限滚动。另一个可能对您有用的问题在这里：Infinite scrolling inside a div with AJAX (jQuery) loaded date