Tanpa basa basi, jadi gini gan ane tuh punya table tentang orderstus, data tuh muncul berdasarkan ane cari (input text + dropdown), nah masalahnya ane tuh mau ada paginationnya.
code:

function cari($id=0) 

 {

 $this->anotherdb = $this->load->database('anotherdb',TRUE);

 $c = $this->input->POST('cari');

 $b = $this->input->POST('by');

 

 $query = $this->db->query("SELECT orderstatusdetail.KPNo as kpno,orderstatusdetail.StyleNo as StyleNo,

 orderstatusdetail.BuyerNo AS BuyerNo,orderstatusdetail.Dest,DATE_FORMAT(orderstatusdetail.CRDDate,'%d %b %Y') AS CRDDate,

 DATE_FORMAT(orderstatusdetail.DelDate,'%d %b %Y') AS DelDate,orderstatus.model AS model,buyernodetail.CMT AS CMT,

 COALESCE(qtyorder,0) AS qtyorder,COALESCE(qtycut,0) AS qtycut, COALESCE(qtysew,0) AS qtysew, COALESCE(qtypack,0) AS qtypack,

 COALESCE(qtyqc,0) AS qtyqc, COALESCE(qtyexp,0) AS qtyexp, 

 CONCAT('Number Of PO : ',v_totaltrack.BuyerNo,' </br>With Total Qty : ',v_totaltrack.Qtysum) AS Remark FROM orderstatusdetail

 INNER JOIN orderstatus ON orderstatus.KPNo=orderstatusdetail.KPNo

 INNER JOIN buyernodetail ON buyernodetail.KPNo=orderstatusdetail.KPNo AND buyernodetail.BuyerNo=orderstatusdetail.BuyerNo

 LEFT JOIN v_qtyorder ON v_qtyorder.kpno=orderstatusdetail.KPNo AND v_qtyorder.BuyerNo=orderstatusdetail.BuyerNo 

 AND v_qtyorder.CRDDate=orderstatusdetail.CRDDate AND v_qtyorder.DelDate=orderstatusdetail.DelDate AND v_qtyorder.Dest=orderstatusdetail.Dest

 LEFT JOIN v_qtycut ON v_qtycut.kpno=orderstatusdetail.KPNo

 LEFT JOIN v_qtysew ON v_qtysew.KPNo=orderstatusdetail.KPNo

 LEFT JOIN v_qtypack ON v_qtypack.KPNo=orderstatusdetail.KPNo AND v_qtypack.BuyerNo=orderstatusdetail.BuyerNo

 LEFT JOIN v_qtyqc ON v_qtyqc.KPNo=orderstatusdetail.KPNo

 LEFT JOIN v_qtyexport ON v_qtyexport.BuyerNo=orderstatusdetail.BuyerNo AND v_qtyexport.kpno=orderstatusdetail.KPNo

 INNER JOIN v_totaltrack ON v_totaltrack.KPNo=orderstatusdetail.KPNo

 WHERE orderstatusdetail.$b='$c'

 GROUP BY orderstatusdetail.KPNo,orderstatusdetail.StyleNo,orderstatus.model,Dest,BuyerNo,

 DelDate,CRDDate 

 ORDER BY orderstatusdetail.KPNo ASC;");

 

 //var_dump($query->result());

 

 //return $query->result(); 

 

 //foreach($query as $row)

 

 //var_dump($query->jumlah);

 

 $batas_data = ceil(40/20);

 

 //var_dump($batas_data);

 //$id='20';

 

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

 $config['base_url'] = site_url('potrack/cari');

 $config['total_rows'] = $query->num_rows();

 $config['per_page'] = 10;

 $config['first_page'] = 'Awal';

 $config['last_page'] = 'Akhir';

 $config['next_page'] = '«';

 $config['prev_page'] = '»';

 

 var_dump($id);



 //inisialisasi config

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



 //buat pagination

 $data['halaman'] = $this->pagination->create_links();

 

 //var_dump($this->pagination->create_links());



 //tamplikan data

 $data['query'] = $this->model_app->caridata($id,$config['per_page']);

 

 

 

 //var_dump($data);

 $this->load->view('element/v_header',$data);

 $this->load->view('track/po',$data);

 }

tapi malah error pas ane next, karena input post gak dapet.
Pertanyaan ane cara dapetin tuh POST input bijimane ya??


Errornya :

A Database Error Occurred

Error Number: 1064



You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '='' GROUP BY orderstatusdetail.KPNo,orderstatusdetail.StyleNo,orderstat' at line 17



SELECT orderstatusdetail.KPNo as kpno,orderstatusdetail.StyleNo as StyleNo, orderstatusdetail.BuyerNo AS BuyerNo,orderstatusdetail.Dest,DATE_FORMAT(orderstatusdetail.CRDDate,'%d %b %Y') AS CRDDate, DATE_FORMAT(orderstatusdetail.DelDate,'%d %b %Y') AS DelDate,orderstatus.model AS model,buyernodetail.CMT AS CMT, COALESCE(qtyorder,0) AS qtyorder,COALESCE(qtycut,0) AS qtycut, COALESCE(qtysew,0) AS qtysew, COALESCE(qtypack,0) AS qtypack, COALESCE(qtyqc,0) AS qtyqc, COALESCE(qtyexp,0) AS qtyexp, CONCAT('Number Of PO : ',v_totaltrack.BuyerNo,' 

With Total Qty : ',v_totaltrack.Qtysum) AS Remark FROM orderstatusdetail INNER JOIN orderstatus ON orderstatus.KPNo=orderstatusdetail.KPNo INNER JOIN buyernodetail ON buyernodetail.KPNo=orderstatusdetail.KPNo AND buyernodetail.BuyerNo=orderstatusdetail.BuyerNo LEFT JOIN v_qtyorder ON v_qtyorder.kpno=orderstatusdetail.KPNo AND v_qtyorder.BuyerNo=orderstatusdetail.BuyerNo AND v_qtyorder.CRDDate=orderstatusdetail.CRDDate AND v_qtyorder.DelDate=orderstatusdetail.DelDate AND v_qtyorder.Dest=orderstatusdetail.Dest LEFT JOIN v_qtycut ON v_qtycut.kpno=orderstatusdetail.KPNo LEFT JOIN v_qtysew ON v_qtysew.KPNo=orderstatusdetail.KPNo LEFT JOIN v_qtypack ON v_qtypack.KPNo=orderstatusdetail.KPNo AND v_qtypack.BuyerNo=orderstatusdetail.BuyerNo LEFT JOIN v_qtyqc ON v_qtyqc.KPNo=orderstatusdetail.KPNo LEFT JOIN v_qtyexport ON v_qtyexport.BuyerNo=orderstatusdetail.BuyerNo AND v_qtyexport.kpno=orderstatusdetail.KPNo INNER JOIN v_totaltrack ON v_totaltrack.KPNo=orderstatusdetail.KPNo WHERE orderstatusdetail.='' GROUP BY orderstatusdetail.KPNo,orderstatusdetail.StyleNo,orderstatus.model,Dest,BuyerNo, DelDate,CRDDate ORDER BY orderstatusdetail.KPNo ASC;



Filename: ******SENSOR*******



Line Number: 42