Hallo! Selamat Datang di Marketplace produk digital, Freelancer terbaik di indonesia (67496 Members, 783 Products, 5291 Topic, 12956 Comments)

CARA MENAMPILKAN DATA DI TABEL DENGAN COMBOBOX

Dibuat
Login Terakhir 8 Bulan lalu,
Telah Dilihat 6905 Kali
indrianto adi Mengatakan : Sultan Account
  1. Permisi, bagaimana caranya menampilkan data di tabel sesuai dengan no kwitansi, saya mengalami kendala pada saat saya pilih no invoice 0001/11/03/2017/ yang keluar malah semuanya , berikut scriptnya
  2.  
  3. <div class='col-md-12'>
  4. <div class='box box-info'>
  5. <div class="box-body">
  6. <div class="row">
  7. <form method="get" action="<?php echo base_url("Keuangan/pencarian")?>">
  8. <div class="col-md-2 col-sm-2 col-xs-2" align="center">Pilih invoice
  9. <select class="form-control" name="no_order">
  10. <option>--CHOOSEE--</option>
  11. <?php
  12. foreach($record as $dt){
  13. ?>
  14. <option value="<?php echo $dt['id_pembayaran']?>"><?php echo $dt['no_order']?></option>
  15. <?php
  16. }
  17. ?>
  18. </select>
  19. </div>
  20. <br><input type="submit" class="btn btn-primary" value="Cari">
  21. </div>
  22. </form><br>
  23. <table id="example1" class="table fpTable lcnp table-striped table-bordered table-hover">
  24. <thead>
  25. <tr>
  26. <th class="center" width="10">No</th>
  27. <th class="center span2">no order</th>
  28. <th class="center span2">Tanggal</th>
  29. <th class="center">Harga</th>
  30. </tr>
  31. </thead>
  32. <tbody>
  33. <?php
  34. $i=1;
  35. foreach($hasil as $dt){
  36. ?>
  37. <tr>
  38. <td class="center"><?php echo $i++?></td>
  39. <td class="center"><?php echo $dt['no_order']?></td>
  40. <td class="center"><?php echo $dt['tanggal']?></td>
  41. <td class="center"><?php echo $dt['harga_paket']?></td>
  42.  
  43. </tr>
  44. <?php
  45. }
  46. ?>
  47. </tbody>
  48. </table>
  49. </div>
  50. </div>
  51. </div>
  52. </div>
  53.  
  54.  
  55.  
  56. }
  57. //controllers
  58.  
  59. function pencarian(){
  60. $tingkat=$this->input->get('no_order');
  61. // $status=$this->input->get('status');
  62. $data['record'] = $this->model_main->list_pembayaran()->result_array();
  63. $data['hasil'] = $this->model_main->pencarian_d($tingkat)->result_array();
  64. $this->template->load('Cpanelweb/template','Cpanelweb/mod_keuangan/view_pembayaran', $data);
  65. }
  66.  
  67.  
  68. Model
  69.  
  70. public function pencarian_d($tingkat){
  71. return $this->db->query("SELECT * FROM tbl_customer, tbl_pembayaran, type_tour where tbl_customer.id_cus=tbl_pembayaran.id_cus AND type_tour.id_tour=tbl_pembayaran.id_tour", $tingkat);
  72. }
  73.  
Ada 1 File Kiriman :
1. Screenshot_from_2017-03-13_12:03:04.png (784 KB)

Ada 3 Jawaban

Bagus We Pe
commented on 13 Mar 2017 14:10:13
  1. public function pencarian_d($tingkat){
  2. return $this->db->query("SELECT * FROM tbl_customer, tbl_pembayaran, type_tour where tbl_customer.id_cus=tbl_pembayaran.id_cus AND type_tour.id_tour=tbl_pembayaran.id_tour and tbl_pembayaran.no_order = '".$tingkat."' ");
  3. }
  4.  
PHPMU.COM Support
commented on 13 Mar 2017 20:56:38
  1. Assalam, alhamdulillah sudah dibantu jawab di atas ya mas,.. :)
indrianto adi
commented on 17 Mar 2017 10:14:15
  1. kenapa pas saya pilih di combobox nya tidak sesuai id nya yah ? misalkan ingin menampilkan id di id_agent=1 tapi yang tampil di viewnya malah tidak sesuai berikut scriptny dan screenshootnya
  2.  
  3. //model
  4.  
  5. public function pencarian_cabang($tingkat){
  6. return $this->db->query("SELECT * FROM tbl_customer, tbl_pembayaran, tbl_agent_cabang, tbl_branch where tbl_customer.id_cus=tbl_pembayaran.id_cus AND
  7. tbl_agent_cabang.id_agent=tbl_pembayaran.id_agent AND tbl_pembayaran.id_agent = '".$tingkat."' ");
  8. }
  9.  
  10.  
  11. //controllers
  12. function pencarian_cabang(){
  13. cek_session_admin();
  14. $tingkat=$this->input->get('id_agent');
  15. // $status=$this->input->get('status');
  16. $data['agentcabang'] = $this->model_main->joincabang();
  17. $data['caricabang'] = $this->model_main->pencarian_cabang($tingkat)->result_array();
  18. $this->template->load('Cpanelweb/template','Cpanelweb/mod_cabang/view_jamaah_cabang', $data);
  19. }
Terdapat 3 File dilampirkan :
1. 112.png (65 KB)
2. 27.png (78 KB)
3. 33.png (82 KB)
Maaf, Untuk Memberikan Komentar Anda Harus Login !!!