Advertisement
yhoezt_27

Untitled

Sep 9th, 2020
484
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.87 KB | None | 0 0
  1. Fungsi dasar :
  2. function do_login($username)
  3. {
  4. $CI =& get_instance();
  5. $CI->db->select('tb_user.*, tb_level.*');
  6. $CI->db->from('tb_user');
  7. $CI->db->join('tb_level','tb_user.user_level = tb_level.id_level','left');
  8. $CI->db->where('tb_user.user_username',$username);
  9.  
  10. $result = $CI->db->get();
  11. if($result->num_rows() == 0)
  12. {
  13. return false;
  14. }
  15. else
  16. {
  17. $userdata = $result->row();
  18. $session_data = array(
  19. 'level' => $userdata->user_level,
  20. 'username' => $userdata->user_username,
  21. 'namauser' => $userdata->user_nama,
  22.  
  23. );
  24. $CI->session->set_userdata($session_data);
  25.  
  26. return true;
  27. }
  28. }
  29.  
  30. Penggunaan :
  31. function is_logged_in()
  32. {
  33. $CI =& get_instance();
  34.  
  35. if($CI->session->userdata('username') == '')
  36. {
  37. return false;
  38. }
  39. else
  40. {
  41. return true;
  42. }
  43.  
  44. }
  45.  
  46. function __construct()
  47. {
  48. parent::__construct();
  49. $this->load->library(array('template', 'form_validation', 'pagination'));
  50. if(!$this->auth->is_logged_in())
  51. {
  52. redirect('web');
  53. }
  54.  
  55. }
  56.  
  57. Table :
  58. CREATE TABLE IF NOT EXISTS `tb_user` (
  59. `id_user` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  60. `user_username` varchar(100) DEFAULT NULL,
  61. `user_nama` varchar(100) DEFAULT NULL,
  62. `user_level` int DEFAULT NULL,
  63. `user_foto` varchar(250) DEFAULT NULL,
  64. PRIMARY KEY (`id_user`)
  65. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  66.  
  67. CREATE TABLE IF NOT EXISTS `tb_level` (
  68. `id_level` int NOT NULL,
  69. `nama_level` varchar(50) NOT NULL,
  70. PRIMARY KEY (`id_level`)
  71. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  72.  
  73. CREATE TABLE IF NOT EXISTS `kategori_menu` (
  74. `id_kategori` varchar(50) NOT NULL,
  75. `allowed` varchar(20) DEFAULT NULL,
  76. `sub` varchar(50) DEFAULT NULL,
  77. `icon` varchar(20) DEFAULT NULL,
  78. `alamat` varchar(50) DEFAULT NULL
  79. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  80.  
  81.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement