Laravel -从SQL中获取过滤后的数据，并使用无限滚动分页-在滚动之后，我仍然可以获得所有数据

// routes/web.php
Route::get('/data', [DataController::class, 'index']);

// app/Http/Controllers/DataController.php
namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Models\Data;

class DataController extends Controller
{
    public function index(Request $request)
    {
        $page = $request->input('page', 1);
        $perPage = 10;

        $data = Data::paginate($perPage, ['*'], 'page', $page);

        return response()->json($data);
    }
}

let currentPage = 1;
const perPage = 10;

function loadData() {
    fetch(`/data?page=${currentPage}&perPage=${perPage}`)
        .then(response => response.json())
        .then(data => {
            // 处理数据并显示
            console.log(data);
            currentPage++;
        });
}

window.addEventListener('scroll', () => {
    if (window.innerHeight + window.scrollY >= document.body.offsetHeight - 500) {
        loadData();
    }
});

// 初始加载数据
loadData();