Membuat crud login dengan Codeigniter, Bootstrap dan MySQL

Membuat crud login dengan codeigniter dan bootstrap, login berguna untuk hak akses atau register yang mana bisa di buat multi user. Jangan lewatkan cara input data dengan codeigniter.

Membuat crud login dengan Codeigniter, Bootstrap dan MySQL

Tutorial kali ini kita membuat crud login dengan codeigniter dan bootstrap, bagaimana cara membuat aplikasi login? Berikut ini langkah-langkahnya : 

Tutorial crud login dengan codeigniter Bisa anda download disini.

Baca Juga:
Edit data dengan codeigniter dan bootstrap.
CURD Hapus data dengan codeigniter dan bootstrap.
Cara membuat pagging dengan codeigniter dan bootstrap.
Cara membuat mesin pencarian di codeigniter dan bootstrap.
Tips dan trik menjadi programer pemula yang handal.

Database MySQL

Sebelum kita masuk dalam membuat login dengan codeigniter terlebih dahulu kita buat database (beri nama tutorial), lalu copy dan paste code dibawah ini.

-- phpMyAdmin SQL Dump

-- version 4.1.6

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Feb 01, 2017 at 07:29 AM

-- Server version: 5.6.16

-- PHP Version: 5.5.9

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

--

-- Database: `tutorial`

--

-- --------------------------------------------------------

--

-- Table structure for table `users`

--

CREATE TABLE IF NOT EXISTS `users` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`username` varchar(150) NOT NULL,

`password` varchar(256) NOT NULL,

`status` tinyint(1) NOT NULL COMMENT '0=super admin, 1=admin',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--

-- Dumping data for table `users`

--

INSERT INTO `users` (`id`, `username`, `password`, `status`) VALUES

(1, 'bastian', 'bastianabas', 0);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Konfigurasi Codeigniter

 

File di Codeigniter yang kita konfigurasi adalah di:

1. File autoload.php  $autoload ['libraries'] = array('database', 'session').
2. File config.php $config['base_url'] = 'localhost/tutorial'; dan $config['encryption_key'] = 'programmer-web-base.blogspot.co.id';.
3. File database.php $db['default'] = array('hostname' => 'localhost','username' => 'username anda', 'password' => 'password anda','database' => 'tutorial',); 
4. File routes.php $route['default_controller'] = 'login';

Membuat Form Login di Codeigniter

 

Dalam membuat form login di Codeigniter, kita bermain di 3 folder, yaitu controllers, models dan views.

Controllers

Buat file Login.php, dan salin kodeberikut ini :

<?php

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

class Login extends CI_Controller {

function __construct(){

parent::__construct();

$this->load->library('session');

$this->load->database();

$this->load->model('Mlogin');

}

public function index()

{

$data['title'] = "This is Login";

$this->load->view('vlogin',$data);

}

function cekLogin()

{

$username = $this->input->post('username');

$password = $this->input->post('password');

$this->Mlogin->getlogin($username,$password);

}

}

Lalu buat juga file Home.php, dan salin kode berikut ini :

<?php

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

class Home extends CI_Controller {

function __construct(){

parent::__construct();

$this->load->library('session');

$this->load->database();

}

public function index()

{

$data['title'] = "This is Home";

$this->load->view('vhome',$data);

}

}

Models

Di folder model, kita hanya membuat satu file yaitu Mlogin.php, dan berikut ini kodenya :

<?php

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

class Mlogin extends CI_Model {

function getlogin($username,$password)

{

if($username !='' && $password !='')

{

$pass = $password;

$this->db->where("status",'0');

$this->db->where("username",$username);

$this->db->where("password",$pass);

$query = $this->db->get("users");

if($query->num_rows() > 0){

foreach($query->result() as $row){

$user = array(

"usernametutorial" => $row->username

);

$this->session->set_userdata($user);

redirect('home');

}

}

else

{

// Jika username atau password tidak sama

redirect('login');

}

}

else

{

// Jika username atau password kosong

redirect('login');

}

}

}

Views

Di folder views kita buat file vlogin.php dan vhome.php

Di file vlogin.php salin kode berikut ini :

<?php

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

?>

<!DOCTYPE html>

<html>

<head>

<title><?php echo $title; ?></title>

<meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">

<link rel="stylesheet" href="<?php echo base_url(); ?>asset/bootstrap/css/bootstrap.min.css">

<link rel="stylesheet" href="<?php echo base_url(); ?>asset/font-awesome/css/font-awesome.min.css">

<style>

body{

height: 100vh;

display: flex;

align-items: center;

justify-content: center;

}

.panel-heading{

padding: 5px 15px;

}

.panel-footer{

padding: 5px 15px;

}

.panel-footer{

padding: 5px 15px;

color: #A0A0A0;

}

.profile-img{

width: 96px;

height: 96px;

margin: 0 auto 10px;

display: block;

-moz-border-radius: 50%;

-webkit-border-radius: 50%;

border-radius: 50%;

}

</style>

</head>

<body>

<div class="container">

<div class="row">

<div class="col-sm12 col-md-4"></div>

<div class="col-sm12 col-md-4">

<div class="panel panel-default">

<div class="panel-heading text-center">

<strong>Login Form Bootstrap</strong>

</div>

<div class="panel-body">

<form role="form" action="<?php echo base_url(); ?>login/cekLogin" method="POST">

<fieldset>

<div class="row">

<div class="center-block">

<img class="profile-img" src="<?php echo base_url(); ?>asset/img/photo.jpg" alt="">

</div>

<div class="row">

<div class="col-sm-12 col-md-10 col-md-offset-1 ">

<div class="form-group">

<div class="input-group">

<span class="input-group-addon">

<i class="glyphicon glyphicon-user"></i>

</span>

<input class="form-control" placeholder="Username" name="username" type="text" autofocus>

</div>

</div>

<div class="form-group">

<div class="input-group">

<span class="input-group-addon">

<i class="glyphicon glyphicon-lock"></i>

</span>

<input class="form-control" placeholder="Your Password" name="password" type="password" autofocus>

</div>

</div>

<div class="form-group">

<input type="submit" class="btn btn-lg btn-primary btn-block" value="Sign in">

</div>

</div>

</div>

</div>

</fieldset>

</form>

</div>

</div>

</div>

<div class="col-sm12 col-md-4"></div>

</div>

</div>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>

<script src="<?php echo base_url(); ?>asset/bootstrap/js/bootstrap.min.js"></script>

</body>

</html>

Salin juga kode berikut ini di file Vhome.php

<?php

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

?>

<h1>Selamat Datang <?php echo $this->session->userdata('usernametutorial'); ?></h1>

Lalu jalankan aplikasi login dengan mengetik di browser http://localhost/tutorial/. Terimakasih, semoga bermanfaat.

Tutorial crud membuat login dengan codeigniter Bisa anda download disini.