# How to add Limit to the query in cakephp need help? it's using server side proccessing data-table implement in cakephp

**URL:** <https://discourse.cakephp.org/t/how-to-add-limit-to-the-query-in-cakephp-need-help-its-using-server-side-proccessing-data-table-implement-in-cakephp/6837>\
**Category:** Need Help\
**Created:** [November 2, 2019, 6:54am UTC](https://discourse.cakephp.org/t/how-to-add-limit-to-the-query-in-cakephp-need-help-its-using-server-side-proccessing-data-table-implement-in-cakephp/6837 "2019-11-02T06:54:34Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![spadeX](https://avatars.discourse-cdn.com/v4/letter/s/919ad9/32.png) [@spadeX](https://discourse.cakephp.org/u/spadeX)\
**Post date:** [November 2, 2019, 6:54am UTC](https://discourse.cakephp.org/t/how-to-add-limit-to-the-query-in-cakephp-need-help-its-using-server-side-proccessing-data-table-implement-in-cakephp/6837/1 "2019-11-02T06:54:34Z")

</div>

I have more than 50,000 records i want get an json as limit 10 records to put into data-table so how can put the sql query into cakephp Here is my code : -

```
$this->autoRender= false;
    
    // ini_set('memory_limit','-1');
    $request=$_REQUEST;

    $draw = $request['draw'];
    $page = intval($request['start']);
    $offset = intval($request['length']);
    
    // $sLimit = "";
        if ( ( $page > 0 ) && ( $offset) ) {
     
    // if ( isset( $request['start'] ) && $request['length'] != '-1' ) {

        // $sLimit = " LIMIT ".intval( $request['start'] ).", ".intval( $request['length'] );
        $sql = $this->Leads->find()->limit($offset)->page($page)->toArray();

    }

    else {

        // $sLimit = " LIMIT 0, 10";
        $sql = $this->Leads->find()->limit($offset)->order(['id' => 'ASC'])->toArray();

    }  
            

    //$sql = $this->Leads->find()->limit(10)->toArray();
    $col =array(
        0 => 'id',
        1 => 'company_name',
        2 => 'contact_name_first',
        3 => 'contact_name_last',
        4 => 'phone_no',
        // 5 => 'email',
        6 => 'city',
        7 => 'state',
        8 => 'zip_code',
        // 9 => 'description_of_work'

    ); //create column like table in database
    //$sql ="SELECT * FROM tbperson";
    // $sql = $this->Leads->find()->limit(20)->toArray();

    
     
     $count = $this->Leads->find()->count();
                               
             
     $totalData = $count;
     
    $totalFilter=$totalData;
    
   // $sql ="SELECT * FROM tbperson WHERE 1=1";
    // $sql = $this->Users->find("all")->where([1=>1])->toArray();
    // if(!empty($request['search']['value'])){
    // $sql.=" AND (id Like '".$request['search']['value']."%' ";
    // $sql.=" OR company_name Like '".$request['search']['value']."%' ";
    // $sql.=" OR contact_name_first Like '".$request['search']['value']."%' ";
    // $sql.=" OR contact_name_last Like '".$request['search']['value']."%' )";

    // }
    
    $totalData= $count;
    
    // $sql.=" ORDER BY ".$col[$request['order'][0]['column']]." ".$request['order'][0]['dir']." LIMIT ".
        // $request['start']." ,".$request['length']." ";
    
    

             $data=array();
            foreach ($sql as $key => $value) {
      
                $subdata=array();
                $subdata[]=$value->id; 
                $subdata[]=$value->company_name; 
                $subdata[]=$value->contact_name_first; 
                $subdata[]=$value->contact_name_last; 
                $subdata[]=$value->phone_no; 
                // $subdata[]=$value->email; 
                $subdata[]=$value->city; 
                $subdata[]=$value->state;
                $subdata[]=$value->zip_code;
                // $subdata[]=$value->description_of_work;        
                  //create event on click in button edit in cell datatable for display modal dialog $row[0] is id in table on database
                 $subdata[]='<button type="button" id="getEdit" class="btn btn-primary btn-xs" data-toggle="modal" data-target="#myModal">Edit</button>';
                $data[]=$subdata;
                }

                $json_data=array(
                    "draw" => $draw,
                    "recordsTotal" => $totalData,
                    "recordsFiltered" => $totalFilter,
                    "data" => $data,
                    // "page" => $page,
                    // "offset" => $offset
                );
                echo json_encode($json_data);
```