public function dsbds()
        {
             $this->load->library('pagination');
             $this->load->model('admin_model');
             $result_per_page = 1;  // the number of result per page
             $config['base_url'] = base_url() . '/admin/';
             $config['total_rows'] = $this->admin_model->dsbds();
             $config['per_page'] = $result_per_page;
             $this->pagination->initialize($config);

             $datatable = $this->admin_model->dsbds($result_per_page, $this->uri->segment(3));
             $this->load->view('admin/danhsachbds', array(
                'bds' => $datatable,
                'result_per_page' => $result_per_page
            ));


        }

public function dsbds($limit, $offset)
        {
        $this->db->limit($limit, $offset);
        $q = $this->db->query("SELECT bds.id, duan.tenduan, loaibds.loai, bds.tieude, phongngu.phongngu, phongtam.phongtam, viewbds.view, huongbds.huong, noithat.noithat, bds.dientich, bds.gia, donvibds.donvi, bds.noidung, duan.slugda, bds.slugbds, bds.datecreate, bds.dateupdate FROM bds LEFT JOIN duan ON duan.id=bds.tenduan LEFT JOIN loaibds ON loaibds.id=bds.loai LEFT JOIN phongngu ON phongngu.id=bds.phongngu LEFT JOIN phongtam ON phongtam.id=bds.phongtam LEFT JOIN viewbds ON viewbds.id=bds.view LEFT JOIN huongbds ON huongbds.id=bds.huong LEFT JOIN noithat ON noithat.id=bds.noithat LEFT JOIN donvibds ON donvibds.id=bds.donvi ORDER BY bds.id DESC");

             if($q->num_rows() > 0)
                 return $q->result();
             return false;
        }

<table>

     <tbody>

      <?php foreach($bds as $d) { ?>
        <tr>
        <td><?php echo $d->id; ?></td>
        <td><?php echo $d->tenduan; ?></td>
        <td><?php echo $d->phongngu; ?></td>
        <td><?php echo $d->phongtam; ?></td>
        <td><?php echo $d->dientich; ?></td>
        <td><?php echo $d->noithat; ?></td>
        <td><?php echo $d->gia; ?> <?php echo $d->donvi; ?></td>
        <td><button type="button" class="btn btn-success btn-sm">Edit</button> </td>
         </tr>
                        <?php } ?>
  </tbody>
    <?php echo $this->pagination->create_links();  ?>
  </table>