When i try the single line, it doesn’t sort.

Thank you.  My goal is to have 2 horizontal scrollbars, one at the bottom of the data grid like I have now and one additional one above the data.

http://www.ok-soft-gmbh.com/jqGrid/FrozenColumnsAndScrollbarOnTop.htm

I had to write the entire paginator…….

    // coming in from jqGrid
        Log::info(Input::all());
            // array (
            //   ‘_search’ => ‘false’,            // search enabled
            //   ‘nd’ => ‘1410449702065’,
            //   ‘per_page’ => ’10’,
            //   ‘current_page’ => ‘1’,
            //   ‘sidx’ => ‘CompanyName’,
            //   ‘sord’ => ‘desc’,
            // )

        $page = Input::get(“page”, 1);    // get the requested page
        $limit = Input::get(“rows”); // get how many rows we want to have into the grid
        $sidx = Input::get(“sidx”, 1); // get index row – i.e. user click to sort
        $sord = Input::get(“sord”, “asc”); // get the direction
          if (!$limit) $limit = 25;

        $count = DB::table(‘customers’)->count();
        
        // calculate the total pages for the query
        if( $count > 0 && $limit > 0) {
            $count = ceil($count/$limit);
        } else {
            $count = 0;
        }
        
        // if for some reasons the requested page is greater than the total
         // set the requested page to total page
        if ($page > $count) $page=$count;

        // calculate the starting position of the rows
          $start = $limit * $page – $limit; // do not put $limit*($page – 1)

        // if for some reasons start position is negative set it to 0
          // typical case is that the user type 0 for the requested page
          if($start <0) $start = 0;

          Log::info($sidx . “|” . $sord . “|” . $limit . “|” . $start);

        $results = DB::table(‘customers’)->orderBy($sidx, $sord)->take($limit)->skip($start)->get();
        
        Log::info($results);
        //$paginationResults = Paginator::make( $rows, $count, $page);
             //$items – record set of query result
             //$total – number of records into fetch result
             //$per_page – number of records per page you want

        //$results = Customer::all();
        //$arr = [“page” => 1, “records” => 4, ‘total’=> 2, ‘rows’ => $results];
        $arr = [“page” => $page, “records” => $limit, ‘total’=> $count, ‘rows’ => $results];
        //return Response::json($arr);

        return Response::json($arr);

paste was wrong.