Difference between revisions of "Login CodeIgniter"

From belajarwiki
Jump to navigation Jump to search
 
(15 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
==Login==
+
==Database==
−
===Database===
+
===Create Database===
−
====Create Database====
+
CREATE DATABASE my_db;
 +
 
 +
===Create Table===
 
  CREATE TABLE `user` (
 
  CREATE TABLE `user` (
−
   `id` int(11) NOT NULL AUTO INCREMENT,
+
   `user_id` int(11) NOT NULL AUTO_INCREMENT,
−
   `fullname` varchar(32) NOT NULL,
+
   `name` varchar(32) NOT NULL,
 
   `username` varchar(64) NOT NULL,
 
   `username` varchar(64) NOT NULL,
 
   `password` varchar(255) NOT NULL,
 
   `password` varchar(255) NOT NULL,
−
   `role` int(11) NOT NULL
+
   `role` int(11) NOT NULL,
−
   PRIMARY KEY (`id`)
+
  `user_status` int(11) NOT NULL,
−
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
+
   PRIMARY KEY (`user_id`)
 +
  );
 +
 
 +
===Insert Data===
 +
 
 +
Jika menggunakan SHA
  
−
====Insert Data====
+
  INSERT INTO user VALUES
−
  INSERT INTO table_user VALUES
+
  ('1','User','user',SHA2('user123', 512),'2','1'),
−
  ('','User','user',SHA2('user123', 224),'2'),
+
  ('2','Admin','admin',SHA2('admin123', 512),'1','1');
−
  ('','Admin','admin',SHA2('admin123', 224),'1');
 
  
−
===Controller===
+
 
−
<?php
+
Jika menggunakan MD5
−
defined('BASEPATH') OR exit('No direct script access allowed');
+
 
−
class Login extends CI_Controller {
+
INSERT INTO user VALUES
 +
('1','User','user',MD5('user123'),'2','1'),
 +
('2','Admin','admin',MD5('admin123'),'1','1');
 +
 
 +
==Controller==
 +
===Login===
 +
<pre>
 +
<?php
 +
defined('BASEPATH') OR exit('No direct script access allowed');
 +
class Login extends CI_Controller {
 
     function __construct(){
 
     function __construct(){
 
         parent::__construct();
 
         parent::__construct();
−
$this->load->model('Mlogin','Mlogin');
+
        $this->load->model('Model_login','Model_login');
 
     }   
 
     }   
 +
 
     function index(){
 
     function index(){
 
         if($this->session->userdata('logged') !=TRUE){
 
         if($this->session->userdata('logged') !=TRUE){
Line 32: Line 48:
 
         };
 
         };
 
     }   
 
     }   
−
     function autentikasi(){
+
 
−
         $email = $this->input->post('email');
+
     function auth(){
 +
         $username = $this->input->post('username');
 
         $password = $this->input->post('pass');               
 
         $password = $this->input->post('pass');               
−
         $validasi_email = $this->Mlogin->query_validasi_email($email);
+
         $validasi = $this->Model_login->query_validasi_username($username);
−
         if($validasi_email->num_rows() > 0){
+
         if($validasi->num_rows() > 0){
−
             $validate_ps=$this->Mlogin->query_validasi_password($email,$password);
+
             $validate_pswd=$this->Model_login->query_validasi_password($username,$password);
−
             if($validate_ps->num_rows() > 0){
+
             if($validate_pswd->num_rows() > 0){
−
                 $x = $validate_ps->row_array();
+
                 $x = $validate_pswd->row_array();
 
                 if($x['user_status']=='1'){
 
                 if($x['user_status']=='1'){
 
                     $this->session->set_userdata('logged',TRUE);
 
                     $this->session->set_userdata('logged',TRUE);
−
                     $this->session->set_userdata('user',$email);
+
                     $this->session->set_userdata('user',$username);
 
                     $id=$x['user_id'];
 
                     $id=$x['user_id'];
−
                     if($x['user_akses']=='1'){ //Administrator
+
                     if($x['role']=='1'){ //Administrator
−
                         $name = $x['user_name'];
+
                         $name = $x['name'];
 
                         $this->session->set_userdata('access','Administrator');
 
                         $this->session->set_userdata('access','Administrator');
 
                         $this->session->set_userdata('id',$id);
 
                         $this->session->set_userdata('id',$id);
 
                         $this->session->set_userdata('name',$name);
 
                         $this->session->set_userdata('name',$name);
 
                         redirect('home');
 
                         redirect('home');
−
                     }else if($x['user_akses']=='2'){ //User
+
                     }else if($x['role']=='2'){ //User
−
                         $name = $x['user_name'];
+
                         $name = $x['name'];
−
                         $this->session->set_userdata('access','Dosen');
+
                         $this->session->set_userdata('access','User');
 
                         $this->session->set_userdata('id',$id);
 
                         $this->session->set_userdata('id',$id);
 
                         $this->session->set_userdata('name',$name);
 
                         $this->session->set_userdata('name',$name);
 
                         redirect('home');
 
                         redirect('home');
 +
                    }
 
                 }else{
 
                 }else{
 
                     $url=base_url('login');
 
                     $url=base_url('login');
−
                     echo $this->session->set_flashdata('msg','<span onclick="this.parentElement.style.display=`none`" class="w3-button w3-large w3-display-topright">&times;</span>
+
                     echo $this->session->set_flashdata('msg','<span onclick="this.parentElement.style.display=`none`" class="w3-button w3-large w3-display-topright">×</span>
 
                     <h3>Uupps!</h3>
 
                     <h3>Uupps!</h3>
 
                     <p>Akun kamu telah di blokir. Silahkan hubungi admin.</p>');
 
                     <p>Akun kamu telah di blokir. Silahkan hubungi admin.</p>');
Line 65: Line 83:
 
             }else{
 
             }else{
 
                 $url=base_url('login');
 
                 $url=base_url('login');
−
                 echo $this->session->set_flashdata('msg','<span onclick="this.parentElement.style.display=`none`" class="w3-button w3-large w3-display-topright">&times;</span>
+
                 echo $this->session->set_flashdata('msg','<span onclick="this.parentElement.style.display=`none`" class="w3-button w3-large w3-display-topright">×</span>
 
                     <h3>Uupps!</h3>
 
                     <h3>Uupps!</h3>
 
                     <p>Password yang kamu masukan salah.</p>');
 
                     <p>Password yang kamu masukan salah.</p>');
Line 72: Line 90:
 
         }else{
 
         }else{
 
             $url=base_url('login');
 
             $url=base_url('login');
−
             echo $this->session->set_flashdata('msg','<span onclick="this.parentElement.style.display=`none`" class="w3-button w3-large w3-display-topright">&times;</span>
+
             echo $this->session->set_flashdata('msg','<span onclick="this.parentElement.style.display=`none`" class="w3-button w3-large w3-display-topright">×</span>
 
             <h3>Uupps!</h3>
 
             <h3>Uupps!</h3>
 
             <p>Email yang kamu masukan salah.</p>');
 
             <p>Email yang kamu masukan salah.</p>');
Line 78: Line 96:
 
         }
 
         }
 
     }
 
     }
 +
 
     function logout(){
 
     function logout(){
 
         $this->session->sess_destroy();
 
         $this->session->sess_destroy();
Line 83: Line 102:
 
         redirect($url);
 
         redirect($url);
 
     }
 
     }
−
  }
+
}
 +
</pre>
 +
 
 +
===Home===
 +
<pre>
 +
<?php
 +
defined('BASEPATH') OR exit('No direct script access allowed');
 +
 
 +
class Home extends CI_Controller {
 +
function __construct(){
 +
parent::__construct();
 +
if($this->session->userdata('logged') !=TRUE){
 +
                    $url=base_url('login');
 +
                    redirect($url);
 +
};
 +
}
 +
 +
public function index()
 +
{
 +
$this->load->view('view-home');
 +
}
 +
}
 +
</pre>
 +
 
 +
 
 +
==Model==
 +
===Login===
 +
<pre>
 +
<?php
 +
defined('BASEPATH') OR exit('No direct script access allowed');
 +
 
 +
class Model_login extends CI_Model{
 +
 
 +
    function query_validasi_username($username){
 +
    $result = $this->db->query("SELECT * FROM user WHERE username='$username' LIMIT 1");
 +
        return $result;
 +
    }
 +
 
 +
    function query_validasi_password($username,$password){
 +
    $result = $this->db->query("SELECT * FROM user WHERE username='$username' AND user_password=SHA2('$password', 224) LIMIT 1");
 +
        return $result;
 +
    }
 +
 
 +
}
 +
</pre>
 +
 
 +
==View==
 +
===View Login===
 +
<pre>
 +
<link href="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
 +
<script src="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/js/bootstrap.min.js"></script>
 +
<script src="//cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
 +
<link rel="stylesheet" type="text/css" href="<?php echo base_url();?>assets/css/login.css">
 +
 
 +
<div class="container login-container">
 +
    <div class="row">
 +
        <div class="col-md-6 login-form-1">
 +
            <h3>Login for Form 1</h3>
 +
            <form>
 +
                <div class="form-group">
 +
                    <input type="text" class="form-control" placeholder="Your Email *" value="" />
 +
                </div>
 +
                <div class="form-group">
 +
                    <input type="password" class="form-control" placeholder="Your Password *" value="" />
 +
                </div>
 +
                <div class="form-group">
 +
                    <input type="submit" class="btnSubmit" value="Login" />
 +
                </div>
 +
                <div class="form-group">
 +
                    <a href="#" class="ForgetPwd">Forget Password?</a>
 +
                </div>
 +
            </form>
 +
        </div>
 +
        <div class="col-md-6 login-form-2">
 +
            <h3>Login for Form 2</h3>
 +
            <form>
 +
                <div class="form-group">
 +
                    <input type="text" class="form-control" placeholder="Your Email *" value="" />
 +
                </div>
 +
                <div class="form-group">
 +
                    <input type="password" class="form-control" placeholder="Your Password *" value="" />
 +
                </div>
 +
                <div class="form-group">
 +
                    <input type="submit" class="btnSubmit" value="Login" />
 +
                </div>
 +
                <div class="form-group">
 +
 
 +
                    <a href="#" class="ForgetPwd" value="Login">Forget Password?</a>
 +
                </div>
 +
            </form>
 +
        </div>
 +
    </div>
 +
</div>
 +
</pre>
 +
 
 +
Dengan CSS nya
 +
<pre>
 +
.login-container{
 +
    margin-top: 5%;
 +
    margin-bottom: 5%;
 +
}
 +
.login-form-1{
 +
    padding: 5%;
 +
    box-shadow: 0 5px 8px 0 rgba(0, 0, 0, 0.2), 0 9px 26px 0 rgba(0, 0, 0, 0.19);
 +
}
 +
.login-form-1 h3{
 +
    text-align: center;
 +
    color: #333;
 +
}
 +
.login-form-2{
 +
    padding: 5%;
 +
    background: #0062cc;
 +
    box-shadow: 0 5px 8px 0 rgba(0, 0, 0, 0.2), 0 9px 26px 0 rgba(0, 0, 0, 0.19);
 +
}
 +
.login-form-2 h3{
 +
    text-align: center;
 +
    color: #fff;
 +
}
 +
.login-container form{
 +
    padding: 10%;
 +
}
 +
.btnSubmit
 +
{
 +
    width: 50%;
 +
    border-radius: 1rem;
 +
    padding: 1.5%;
 +
    border: none;
 +
    cursor: pointer;
 +
}
 +
.login-form-1 .btnSubmit{
 +
    font-weight: 600;
 +
    color: #fff;
 +
    background-color: #0062cc;
 +
}
 +
.login-form-2 .btnSubmit{
 +
    font-weight: 600;
 +
    color: #0062cc;
 +
    background-color: #fff;
 +
}
 +
.login-form-2 .ForgetPwd{
 +
    color: #fff;
 +
    font-weight: 600;
 +
    text-decoration: none;
 +
}
 +
.login-form-1 .ForgetPwd{
 +
    color: #0062cc;
 +
    font-weight: 600;
 +
    text-decoration: none;
 +
}
 +
</pre>
 +
 
 +
===View Home===
 +
<pre>
 +
<!DOCTYPE html>
 +
<html lang="en">
 +
<head>
 +
    <meta charset="UTF-8">
 +
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
 +
    <title>Home</title>
 +
    <link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
 +
</head>
 +
<body>
 +
    <div class="w3-bar w3-border w3-light-grey w3-card-4">
 +
        <a href="#" class="w3-bar-item w3-blue w3-button">Home</a>
 +
        <?php if($this->session->userdata('access')=='Administrator'){ ?>
 +
            <a href="#" class="w3-bar-item w3-button">Daftar Satu</a>
 +
            <a href="#" class="w3-bar-item w3-button">Daftar Dua</a>
 +
            <a href="#" class="w3-bar-item w3-button">Daftar Tiga</a>
 +
        <?php } if($this->session->userdata('access')=='User'){ ?>
 +
            <a href="#" class="w3-bar-item w3-button">Daftar Empat</a>
 +
        <?php }; ?>
 +
        <a href="<?php echo site_url('login/logout');?>" class="w3-bar-item w3-button w3-red w3-right">Keluar</a>
 +
    </div>
 +
    <div class="w3-container">
 +
        <h1>Hai <?php echo $this->session->userdata('name'); ?></h1>
 +
        <h3>Ini adalah halaman untuk <?php echo $this->session->userdata('access'); ?></h3>
 +
    </div>
 +
</body>
 +
</html>
 +
</pre>
 +
 
 +
==Pranala Menarik==
 +
* [[Website]]
 +
* [[CodeIgniter]]
 +
 
 +
==Referensi==
 +
* https://bootsnipp.com/tags/login

Latest revision as of 15:28, 22 November 2021

Database

Create Database

CREATE DATABASE my_db;

Create Table

CREATE TABLE `user` (
 `user_id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(32) NOT NULL,
 `username` varchar(64) NOT NULL,
 `password` varchar(255) NOT NULL,
 `role` int(11) NOT NULL,
 `user_status` int(11) NOT NULL,
 PRIMARY KEY (`user_id`)
);

Insert Data

Jika menggunakan SHA 

INSERT INTO user VALUES
('1','User','user',SHA2('user123', 512),'2','1'),
('2','Admin','admin',SHA2('admin123', 512),'1','1');


Jika menggunakan MD5 

INSERT INTO user VALUES
('1','User','user',MD5('user123'),'2','1'),
('2','Admin','admin',MD5('admin123'),'1','1');

Controller

Login

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Login extends CI_Controller {
    function __construct(){
        parent::__construct();
        $this->load->model('Model_login','Model_login');
    }   

    function index(){
        if($this->session->userdata('logged') !=TRUE){
            $this->load->view('view-login');
        }else{
            $url=base_url('home');
            redirect($url);
        };
    }   

    function auth(){
        $username = $this->input->post('username');
        $password = $this->input->post('pass');               
        $validasi = $this->Model_login->query_validasi_username($username);
        if($validasi->num_rows() > 0){
            $validate_pswd=$this->Model_login->query_validasi_password($username,$password);
            if($validate_pswd->num_rows() > 0){
                $x = $validate_pswd->row_array();
                if($x['user_status']=='1'){
                    $this->session->set_userdata('logged',TRUE);
                    $this->session->set_userdata('user',$username);
                    $id=$x['user_id'];
                    if($x['role']=='1'){ //Administrator
                        $name = $x['name'];
                        $this->session->set_userdata('access','Administrator');
                        $this->session->set_userdata('id',$id);
                        $this->session->set_userdata('name',$name);
                        redirect('home');
                    }else if($x['role']=='2'){ //User
                        $name = $x['name'];
                        $this->session->set_userdata('access','User');
                        $this->session->set_userdata('id',$id);
                        $this->session->set_userdata('name',$name);
                        redirect('home');
                    }
                }else{
                    $url=base_url('login');
                    echo $this->session->set_flashdata('msg','<span onclick="this.parentElement.style.display=`none`" class="w3-button w3-large w3-display-topright">×</span>
                    <h3>Uupps!</h3>
                    <p>Akun kamu telah di blokir. Silahkan hubungi admin.</p>');
                    redirect($url);
                }
            }else{
                $url=base_url('login');
                echo $this->session->set_flashdata('msg','<span onclick="this.parentElement.style.display=`none`" class="w3-button w3-large w3-display-topright">×</span>
                    <h3>Uupps!</h3>
                    <p>Password yang kamu masukan salah.</p>');
                redirect($url);
            }
        }else{
            $url=base_url('login');
            echo $this->session->set_flashdata('msg','<span onclick="this.parentElement.style.display=`none`" class="w3-button w3-large w3-display-topright">×</span>
            <h3>Uupps!</h3>
            <p>Email yang kamu masukan salah.</p>');
            redirect($url);
        }
    }

    function logout(){
        $this->session->sess_destroy();
        $url=base_url('login');
        redirect($url);
    }
}

Home

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Home extends CI_Controller {
	function __construct(){
		parent::__construct();
		if($this->session->userdata('logged') !=TRUE){
                    $url=base_url('login');
                    redirect($url);
		};
	}
	
	public function index()
	{
		$this->load->view('view-home');
	}
}


Model

Login

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Model_login extends CI_Model{

    function query_validasi_username($username){
    	$result = $this->db->query("SELECT * FROM user WHERE username='$username' LIMIT 1");
        return $result;
    }

    function query_validasi_password($username,$password){
    	$result = $this->db->query("SELECT * FROM user WHERE username='$username' AND user_password=SHA2('$password', 224) LIMIT 1");
        return $result;
    }

}

View

View Login

<link href="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
<script src="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/js/bootstrap.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<link rel="stylesheet" type="text/css" href="<?php echo base_url();?>assets/css/login.css">

<div class="container login-container">
    <div class="row">
        <div class="col-md-6 login-form-1">
            <h3>Login for Form 1</h3>
            <form>
                <div class="form-group">
                    <input type="text" class="form-control" placeholder="Your Email *" value="" />
                </div>
                <div class="form-group">
                    <input type="password" class="form-control" placeholder="Your Password *" value="" />
                </div>
                <div class="form-group">
                    <input type="submit" class="btnSubmit" value="Login" />
                </div>
                <div class="form-group">
                    <a href="#" class="ForgetPwd">Forget Password?</a>
                </div>
            </form>
        </div>
        <div class="col-md-6 login-form-2">
            <h3>Login for Form 2</h3>
            <form>
                <div class="form-group">
                    <input type="text" class="form-control" placeholder="Your Email *" value="" />
                </div>
                <div class="form-group">
                    <input type="password" class="form-control" placeholder="Your Password *" value="" />
                </div>
                <div class="form-group">
                    <input type="submit" class="btnSubmit" value="Login" />
                </div>
                <div class="form-group">

                    <a href="#" class="ForgetPwd" value="Login">Forget Password?</a>
                </div>
            </form>
        </div>
    </div>
</div>

Dengan CSS nya 

.login-container{
    margin-top: 5%;
    margin-bottom: 5%;
}
.login-form-1{
    padding: 5%;
    box-shadow: 0 5px 8px 0 rgba(0, 0, 0, 0.2), 0 9px 26px 0 rgba(0, 0, 0, 0.19);
}
.login-form-1 h3{
    text-align: center;
    color: #333;
}
.login-form-2{
    padding: 5%;
    background: #0062cc;
    box-shadow: 0 5px 8px 0 rgba(0, 0, 0, 0.2), 0 9px 26px 0 rgba(0, 0, 0, 0.19);
}
.login-form-2 h3{
    text-align: center;
    color: #fff;
}
.login-container form{
    padding: 10%;
}
.btnSubmit
{
    width: 50%;
    border-radius: 1rem;
    padding: 1.5%;
    border: none;
    cursor: pointer;
}
.login-form-1 .btnSubmit{
    font-weight: 600;
    color: #fff;
    background-color: #0062cc;
}
.login-form-2 .btnSubmit{
    font-weight: 600;
    color: #0062cc;
    background-color: #fff;
}
.login-form-2 .ForgetPwd{
    color: #fff;
    font-weight: 600;
    text-decoration: none;
}
.login-form-1 .ForgetPwd{
    color: #0062cc;
    font-weight: 600;
    text-decoration: none;
}

View Home

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Home</title>
    <link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css"> 
</head>
<body>
    <div class="w3-bar w3-border w3-light-grey w3-card-4">
        <a href="#" class="w3-bar-item w3-blue w3-button">Home</a>
        <?php if($this->session->userdata('access')=='Administrator'){ ?>
            <a href="#" class="w3-bar-item w3-button">Daftar Satu</a>
            <a href="#" class="w3-bar-item w3-button">Daftar Dua</a>
            <a href="#" class="w3-bar-item w3-button">Daftar Tiga</a>
        <?php } if($this->session->userdata('access')=='User'){ ?>
            <a href="#" class="w3-bar-item w3-button">Daftar Empat</a>
        <?php }; ?>
        <a href="<?php echo site_url('login/logout');?>" class="w3-bar-item w3-button w3-red w3-right">Keluar</a>
    </div>
    <div class="w3-container">
        <h1>Hai <?php echo $this->session->userdata('name'); ?></h1>
        <h3>Ini adalah halaman untuk  <?php echo $this->session->userdata('access'); ?></h3>
    </div>
</body>
</html>

Pranala Menarik

Referensi

Retrieved from "https://kontenbelajar.com/wiki/index.php?title=Login_CodeIgniter&oldid=158"