Changeset 355 for pro-violet-viettel/sourcecode

Timestamp:

Oct 30, 2014 6:24:06 PM (11 years ago)

Author:

quyenla

Message:

collaborator

File:

• pro-violet-viettel/sourcecode/application/modules/admin/controllers/collaborator.php (modified) (1 diff)

pro-violet-viettel/sourcecode/application/modules/admin/controllers/collaborator.php

@@ -38 +38 @@
         if ($this->input->post('keyword'))
         {
-        $sql.=" WHERE (full_name LIKE '%".$this->input->post('keyword')."%' OR login_name LIKE '%".$this->input->post('keyword')."%')";
+        $data['keyword']=$this->input->post('keyword');
+        $sql.=" WHERE (full_name LIKE '%".$data['keyword']."%' OR login_name LIKE '%".$data['keyword']."%')";
         }
 
-        $data['total']=500;
+        $data['total']=$this->db->query($sql)->num_rows();
         $data['start']=($data['current_page']-1)*$data['perpage'];
         $query = $this->db->query($sql." LIMIT ".$data['start'].", ".$data['perpage']."");