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

Codeigniter-ID pada id_ tidak ikut ke save

Dibuat
Login Terakhir 8 Bulan lalu,
Telah Dilihat 1399 Kali
indrianto adi Mengatakan : Sultan Account
  1. ASK ci
  2. saya punya kendala ID pada id_ tidak ikut kesave tapi data form yang lainnya kesave ke db. berikut adalah tampilan form saya.
  3. tampilan view
  4. https://pastebin.com/UhUhvRbW
  5. tampilan controller
  6. https://pastebin.com/5gf0pkdR
  7. tampilan model
  8. https://pastebin.com/bHaPwywx
  9. mohon bantuannya dan bimbingannya mas/mb
  10. terimasih
Ada 1 File Kiriman :
1. 36541.png (78 KB)

Ada 5 Jawaban

indrianto adi
commented on 10 Apr 2017 21:30:24
  1. tampilan view
  2. <?php
  3. echo "<div class='col-md-12'>
  4. <div class='box box-info'>
  5. <div class='box-header with-border'>
  6. <h3 class='box-title'>Data pesanan</h3>
  7. </div>
  8. <div class='box-body'>";
  9. $attributes = array('class'=>'form-horizontal','role'=>'form');
  10. echo form_open_multipart('Keuangan/tampil_save',$attributes);
  11. echo "<div class='col-md-12'>
  12. <table class='table table-condensed table-bordered'>
  13. <tbody>
  14.  
  15. <tr>
  16. <th width='120px' scope='row'>Nama Paket </th>
  17. <td>
  18. <input type='text' name='id_' class='form-control' value='$rows[nama_paket]' readonly></td>
  19. </tr>
  20. <tr>
  21. <th width='120px' scope='row'>Peminjaman hari </th>
  22.  
  23. <td><input type='text' name='program_hari' class='form-control' value='$rows[program_hari]' readonly></td>
  24. </tr>
  25. <tr>
  26. <th width='250px' scope='row'>Keberangkatan tanggal </th>
  27.  
  28. <td><input type='text' name='keberangkatan_tanggal' class='form-control' value='$rows[keberangkatan_tanggal]' readonly></td>
  29.  
  30. </tr>
  31. <tr>
  32. <th width='120px' scope='row'>Nama Depan</th>
  33. <td><input type='text' name='nama_depan' class='form-control'></td>
  34. <th width='120px' scope='row'>Nama Tengah</th>
  35. <td><input type='text' name='nama_tengah' class='form-control'></td>
  36. </tr>
  37. <tr>
  38.  
  39. <th width='120px' scope='row'>Nama Belakang</th>
  40. <td><input type='text' name='nama_belakang' class='form-control'></td>
  41. <th width='120px' scope='row'>Alamat</th>
  42. <td><textarea type='text' name='alamat' class='form-control'></textarea></td>
  43. </tr>
  44. <tr>
  45.  
  46. <th width='120px' scope='row'>Tanggal lahir</th>
  47. <td><input type='text' name='tgl_lahir' id='tgl_lahir' class='form-control'></td>
  48. <th width='120px' scope='row'>Tempat lahir lahir</th>
  49. <td><input type='text' name='tempat_lahir' class='form-control'></td>
  50. </tr>
  51. <tr>
  52.  
  53. <th width='120px' scope='row'>No HP</th>
  54. <td><input type='text' name='no_hp' class='form-control'></td>
  55. <th width='120px' scope='row'>No tlp</th>
  56. <td><input type='text' name='no_tlp' class='form-control'></td>
  57. </tr>
  58. <tr>
  59.  
  60. <th width='120px' scope='row'>Email</th>
  61. <td><input type='email' name='email' class='form-control'></td>
  62. <th width='120px' scope='row'>Virtual account</th>
  63. <td><input type='text' name='no_virtual_account' class='form-control'></td>
  64. </tr>
  65. <tr>
  66.  
  67. <th width='120px' scope='row'>Tgl Peminjaman</th>
  68. <td><input type='email' name='tgl_issued' id='tgl_issued' class='form-control'></td>
  69. <th width='120px' scope='row'>Tgl expired</th>
  70. <td><input type='text' name='tgl_expired' id='tgl_expired' class='form-control'></td>
  71. </tr>
  72. <tr>
  73.  
  74. <th width='120px' scope='row'>Nama karyawan</th>
  75. <td>
  76.  
  77. <select name='marketing_agent' class='form-control'>
  78. <option value='0'>--pilih refrensi marketing --</option>";
  79. foreach ($agentcabang->result_array() as $row){
  80. if ($rows['id_agent'] == $row['id_agent']){
  81. echo "<option value='$row[id_agent]' selected>$row[nama_agent_cabang]</option>";
  82. }else{
  83. echo "<option value='$row[id_agent]'>$row[nama_agent_cabang]</option>";
  84. }
  85. }
  86. echo "</td></tr>
  87. </tbody>
  88. </table>
  89. </div>
  90. </div>
  91. <div class='box-footer'>
  92. <button type='submit' name='submit' class='btn btn-primary'>Save</button>
  93. <a href='../listbranch'><button type='button' class='btn btn-default pull-right'>Cancel</button></a>
  94.  
  95. </div>
  96. </div>";
  97.  
  98. controllers
  99.  
  100. function tampil_save(){
  101. cek_session_admin();
  102. $id = $this->uri->segment(3);
  103. if (isset($_POST['submit'])){
  104.  
  105. $this->model_main->updatedata();
  106. $this->id_ = $this->session->userdata('id_');
  107. //$data['rows'] = $this->model_main->tampil_save($id)->row_array();
  108. $this->session->set_flashdata("pesan", "<div class=\"col-md-12\"><div class=\"alert alert-success\" id=\"alert\">Data berhasil diupdate!! </div></div>");
  109.  
  110. redirect('Keuangan/tampil_save');
  111. }else{
  112. $data['rows'] = $this->model_main->tampil_save($id)->row_array();
  113.  
  114. $data['agentcabang'] = $this->model_main->joincabang();
  115. $this->session->set_flashdata("pesan", "<div class=\"col-md-12\"><div class=\"alert alert-danger\" id=\"alert\">Gagal!!</div></div>");
  116.  
  117. $this->template->load('Cpanelweb/template','Cpanelweb/mod_cabang/view_tampil_save',$data);
  118. }
  119. }
  120.  
  121. model
  122. function updatedata(){
  123.  
  124. $datadb = array('id_'=>$this->db->escape_str(trim($this->input->post('id_paket'))),
  125. 'nama_depan'=>$this->db->escape_str(trim($this->input->post('nama_depan'))),
  126. 'nama_tengah'=>$this->db->escape_str(trim($this->input->post('nama_tengah'))),
  127. 'nama_belakang'=>$this->db->escape_str(trim($this->input->post('nama_belakang'))),
  128. 'alamat'=>$this->db->escape_str(trim($this->input->post('alamat'))),
  129. 'tgl_lahir'=>$this->db->escape_str(trim($this->input->post('tgl_lahir'))),
  130. 'tempat_lahir'=>$this->db->escape_str(trim($this->input->post('tempat_lahir'))),
  131. 'email'=>$this->db->escape_str(trim($this->input->post('email'))),
  132. 'no_hp'=>$this->db->escape_str(trim($this->input->post('no_hp'))),
  133. 'no_telp'=>$this->db->escape_str(trim($this->input->post('no_telp'))),
  134. 'no_virtual_account'=>$this->db->escape_str(trim($this->input->post('no_virtual_account')))
  135. //'id'=>$this->db->escape_str($this->input->post('nama_bank'))
  136. );
  137. //$this->db->where('id_',$this->input->get('id_'));
  138. $this->db->insert('tbl_customer',$datadb);
  139.  
  140. }
  141.  
  142.  
  143.  
  144.  
PHPMU.COM Support
commented on 10 Apr 2017 21:36:26
  1. Assalam, Coba cek baris ini mas :
  2. Models : $datadb = array('id_'=>$this->db->escape_str(trim($this->input->post('id_paket'))),
  3. Views : <input type='text' name='id_' class='form-control' value='$rows[nama_paket]' readonly></td>
  4.  
  5. data yang dikirmkan dengan name "id_", dan di model diterima "id_paket"
  6. juga pada inputan data yang dikirimkan bukan berupa id sepertinya, karena saya lihat di atas $rows[nama_paket],.
  7. coba share tablenya juga sekalian mas biar lebih jelas,.. :)
indrianto adi
commented on 10 Apr 2017 21:44:12
  1. sudah saya ganti tapi tetap gak bisa mas.. ini mas screenshootannya
Terdapat 2 File dilampirkan :
1. 365411.png (236 KB)
2. asada.png (170 KB)
indrianto adi
commented on 10 Apr 2017 21:45:18
  1. soalnya proses pertamanya.. kita klik data sesuai idnya mas kemudian menampilkan seperti gambar diatas dan id_ tidak ikut ke save
PHPMU.COM Support
commented on 10 Apr 2017 22:12:14
  1. $rows[nama_paket] paket ini yang bermasalah mas, itu datanya dari mana,..
  2. saya lihat dari table gak ada, dan biasanya nama paket isinya huruf/text,
  3. sedangkan yang jadi penampung di tbl_customer type datanya int(), jadinya gak akan mau datanya tersimpan disana,..
  4. seharusnya ambil $rows[id_paket] saja, atau tambahkan 1 inputan lagi dengan type hidden untuk menampung id_paket,..
Maaf, Untuk Memberikan Komentar Anda Harus Login !!!