Disini kita buat dulu file controller bernama crud.php untuk keempat fungsi tersebut, codenya akan terlihat seperti ini
<?php
class Crud extends CI_Controller{
function __construct(){
parent::__construct();
$this->load->model('m_data');
$this->load->helper('url');
}
function index(){
$data['phonebook'] = $this->m_data->tampil_data()->result();
$this->load->view('v_tampil', $data);
}
function tambah(){
$this->load->view('v_input');
}
function tambah_aksi(){
$nama_up = $this->input->post('nama_in');
$alamat_up = $this->input->post('alamat_in');
$email_up = $this->input->post('email_in');
$hp_up = $this->input->post('hp_in');
$kelas_up = $this->input->post('kelas_in');
$data = array(
'nama' => $nama_up,
'alamat' => $alamat_up,
'email' => $email_up,
'hp' => $hp_up,
'kelas' => $kelas_up
);
$this->m_data->input_data($data,'phonebook');
redirect('http://localhost:56789/codeig/index.php/crud');
}
function hapus($id){
$where = array('Id' => $id);
$this->m_data->hapus_data($where,'phonebook');
redirect('http://localhost:56789/codeig/index.php/crud');
}
function edit($id){
$where = array('Id' => $id);
$data['phonebook'] = $this->m_data->edit_data($where,'phonebook')->result();
$this->load->view('v_edit',$data);
}
function update(){
$id = $this->input->post('id');
$nama = $this->input->post('nama_up');
$alamat = $this->input->post('alamat_up');
$email = $this->input->post('email_up');
$hp = $this->input->post('hp_up');
$kelas = $this->input->post('kelas_up');
$data = array(
'Nama' => $nama,
'Alamat' => $alamat,
'Email' => $email,
'HP' => $hp,
'Kelas' => $kelas
);
$where = array(
'Id' => $id
);
$this->m_data->update_data($where,$data,'phonebook');
redirect('http://localhost:56789/codeig/index.php/crud');
}
}
?>
Kemudian, baru kita buat file modelnya bernama m_data.php
<?php
class m_data extends CI_Model{
function __construct(){
parent::__construct();
$this->load->database();
}
function tampil_data(){
return $this->db->get('phonebook');
}
function input_data($data,$table){
$this->db->insert($table,$data);
}
function hapus_data($where,$table){
$this->db->where($where);
$this->db->delete($table);
}
function edit_data($where,$table){
return $this->db->get_where($table,$where);
}
function update_data($where,$data,$table){
$this->db->where($where);
$this->db->update($table,$data);
}
}
?>
<?php
class m_data extends CI_Model{
function __construct(){
parent::__construct();
$this->load->database();
}
function tampil_data(){
return $this->db->get('phonebook');
}
function input_data($data,$table){
$this->db->insert($table,$data);
}
function hapus_data($where,$table){
$this->db->where($where);
$this->db->delete($table);
}
function edit_data($where,$table){
return $this->db->get_where($table,$where);
}
function update_data($where,$data,$table){
$this->db->where($where);
$this->db->update($table,$data);
}
}
?>
<?php
class m_data extends CI_Model{
function __construct(){
parent::__construct();
$this->load->database();
}
function tampil_data(){
return $this->db->get('phonebook');
}
function input_data($data,$table){
$this->db->insert($table,$data);
}
function hapus_data($where,$table){
$this->db->where($where);
$this->db->delete($table);
}
function edit_data($where,$table){
return $this->db->get_where($table,$where);
}
function update_data($where,$data,$table){
$this->db->where($where);
$this->db->update($table,$data);
}
}
?>
<!DOCTYPE html>
<html>
<head>
<title>| Coba Coba CRUD |</title>
</head>
<body>
<center>
<h1>| Coba Coba CRUD |</h1>
<h3>View Data</h3>
</center>
<table style="margin:30px auto;" border="2">
<tr>
<th>No.</th>
<th>Name</th>
<th>Address</th>
<th>Email</th>
<th>HP</th>
<th>Class</th>
<th>Action</th>
</tr>
<?php
$no = 1;
foreach ($phonebook as $p) {
?>
<tr>
<td><?php echo $no++ ?></td>
<td><?php echo $p->Nama ?></td>
<td><?php echo $p->Alamat ?></td>
<td><?php echo $p->Email ?></td>
<td><?php echo $p->HP ?></td>
<td><?php echo $p->Kelas ?></td>
<td><?php echo anchor('http://localhost:56789/codeig/index.php/crud/edit/'.$p->Id, 'Edit'); ?>
<?php echo anchor('http://localhost:56789/codeig/index.php/crud/hapus/'.$p->Id, 'Delete'); ?>
</td>
</tr>
<?php }
?>
</table>
<center>
<h4><?php echo anchor('http://localhost:56789/codeig/index.php/crud/tambah/','Insert Data'); ?></h4>
</center>
</body>
</html>
Lalu kita buat file v_input.php untuk fungsi Create
<!DOCTYPE html>
<html>
<head>
<title>| Coba Coba CRUD | </title>
</head>
<body>
<center>
<h1>| Coba Coba CRUD |</h1>
<h3>Insert data</h3>
</center>
<form action="<?php echo 'http://localhost:56789/codeig/index.php/crud/tambah_aksi'; ?>" method="post">
<table style="margin:20px auto;">
<tr>
<td>Name</td>
<td><input type="text" name="nama_in"></td>
</tr>
<tr>
<td>Address</td>
<td><input type="text" name="alamat_in"></td>
</tr>
<tr>
<td>Email</td>
<td><input type="text" name="email_in"></td>
</tr>
<tr>
<td>HP</td>
<td><input type="text" name="hp_in"></td>
</tr>
<tr>
<td>Class</td>
<td><input type="text" name="kelas_in"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="Insert"></td>
</tr>
</table>
</form>
</body>
</html>
Tampilannya akan menjadi seperti ini
Kemudian kita buat file v_edit.php untuk fungsi Update
<!DOCTYPE html>
<html>
<head>
<title>|Coba Coba CRUD|</title>
</head>
<body>
<center>
<h1>| Coba Coba CRUD |</h1>
<h3> Update Data </h3>
</center>
<?php foreach($phonebook as $p) { ?>
<form action="<?php echo 'http://localhost:56789/codeig/index.php/crud/update'; ?>" method="post">
<table style="margin: 20px auto;">
<tr>
<td>Name</td>
<td>
<input type="hidden" name="id" value="<?php echo $p->Id ?>">
<input type="text" name="nama_up" value="<?php echo $p->Nama ?>">
</td>
</tr>
<tr>
<td>Address</td>
<td><input type="text" name="alamat_up" value="<?php echo $p->Alamat ?>"></td>
</tr>
<tr>
<td>Email</td>
<td><input type="text" name="email_up" value="<?php echo $p->Email ?>"></td>
</tr>
<tr>
<td>HP</td>
<td><input type="text" name="hp_up" value="<?php echo $p->HP ?>"></td>
</tr>
<tr>
<td>Class</td>
<td><input type="text" name="kelas_up" value="<?php echo $p->Kelas ?>"></td>
</tr>
<tr>
<td></td>
<td><input type="submit" value="Save"></td>
</tr>
</table>
</form>
<?php } ?>
</body>
</html>
Tampilannya akan menjadi seperti berikut
Nah, untuk kali ini cukup segitu saja ilmu nya. Silahkan berbagi pada teman - teman anda. Sekian Terima kasih. Byeee
