How to loop through the page and insert data using Laravel

Question

I want to perform an insert into the database on each paginated page, starting from the first page and ending with the last page, until the last page is completed. But the problem is, I tried this code, but it only loops through 5 pieces of data (based on the first pagination) and keeps going.

Thanks to anyone who solves my problem. :)

public function __construct()
{
    $this->data = new Data();
}
public function dumData()
{
    $data = $this->data->paginate(5);
    return $data;
}

public function test()
{
    $page = 1;

    do {
        $dataPaginated = $this->dumData($page);

        $data = $dataPaginated->items();

        foreach ($data as $result) {
            DB::table('test')->insert([
                'name' => $result->name,
                'data' => json_encode($result),
                'created_at' => Carbon::now(),
                'updated_at' => Carbon::now()
            ]);
        }

        $page;

        $nextpage = $dataPaginated->nextPageUrl();
    } while ($nextpage);

    return 'success';
}

Answer 1

Try changing your dumData() method to the following:

public function dumData($pageNumber)
{
    $data = $this->data->paginate(5, ['*'], 'page', $pageNumber);
    return $data;
}

You can also consider using chunks to obtain data