Hallo! Selamat Datang di Marketplace produk digital, Freelancer terbaik di indonesia (69437 Members, 807 Products, 4726 Topic, 13078 Comments)

CARA MENAMPILKAN DATA DI TABEL DENGAN COMBOBOX

Dibuat
Login Terakhir 10 Bulan lalu,
Telah Dilihat 8100 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 !!!

Online