* 일반 쿼리문에 $limit, $offset 을 넣듯이 stored procedure 안에  $limit, $offset을 넣어서 페이징을 처리하고 싶습니다.

---- class Board extends CI_Controller ----------

     $this->load->library('pagination'); 

      $config['first_url'] = site_url() . '/board/index/page/1?'.http_build_query($_GET);

      $config['base_url']=site_url() . '/board/index/page';

      $config['total_rows']=$this->board_m->getBoards('num_rows', '', '', $idx, $send_phon, $recv_phon, $title_1, $send_how,

      $recv_how, $send_date, $send_date1,  $send_date2, $recv_date, $speck_wait_time, $speck_time, $p_value, $send, $recv);

      $config['per_page'] = 10;

      $config['suffix'] = '?'.http_build_query($_GET,'',"&");

      $config['suffix']='?'.http_build_query($_GET,'',"&");

중간생략..

 $this->pagination->initialize($config);

 $data['pagination']=$this->pagination->create_links();        $data['num_rows']=$config['total_rows'];

 $page = $this->uri->segment(4, 1);

  if ($page > 1) {

            $offset=(($page / $config['per_page'])) * $config['per_page'];

        } else {

            $offset=($page - 1) * $config['per_page'];

        }        

        $data['list']=$this->board_m->getBoards('', $offset, $config['per_page'], $idx , $send_phon, $recv_phon, $title_1, $send_how, $recv_how, $send_date,  $send_date1, $send_date2,  $recv_date, $speck_wait_time, $speck_time, $p_value, $send, $recv, $field, $sort);

생략..

---------------- class Board_m extends CI_Model ---------------

function getBoards($kind='', $offset='', $limit='', $idx='', $send_phon='', $recv_phon='', $title_1='', $send_how='', $recv_how='', $send_date='', $send_date1='', $send_date2='', $recv_date='', $speck_wait_time, $speck_time, $p_value, $send, $recv, $field='', $sort='') {        //mysql에서 limit는 가져오는 row의 개수, offset은 몇번째 row 부터 가져올지를 결정

     if (!isset($field)){

         $this->db->order_by($field, $sort); 

      } else {

            $this->db->order_by($field, $sort);

     }

$query = $this->db->query("CALL select_intphon_sr($send_date1, $send_date2)"); 

$this->db->close();

if ($kind == 'num_rows') {

            $result=$query->num_rows();

 } else {

            $this->db->limit($limit, $offset);

           $result=$query->result(); 

 }

 return $result;

}