Home / Bootstrap / Codeigniter / CRUD Codeigniter dan Bootstrap : Input Data Ke Database

CRUD Codeigniter dan Bootstrap : Input Data Ke Database

,

CRUD Codeigniter dan Bootstrap Input data ke Database

CRUD Codeigniter dan Bootstrap, pada tutorial sebelumnya, kita telah membahas bagaimana cara membuat login dengan codeigniter dan bootstrap. Pada tutorial kali ini kita membahas bagaimana cara input data ke database dengan menggunkan Codeigniter (CodeIgniter-3.1.3) dan tentu saja layoutnya kita menggunakan Bootstrap. 

 Silahkan simak contoh serta penjelasan tentang cara crud codeigniter dan bootstrap input data ke database. Baca juga cara edit data dengan codeigniter dan bootstrap.

Tutorial CRUD Codeigniter dan Bootstrap : Input Data Ke Database bisa anda download disini.

Cara menginput data ke database dengan Codeigniter dan Bootstrap

Hal pertama yang kita lakukan adalah membuat databasenya terlebih dahulu, yang kita beri nama tutorial. Salin dan pastekan kode dibawah ini, didalam database tutorial.

-- 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 */;

Controller


Buat controller, yang kita beri nama Tambah.php.
Application/controllers/Tambah.php
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Tambah extends CI_Controller {
function __construct(){
parent::__construct();
$this->load->library('session');
$this->load->database(); // load database
$this->load->library('pagination');
$this->load->helper('url');
$this->load->model('Mtambah');
}
function index(){
$data['title'] = "Add data";
$data['tampil'] = $this->Mtambah->tampil(); // menampilkan data
$this->load->view('vtambah',$data);
}
function tambah(){
$username = $this->input->post('username'); // input username
$password = $this->input->post('password'); // input password
$status = $this->input->post('status'); // input status
$this->Mtambah->tambah($username, $password, $status); // menambahkan data
}
}

View


Buatlah sebuah view untuk tampilan form inputan, yang kita beri nama vtambah.php


Application/views/vtambah.php
<?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">
</head>
<body>
<div class="container">
<div class="row">
<div class="col-sm12 col-md-12">
<h1>Tutorial CURD Codeigniter dan Bootstrap : Input Data Ke Database </h1>
<?php
if($title =="Add data")
{
?>
<form method="post" action="<?php echo base_url(); ?>tambah/tambah">
<div class="form-group">
<label for="exampleInputUsername"> User Name </label>
<input type="text" name="username" class="form-control" id="exampleInputUsername" placeholder="User Name">
</div>
<div class="form-group">
<label for="exampleInputPassword1"> Password </label>
<input type="password" name="password" class="form-control" id="exampleInputPassword1" placeholder="Password">
</div>
<div class="form-group">
<label for="exampleSelectAdmin"> Status </label>
<select name="status" class="form-control" id="exampleSelectAdmin" placeholder=" Password ">
<option value="0"> Super Admin </option>
<option value="1"> Member </option>
</select>
</div>
<button type="submit" class="btn btn-info"> <i class="glyphicon glyphicon-save"></i> Submit </button>
</form>
<?php
}else {
?>
<a class="btn btn-info text-right" href="<?php echo base_url(); ?>home/formAdd" role="button"> Add data </a>
<?php
}
?>
<br/>
<br/>
<div class="panel panel-primary">
<div class="panel-heading">
Table Data
</div>
<div class="panel-body">
<div class="table-responsive">
<table class="table table-bordered">
<thead>
<tr class="success">
<th>#</th>
<th> User Name </th>
<th> Password </th>
<th> Status </th>
<th> Action </th>
</tr>
</thead>
<tbody>
<?php
$i=1;
foreach($tampil as $tmpl)
{
?>
<tr>
<td><?php echo $i; ?></td>
<td><?php echo $tmpl->username; ?></td>
<td><?php echo $tmpl->password; ?></td>
<td>
<?php
if($tmpl->status == "0")
{
echo "Super Admin";
}
else if($tmpl->status == "1")
{
echo "Member";
}
?>
</td>
<td>
<a class="btn btn-warning" href="<?php echo base_url(); ?>home/formAdd/<?php echo $tmpl->id; ?>" role="button"> Edit </a>
<a class="btn btn-danger" href="<?php echo base_url(); ?>home/hapus/<?php echo $tmpl->id; ?>" role="button"> Delete </a>
</td>
</tr>
<?php
$i++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
</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>


Model


Dan tentu saja yang terakhir kita akan membuat model, sebagai proses memasukkan atau input data ke database. Kita beri nama Mtambah.php


Application/models/Mtambah.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Mtambah extends CI_Model {
function tampil()
{
$query = $this->db->get("users");
return $query->result();
//foreach($query->result() as $row)
}
function tambah($username, $password, $status)
{
$data = array(
'username' => $username,
'password' => $password,
'status' => $status
);
$query = $this->db->insert('users', $data);
//echo $this->db->last_query();
if(!$query)
{
redirect('tambah');
}
else
{
redirect('tambah');
}
}
}

Dan yang terakhir yang kita lakukan adalah  buka browser, ketik url http://localhost/tambah/.

Terima kasih sudah mengunjungi blog kami dan selamat mencoba. 

Tutorial CURD Codeigniter dan Bootstrap : Input Data Ke Database bisa anda download disini.
CRUD Codeigniter dan Bootstrap : Input Data Ke Database CRUD Codeigniter dan Bootstrap : Input Data Ke Database Reviewed by Admin on 11:02 PM Rating: 5

2 comments:

  1. ayidhaApril 20, 2018 at 9:39 AM

    Permisi kak mau nanya kalau insert data dari super admin ke satu satu member gimana ya?

    ReplyDelete
  2. ayidhaApril 20, 2018 at 9:40 AM

    Permisi kak mau nanya kalau insert data dari super admin ke satu satu member gimana ya?

    ReplyDelete

Subscribe to: Post Comments ( Atom )
Powered by Blogger.