Codeigniter dan Bootstrap Edit Data Database
Pada tutorial sebelumnya, kita membahas crud cara input data ke database menggunakan codeigniter. Pada tutorial crud kali ini kita bahas bagaimana crud edit data dari database dengan cara menggabungkan Bootstrap dengan Codeigniter. Kode crud codeigniter ini sangat sederhana sekali. Simak ulasannya berikut ini.Tutorial CRUD Codeigniter dan Bootstrap : Edit Data Ke Database bisa anda download disini.
Baca juga cara hapus data dengan codeigniter dan bootstrap.
Codeigniter dan bootstrap edit data database
Berikut langkah cara membuat curd codeigniter edit data database.
Database
Langkah pertama kita harus mempunyai database untuk tempat menyimpan data ( nama databasenya 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 */;
Controller Codeigniter
Buka editor text php kalian, lalu salin kode dibawah ini dan simpan pada folder controllers dengan nama Edit.php.<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Edit 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('Medit');
}
function index()
{
//$username = $this->input->post('username'); // input username
$data['title'] = "Belajar edit data";
$data['tampil'] = $this->Medit->tampil(); // menampilkan data
$this->load->view('vedit',$data);
}
function formEdit(){
$data['title'] = "Belajar edit data";
$data['showEdit'] = $this->Medit->showEdit(); // menampilkan data
$data['tampil'] = $this->Medit->tampil(); // menampilkan data
$this->load->view('vedit',$data);
}
function editData(){
$id = $this->input->post('id'); // input id
$username = $this->input->post('username'); // input username
$password = $this->input->post('password'); // input password
$status = $this->input->post('status'); // input status
$this->Medit->editData($id,$username, $password, $status); // edit data
$this->load->view('vedit',$data);
}
}
View Codeigniter
Di bagian viewnya tulis code seperti di bawah ini, simpan di folder view dengan nama vedit.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 Edit Data Codeigniter dan Bootstrap </h1>
<?php
if($this->uri->segment(2) =="formEdit")
{
foreach($showEdit as $se)
{
?>
<form method="post" action="<?php echo base_url(); ?>edit/editData">
<input type="hidden" name="id" value="<?php echo $se->id; ?>">
<div class="form-group">
<label for="exampleInputUsername"> User Name </label>
<input type="text" name="username" class="form-control" id="exampleInputUsername" placeholder="User Name" value="<?php echo $se->username; ?>">
</div>
<div class="form-group">
<label for="exampleInputPassword1"> Password </label>
<input type="text" name="password" class="form-control" id="exampleInputPassword1" placeholder="Password" value="<?php echo $se->password; ?>">
</div>
<div class="form-group">
<label for="exampleSelectAdmin"> Status </label>
<select name="status" class="form-control" id="exampleSelectAdmin" placeholder="Password">
<option value="0" <?php if($se->status == "0"){echo "selected"; } ?>> Super Admin </option>
<option value="1" <?php if($se->status == "1"){echo "selected"; } ?>> Member </option>
</select>
</div>
<button type="submit" class="btn btn-info"> <i class="glyphicon glyphicon-save"></i> Submit </button>
</form>
<?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(); ?>edit/formEdit/<?php echo $tmpl->id; ?>" role="button"> Edit </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 Codeigniter
Untuk menambahkan datanya, copy paste kode di bawah ini dan simpan pada folder model dengan nama Medit.php.<?phpLalu buka browser, ketik url http://localhost/editData/.
defined('BASEPATH') OR exit('No direct script access allowed');
class Medit extends CI_Model {
function tampil()
{
$query = $this->db->get("users");
return $query->result();
//foreach($query->result() as $row)
}
function showEdit()
{
$this->db->where("id", $this->uri->segment(3));
$query = $this->db->get("users");
return $query->result();
//foreach($query->result() as $row)
}
function editData($id,$username, $password, $status)
{
$data = array(
'username' => $username,
'password' => $password,
'status' => $status
);
$this->db->where('id', $id);
$query = $this->db->update('users', $data);
if(!$query)
{
redirect('home');
}
else
{
redirect('home');
}
}
}
Terima kasih sudah mengunjungi blog kami dan selamat mencoba.
Tutorial CRUD Codeigniter dan Bootstrap : Edit Data Ke Database bisa anda download disini.
Codeigniter dan Bootstrap : Edit Data Database
![Codeigniter dan Bootstrap : Edit Data Database]()
Reviewed by Admin
on
9:46 AM
Rating:
No comments: