search result from sql error with codeigniter's pagination index -

-

i have table pagination. first, select data db, , pagination works perfectly.

then, started filter data (search data, example : using where in sql). pagination's 1st index working (showing data) when click next index (2nd, 3rd) data going default (the filter (where, like) not working).

this model used pagination (i think made mistake here) :

public function get_umat() {         $this->db->select('*')->from('msumat')->limit(10, $this->uri->segment(3));         $this->db->join('mskelas', 'msumat.kelas_id = mskelas.kelas_id');          $search = $this->input->post('ddl_search');         $kelas = $this->input->post('ddl_kelas');         $kelas1 = $this->input->post('ddl_kelas1');         $kelas2 = $this->input->post('ddl_kelas2');         $nama = $this->input->post('txt_nama');         $alamat = $this->input->post('txt_alamat');         $bulan = $this->input->post('ddl_bulan');         $bulan1 = $this->input->post('ddl_bulan1');         $bulan2 = $this->input->post('ddl_bulan2');          if($this->input->post('btn_search'))          {             if($search === 'nama')                 $this->db->like('nama', $nama);              else if($search === 'kelas')                 $this->db->where('mskelas.kelas_id', $kelas);              else if($search === 'range_kelas')                 $this->db->where("mskelas.kelas_id between $kelas1 , $kelas2");              else if($search === 'alamat')                 $this->db->like('alamat', $alamat);              else if($search === 'bulan_lahir')                 $this->db->where("month(tanggal_lahir) = $bulan");              else if($search === 'range_tanggal_lahir')                 $this->db->where("month(tanggal_lahir) between $bulan1 , $bulan2");         }          return $this->db->get()->result();     }  public function count_umat(){         return $this->db->count_all('msumat');     }

then pagination in controller (i think need modify $config['total_rows']):

$config['base_url'] = site_url('/backend_umat/index');         $config['total_rows'] = $this->umat_m->count_umat();         $config['per_page'] = 10;          $config['uri_segment'] = 3;         $config['full_tag_open'] = '<div id="pagination">';         $config['full_tag_close'] = '</div>';          $this->pagination->initialize($config);           $data['pagination'] = $this->pagination->create_links();

i think problems :

  1. i need count search results (for each search) $config['total_rows']
  2. somehow, need modify model (get_umat()) things working

any appreciated. :d

well in ci if want apply search multiple filters works first page , ci url segments, 2nd or 3rd page need send search parameters send first page through form, means url should contain url segments can filter search record because not submitting form 2nd , 3rd page. suggest have on tutorial has nice way use search records multiple filters , work perfect pagination

ci search on tutorial nettuts


Comments

Post a Comment

Popular posts from this blog

Winapi c++: DialogBox hangs when breaking a loop -

-
i've created s simple w32 application cicle through 2 applications(hard coded window classes atm). when call start button (idc_start) works fine, when change focus hwnd application hangs cannot closed. need simple , clean method stop loop, start when calling idc_start. apreciated! #include <stdio.h> #include <stdlib.h> #include <conio.h> #include <windows.h> #include <resource.h> #include <iostream> using namespace std; bool callback dlgproc(hwnd hwnd, uint message, wparam wparam, lparam lparam) { hwnd hwnd1,hwnd2; hwnd1 = findwindow("notepad++",0); hwnd2 = findwindow("notepad",0); bool bdone; switch(message) { case wm_initdialog: // set dialog box, , initialise default values { setdlgitemint(hwnd, idc_number, 5, false); hicon hicon, hiconsm; hicon = (hicon)loadimage(null, "e32.ico", image_icon, 32, 32, lr_loadfromfile); if(hicon) se...
Read more

vb.net - Font adding using PDFsharp -

-
i using pdfsharp add text pdf. when use below code add following text these fonts facing problem. after pdf created using pdfsharp , when opened in adobe reader getting message "cannot find or create font 'windings'. characters may not display or print correctly." opens the source pdf trying modify has fonts helvetica , windings(embedded) this part of code adds text pdf dim font xfont = new xfont("verdana", 20, xfontstyle.regular) gfx.drawstring("hello, world!", font, xbrushes.black, new xrect(0, 0, page.width, page.height), xstringformats.center) font = new xfont("wingdings", 20, xfontstyle.regular) gfx.drawstring("llll", font, xbrushes.black, new xrect(25, 15, page.width, page.height), xstringformats.center) font = new xfont("helvetica", 20, xfontstyle.regular) gfx.drawstring("abcd", font, xbrushes.black, new xrect(50, 25, page.width, page.height), xstringformats.center) after using code text ge...
Read more

javascript - jQuery iScroll clickable list elements while retaining scroll? -

-
is possible have clickable elements? such list elements? while using iscroll? seems short of button, or maybe link can't click on element make something. had similar issue inputs well. enough searching able find solution helped me place work inputs. have need have scrollable ui while having ability click on thats not button or link, such li contained within specific uls. so wondering if there way of having iscroll tell difference between click or tap rather vs scroll, , such have action desired.
Read more