$totalCount = $db->findRestaurantsCount($nameAddCat); $restaurant_array = $db->findRestaurantsLimitOffset($nameAddCat, N_PER_PAGE, ($currentPage - 1) * N_PER_PAGE); // var_dump($totalCount); // echo '<br>'; // var_dump($restaurant_array); // exit(); if ($nameAddCat == '%') { $restaurantListTitle = "All Restaurants (" . $totalCount . " total)"; } else { $restaurantListTitle = "Your search found " . $totalCount . ($totalCount > 1 ? " restaurants" : " restaurant"); } } else { $totalCount = $db->getAllRestaurantsCount(); $restaurantListTitle = "All Restaurants (" . $totalCount . " total)"; if ($totalCount > N_PER_PAGE) { $restaurant_array = $db->getAllRestaurantsLimitOffset(N_PER_PAGE, 0); } } $numberOfPages = (int) ceil($totalCount / N_PER_PAGE); if ($currentPage <= 5) { $startPage = 1; } else { if ($currentPage > $numberOfPages - 4) { $startPage = $numberOfPages - 8 < 1 ? 1 : $numberOfPages - 8; } } $pageArray = array(); for ($i = 0; $i < 9 && $i < $numberOfPages; $i++) { $pageArray[$i] = $startPage++; } //populates event array