Selamat Malam gaes , Semoga sehat selalu .
Maap kali ini saya agak telat menceritakan karena kecapain akhirya mempostingnya kemaleman .
Pada hari jumat,6 Juli 2018 , Seperti biasanya saya menceritakan pengalaman magang di Duxeos , ya langsung saja yah .Saya disuruh belajar AR (Augmented Reality) dan CI (CodeIgniter) .
Tapi Kali ini saya akan mempelajari CodeIgniter dan itu saya baru mengenalnya . Ya pertama kita download Framework Codeigniter kalau sudah kita extrak ke xampp/htdocs dan menganti nama folder sesuka kamu . Lalu kita mengedit di folder config yang kita atur adalah file autoload,config,database. di autoload kita mengeditnya di $autoload['libraries'] = array('database', 'session', 'form_validation');,$autoload['helper'] = array('url'); . dan kita mengedit lagi di file config disini hanya mengatur base_url contohnya seperti ini $config['base_url'] = "http://localhost/ci_login/"; . Sesudah itu kita mengedit di bagian database kita atur seperti ini:
$db['default'] = array(
'dsn' => '',
'hostname' => 'localhost',
'username' => 'root',
'password' => '',
'database' => 'ci-login',
'dbdriver' => 'mysqli',
di disini sesuai konfigurasi mysql anda .
Lalu kita membuat Controller di folder Controller dengan nama Crud.php .
kita isikan dengan ini .
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Crud extends CI_Controller
{
function __construct(){
parent:: __construct();
$this->load->model('Model_crud');
}
public function tampil()
{
$data['query'] = $this->Model_crud->tampil();
$this->load->view('crud_tampil', $data);
}
public function input()
{
$this->load->view('crud_input');
}
public function simpan()
{
$data = array('nim' => $this->input->post('nim'), 'nama' => $this->input->post('nama'),
'alamat' => $this->input->post('alamat'), 'hobi' => $this->input->post('hobi'));
$proses = $this->Model_crud->simpan($data);
if (!$proses) {
header('Location: tampil');
} else {
echo "Data Gagal Disimpan";
echo "<br>";
echo "<a href='".base_url('index.php/crud/input/')."'>Kembali ke form</a>";
}
}
}
lalu kita membuat view dengan nama file crud_tampil . ikuti seperti ini
<!DOCTYPE html>
<html>
<head>
<title> Dashboard - Login CodeIgniter & Bootstrap</title>
<link rel="stylesheet" type="text/css" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>
<!-- //class="navbar navbar-expand-lg navbar-dark bg-primary"
--><nav class="navbar navbar-expand-lg navbar-dark bg-primary">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<h3>CROT CI</h3>
</div>
<div id="navbar" class="navbar-collapse collapse">
<div class="navbar-form navbar-right">
<a href="<?php echo base_url() ?>index.php/dashboard/logout" type="submit" class="btn btn-success"><i class="fa fa-sign-out"></i> Logout</a>
</div>
</div>
</nav>
<div class="container" style="margin-top: 80px">
<div class="row">
<div class="col-md-3">
<div class="list-group">
<a href="#" class="list-group-item active" style="text-align: center;background-color: blue;border-color: black">
ADMINISTRATOR
</a>
<a href="http://localhost/ci_login/index.php/dashboard/" class="list-group-item"><i class="fa fa-dashboard"></i> Dashboard</a>
<a href="http://localhost/ci_login/index.php/crud/tampil/#" class="list-group-item"><i class="fa fa-book"></i> Data Mahasiswa</a>
<a href="#" class="list-group-item"><i class="fa fa-folder"></i> Kategori</a>
<a href="#" class="list-group-item"><i class="fa fa-comments-o"></i> Komentar</a>
<a href="logout.php" class="list-group-item"><i class="fa fa-sign-out"></i> Logout</a>
</div>
</div>
<div class="col-md-9">
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title"><i class="fa fa-book"></i> Data Mahasiswa</h3>
</div>
<div class="panel-body">
<a href="<?php echo base_url('index.php/crud/input'); ?>" class="btn btn-primary">Tambah Data mahasiswa</a>
<table class="table table-hover">
<thead>
<tr>
<th scope="10px">#</th>
<th scope="10px">Nim</th>
<th scope="10px">Nama</th>
<th scope="10px">Alamat</th>
<th scope="25px">Hobi</th>
<th colspan="2" scope="100px">Action</th>
</tr>
</thead>
<tbody>
<tr class="table-active">
<?php
$no = 1;
foreach ($query->result() as $baris) {
echo "<tr>";
echo "<td>".$no."</td>";
echo "<td>".$baris->nim."</td>";
echo "<td>".$baris->nama."</td>";
echo "<td>".$baris->alamat."</td>";
echo "<td>".$baris->hobi."</td>";
echo "<td><a href="#" class='btn btn-sm btn-warning'>Edit</a></td>";
echo "<td><a href="#" class='btn btn-sm btn-danger'>Hapus</a></td>";
echo "</tr>";
$no++; }
?>
</tr>
</table>
</tbody>
</div>
</div>
</div>
</div>
</div>
</div>
<script type="text/javascript" src="https://code.jquery.com/jquery-3.2.1.min.js"></script>
<script type="text/javascript" src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</body>
</html>
terus kita menambahkan file di folder model dengan nama Model_crud.php . seperti ini
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Model_crud extends CI_Model
{
public function simpan($data)
{
$this->db->insert('mahasiswa', $data);
}
public function tampil()
{
$query = $this->db->get('mahasiswa');
return $query;
}
}
saya hanya bisa tampil saja yang tambah masih eror .Sekian Pengalaman Saya .
Tetap Semagat Gaes !!!.