搜索结果分页

我的分页在第一页上正常工作。它正确地显示了2个名字。当我想在下一页上看到其他结果时，它将不显示我当前的代码。当我创建一个静态数组:

 $searchResults = [
            'item1',
            'item2',
            'item3',
            'item4',
            'item5',
            ];

它将在不同的页面上正确显示数组。当我从sql查询生成一个数组时，它在下一页上什么也不显示。我使用了var_dump，在第二页上，我没有看到我创建的数组的任何内容。

public function zoekdocument(Request $request) //voor het zoeken van software
{
$zoekdocument = 'Request::get('zoekdocument');
$searchResult = array();
$searchdoc = 'DB::table('visits')->where('title', 'LIKE', '%' . $zoekdocument . '%')->paginate();
foreach($searchdoc as $searchdocument){ 
    $filedir = $searchdocument->pagename; //wordt gedurende loop tot die finisht in de array gezet.
    $searchResult[] = $filedir; //dat wordt hier gedaan.
}
    $currentPage = LengthAwarePaginator::resolveCurrentPage();
    $page = $request->has('page') ? $request->get('page') : 1;
    //Create a new Laravel collection from the array data
    $collection = new Collection($searchResult);
    $perPage = 2;
   $currentPageSearchResults = $collection-> slice (($currentPage -1) * $perPage, $perPage)->all();
    //Create our paginator and pass it to the view
    $paginatedSearchResults= new 
LengthAwarePaginator($currentPageSearchResults, count($collection), $perPage, $page, ['path'  => $request->url(),'query' => $request->query(),
return view('Documentatie.result', ['results' => $paginatedSearchResults])->with('zoekdocument', $zoekdocument);

@section('content')
<!-- Striped rows -->
<div class="panel panel-flat">
  <div class="panel-heading">
    <h5 class="panel-title text-center">Documentatie overzicht resultaat</h5>
    <div class="heading-elements">
    </div>
  </div>
  <div class="text-center">
    <h2>Zoekresultaat van: <b><i>{{$zoekdocument}}</b></i></h5>
    </div>  
 @foreach ($results as $result)
        <p>{{ $result }}</p>
    @endforeach
    <?php echo $results->render(); ?>


@endsection