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

insert ke database berdasar user login di codeigniter

Dibuat
Login Terakhir 2 Tahun lalu,
Telah Dilihat 4144 Kali
Nanang Prasetiyan Mengatakan : Free Account
  1. Assalamualaikum , saya mau tanya, gimana caranya ketika mau insert ke database tetapi id member/admin juga ikut ke simpen?
  2. Makasih sebelumnya
Ada 2 File Kiriman :
1. controler_member.JPG (55 KB)
2. mod_member.JPG (37 KB)

Ada 4 Jawaban

PHPMU.COM Support
commented on 22 Des 2017 06:24:57
  1. Waalaikumsalam.w.w
  2. Session ini isinya apa : $this->session->userdata('member_login');
  3. yang saya tau bukan begini : $id = $logged_data['id_member'];
  4.  
  5. untuk menyimpan data user login, cukup ambil dari session yang di create dari login saja..
  6. misalnya untuk session login jika sukses akan dibuat session seperti berikut :
  7. <?php
  8. $this->session->set_userdata(array('id_members'=>$row['id_members']));
  9. ?>
  10.  
  11. jadi saat insert data jadi begini :
  12. <?php
  13. $data = array('data'=>$this->input->post('judul'),
  14. 'id_member'=>$this->session->id_members);
  15. ?>
  16. Udah gitu saja dan seelsai,.. :)
Nanang Prasetiyan
commented on 22 Des 2017 16:34:30
  1. $this->session->userdata('member_login'); untuk memastikan aja bahwa member sudah login
  2. oke mas tak cobanya
Nanang Prasetiyan
commented on 22 Des 2017 17:08:17
  1. kok belum bisa ya mas apa ada yang salah discriptnya berikut
  2. <!- -controller- ->
  3. public function auth()
  4. {
  5. if(isset($_POST['submit']))
  6. {
  7. // proses login
  8. $username= $this->input->post('username_member');
  9. $password= $this->input->post('password_member');
  10. $chek= $this->db->get_where('member',array('username'=>$username,'password_m'=>md5($password)));
  11. if($chek->num_rows()>0)
  12. {
  13. // $data_session = array(
  14. // 'id_member' => $username,
  15. // 'status' => "login"
  16. // );
  17. $this->session->set_userdata(array(
  18. 'id_member'=>$row['id_member'],
  19. 'status' => "login"
  20. ));
  21. // $this->session->set_userdata($data_session);
  22. // $this->template->load('member/template_member', 'member/dashboard_member');
  23. redirect('member');
  24. }else{
  25. $this->session->set_flashdata('gagal_login', '<div class="alert alert-dismissible alert-danger">
  26. <button type="button" class="close" data-dismiss="alert">×</button>Username dan Password Salah</b></div>');
  27. redirect('member');
  28. }
  29. }
  30. }
  31. function add_contact()
  32. {
  33. if(isset($_POST['submit'])){
  34. $this->mod_member->setting_contact();
  35. redirect('member/setting');
  36. }else{
  37. $this->template->load('member/theme_member','member/kontak/post_kontak');
  38. }
  39. }
  40. <!- -model- ->
  41. function setting_contact()
  42. {
  43. $data=array(
  44. 'alamat_usaha'=> $this->input->post('alamat'),
  45. 'email' => $this->input->post('email'),
  46. 'no_telp' => $this->input->post('noHP'),
  47. 'id_member'=>$this->session->id_members
  48. );
  49. $this->db->insert('web_contact_member',$data);
PHPMU.COM Support
commented on 23 Des 2017 11:20:55
  1. $row['id_member'] // ini datanya dari mana??
  2. $this->session->id_members // Kok malah jadi id_members? saat create session saya lihat id_member (Tanpa huruf s)
  3.  
  4. Ya udah saya bantu benerin saja ya,.. :)
  5. <?php
  6. public function auth(){
  7. if(isset($_POST['submit'])){
  8. // proses login
  9. $username= $this->input->post('username_member');
  10. $password= $this->input->post('password_member');
  11. $chek= $this->db->get_where('member',array('username'=>$username,'password_m'=>md5($password)));
  12. if($chek->num_rows()>0){
  13. $row = $chek->row_array();
  14. $this->session->set_userdata(array(
  15. 'id_member'=>$row['id_member'],
  16. 'status' => "login"
  17. ));
  18. redirect('member');
  19. }else{
  20. $this->session->set_flashdata('gagal_login', '<div class="alert alert-dismissible alert-danger">
  21. <button type="button" class="close" data-dismiss="alert">×</button>Username dan Password Salah</b></div>');
  22. redirect('member');
  23. }
  24. }
  25. }
  26.  
  27. function setting_contact()
  28. $data = array('alamat_usaha'=> $this->input->post('alamat'),
  29. 'email' => $this->input->post('email'),
  30. 'no_telp' => $this->input->post('noHP'),
  31. 'id_member'=>$this->session->id_member);
  32. $this->db->insert('web_contact_member',$data);
  33. }
  34. ?>
  35.  
  36. Note : Jangan Lupa untuk lebih teliti lagi ngetik kodenya,.. :)
  37.  
Maaf, Untuk Memberikan Komentar Anda Harus Login !!!