Published April 30, 2023 by RIT with 0 comment

SCRIPT CRUD PADA CODEIGNITER 3

Assalamualaikum warohmatullohi wabarokatuh,
Wa alaikum salam warohmatullohi wabarokatuh,

Pada postingan ini akan berbagi script Create Read Update Delete (CRUD) menggunakan framework codeigniter 3, baiklah langsung saja pada script nya.

kalian juga bisa menggunakan scroll pintas ini untuk menuju ke kode yang kalian inginkan


Buatlah struktur database nya bisa tinggal kopi paste saja ::

CREATE TABLE `tb_santri` (
  `id_santri` int(11) NOT NULL,
  `nama_santri` varchar(50) DEFAULT NULL,
  `jekel_santri` varchar(50) DEFAULT NULL,
  `alamat_santri` varchar(50) DEFAULT NULL,
  `no_telpon_santri` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;


Persiapan, buatlah file

0. buatlah file didalam folder controller dengan nama Tutorial.php

1. buatlah file didalam folder Model dengan nama m_data.php

2. buatlah file didalam view kalian buat 3 yaitu ::
--v_crud.php,
--v_crud_detail.php,
--v_crud_edit_update.php

#Controller
Copy dan paste script dibawah ini pada file Tutorial.php 
<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Tutorial extends CI_Controller {

  public function __construct()
  {
    parent::__construct();
    $this->load->model('m_data');
  }
  
  public function index_crud()
  {
    // menampilkan data 
  }
  
  public function tambah_data_baru()
  {
    // menambah data baru
  }
  
  public function detail_data($id_santri)
  {
    // menampilkan data by id
  }
  
  public function edit_data($id_santri)
  {
    // menampilkan data by id saat di edit
  }
  
  public function update_data()
  {
    // memperbarui data
  }
  
  public function delete_data($id_santri)
  {
    // menghapus data
  }

}


#Model
Copy dan paste script dibawah ini pada file m_data.php 
<?php 
 
class M_data extends CI_Model{
  
  public function m_get_all_data()
  {
  // function menampilkan semua data
  }
  
  public function m_tambah_data_baru($data)
  {
    // function tambah data baru
  }
  
  public function m_getDataById($id_santri)
  {
    // function menampilkan data by id
  }
  
  public function m_update_data($id_santri, $data)
  {
    // function memperbarui data by id
  }
  
  public function m_delete_data($id_santri)
  {
    // function menghapus data by id
  }
  
  
}


Script Read/Select menggunakan Codeigniter ada disini


#Controller 
<?php
 
// controller 

public function index_crud()
{
  
  $data['row_nya'] = $this->m_data->m_get_all_data()->result_array();
  
  $this->load->view('tutorial/v_crud', $data);

}


#Model 
<?php
 
// model

public function m_get_all_data()
{
  
  return $this->db->get('tb_santri');
  
}


#View 
<!-- css -->
<style>
  table, td, th {
    border: 1px solid;
    padding: 10px;
  }

  table {
    border-collapse: collapse;
    width: 100%;
  }
</style>
<!-- css -->

<table>
  <tr>
    <td>No</td>
    <td>Nama</td>
    <td>Jenis Kelamin</td>
    <td>Alamat</td>
    <td>No Telpon</td>
    <td>Option</td>
  </tr>

<?php 
 $no = 1;
 foreach ($row_nya as $row) { 
   ?>  
  <tr>
    <td><?= $no++; ?></td>
    <td><?= $row['nama_santri']; ?></td>
    <td><?= $row['jekel_santri']; ?></td>
    <td><?= $row['alamat_santri']; ?></td>
    <td><?= $row['no_telpon_santri']; ?></td>
    
    <td>
      <a href="#">detail</a>
      <a href="#">edit</a>
      <a href="#">delete</a>
      
      
    </td>

  </tr>

<?php } ?>  

</table>

Script Detail data menggunakan Codeigniter ada disini



#Controller 
<?php

// Controller

public function detail_data($id_santri)
{

  $data['judul'] = 'Detail Santri';
  $data['row_detail'] = $this->m_data->m_getDataById($id_santri);

  $this->load->view('tutorial/v_crud_detail',$data);


}


#Model 
<?php

// Model

public function m_getDataById($id_santri)
{

return $this->db->get_where('tb_santri', ['id_santri '=> $id_santri])->row_array();

}


#View
tambahkan script dibawah ini pada tag href detail di file v_crud.php yang berada di folder view 
<a href="<?= base_url('Tutorial/detail_data/'.$row['id_santri']); ?>">detail</a>


jadi fullscript nya seperti ini :: 
<!-- css -->
<style>
  table, td, th {
    border: 1px solid;
    padding: 10px;
  }

  table {
    border-collapse: collapse;
    width: 100%;
  }
</style>
<!-- css -->

<fieldset>
  FORM TAMBAH DATA <br><br>
  <form method="POST" action="<?= base_url(); ?>Tutorial/tambah_data_baru">
    Nama : <input type="text" name="nama_santri"> <br><br>

    Jenis kelamin : <input type="text" name="jekel_santri"><br><br>

    Alamat : <input type="text" name="alamat_santri"><br><br>

    No Telpon : <input type="text" name="no_telpon_santri"><br><br>

    <input type="submit" value="Simpan">
  </form>
</fieldset>

<br>
<br>

<table>
  <tr>
    <td>No</td>
    <td>Nama</td>
    <td>Jenis Kelamin</td>
    <td>Alamat</td>
    <td>No Telpon</td>
    <td>Option</td>
  </tr>

<?php 
 $no = 1;
 foreach ($row_nya as $row) { 
   ?>  
  <tr>
    <td><?= $no++; ?></td>
    <td><?= $row['nama_santri']; ?></td>
    <td><?= $row['jekel_santri']; ?></td>
    <td><?= $row['alamat_santri']; ?></td>
    <td><?= $row['no_telpon_santri']; ?></td>
    
    <td>
      <a href="<?= base_url('Tutorial/detail_data/'.$row['id_santri']); ?>">detail</a>
      <a href="#">edit</a>
      <a href="#">delete</a>
      
      
    </td>

  </tr>

<?php } ?>  

</table>

Script Create/Insert menggunakan Codeigniter ada disini



#Controller 
<?php 

// controller

public function tambah_data_baru()
{
  $data = [
  "nama_santri"     => $this->input->post('nama_santri', true), //true untuk menghidari sql injection
  "jekel_santri"    => $this->input->post('jekel_santri', true),
  "alamat_santri"   => $this->input->post('alamat_santri', true),
  "no_telpon_santri"  => $this->input->post('no_telpon_santri', true)
  ];

  $this->m_data->m_tambah_data_baru($data);

  redirect('tutorial/index_crud');
}


#Model
<?php 

// model

public function m_tambah_data_baru($data)
{
  return $this->db->insert('tb_santri', $data);
}


#View 
// tambahkan script dibawah tag </style> kalian bisa lihat pada fullscript nya ada di bawah script ini.

<fieldset>
  FORM TAMBAH DATA <br><br>
  <form method="POST" action="<?= base_url(); ?>Tutorial/tambah_data_baru">
    Nama : <input type="text" name="nama_santri"> <br><br>

    Jenis kelamin : <input type="text" name="jekel_santri"><br><br>

    Alamat : <input type="text" name="alamat_santri"><br><br>

    No Telpon : <input type="text" name="no_telpon_santri"><br><br>

    <input type="submit" value="Simpan">
  </form>
</fieldset>


jika ditambahakan pada view di script sebelumnya maka akan seperti ini full script nya 
// full script nya

<!-- css -->
<style>
  table, td, th {
    border: 1px solid;
    padding: 10px;
  }

  table {
    border-collapse: collapse;
    width: 100%;
  }
</style>
<!-- css -->

<fieldset>
  FORM TAMBAH DATA <br><br>
  <form method="POST" action="<?= base_url(); ?>Tutorial/tambah_data_baru">
    Nama : <input type="text" name="nama_santri"> <br><br>

    Jenis kelamin : <input type="text" name="jekel_santri"><br><br>

    Alamat : <input type="text" name="alamat_santri"><br><br>

    No Telpon : <input type="text" name="no_telpon_santri"><br><br>

    <input type="submit" value="Simpan">
  </form>
</fieldset>

<br>
<br>

<table>
  <tr>
    <td>No</td>
    <td>Nama</td>
    <td>Jenis Kelamin</td>
    <td>Alamat</td>
    <td>No Telpon</td>
    <td>Option</td>
  </tr>

<?php 
 $no = 1;
 foreach ($row_nya as $row) { 
   ?>  
  <tr>
    <td><?= $no++; ?></td>
    <td><?= $row['nama_santri']; ?></td>
    <td><?= $row['jekel_santri']; ?></td>
    <td><?= $row['alamat_santri']; ?></td>
    <td><?= $row['no_telpon_santri']; ?></td>
    
    <td>
      <a href="#">detail</a>
      <a href="#">edit</a>
      <a href="#">delete</a>
      
      
    </td>

  </tr>

<?php } ?>  

</table>


Script Edit dan Update data menggunakan Codeigniter ada disini :


#Controller 
<?php 

// controller

public function edit_data($id_santri)
{

  $data['judul'] = 'Edit Santri';
  $data['row_detail'] = $this->m_data->m_getDataById($id_santri);

  $this->load->view('tutorial/v_crud_edit_update',$data);     

}

public function update_data()
{
  $id_santri = $this->input->post('id_santri', true);

  $data = [
  "nama_santri"     => $this->input->post('nama_santri', true), //true untuk menghidari sql injection
  "jekel_santri"    => $this->input->post('jekel_santri', true),
  "alamat_santri"   => $this->input->post('alamat_santri', true),
  "no_telpon_santri"  => $this->input->post('no_telpon_santri', true)
  ];  

  $this->m_data->m_update_data($id_santri, $data);

  redirect('Tutorial/index_crud');

}


#Model 
<?php

// model

public function m_get_all_data()
{
  
  return $this->db->get('tb_santri');
  
}


#View Buatlah file baru pada folder view didalam folder Tutorial dengan nama v_crud_edit_update.php lalu copy code dibawah ini. 
//buatlah file pada folder view lagi

<fieldset>
  FORM TAMBAH DATA <br><br>
  <form method="POST" action="<?= base_url(); ?>Tutorial/update_data/">

    <input type="hidden" name="id_santri" value="<?php echo $row_detail['id_santri']; ?>">
    
    Nama : <input type="text" name="nama_santri" value="<?php echo $row_detail['nama_santri']; ?>"> <br><br>

    Jenis kelamin : <input type="text" name="jekel_santri" value="<?php echo $row_detail['jekel_santri']; ?>"><br><br>

    Alamat : <input type="text" name="alamat_santri" value="<?php echo $row_detail['alamat_santri']; ?>"><br><br>

    No Telpon : <input type="text" name="no_telpon_santri" value="<?php echo $row_detail['no_telpon_santri']; ?>"><br><br>

    <input type="submit" value="Simpan">
  </form>
</fieldset>


buka file v_crud.php pada folder view lalu tambahkan script dibawah ini : 
//

<a href="<?= base_url('Tutorial/edit_data/'.$row['id_santri']); ?>">edit</a>


sehingga full scriptnya seperti ini : 
<!-- css -->
<style>
  table, td, th {
    border: 1px solid;
    padding: 10px;
  }

  table {
    border-collapse: collapse;
    width: 100%;
  }
</style>
<!-- css -->

<fieldset>
  FORM TAMBAH DATA <br><br>
  <form method="POST" action="<?= base_url(); ?>Tutorial/tambah_data_baru">
    Nama : <input type="text" name="nama_santri"> <br><br>

    Jenis kelamin : <input type="text" name="jekel_santri"><br><br>

    Alamat : <input type="text" name="alamat_santri"><br><br>

    No Telpon : <input type="text" name="no_telpon_santri"><br><br>

    <input type="submit" value="Simpan">
  </form>
</fieldset>

<br>
<br>

<table>
  <tr>
    <td>No</td>
    <td>Nama</td>
    <td>Jenis Kelamin</td>
    <td>Alamat</td>
    <td>No Telpon</td>
    <td>Option</td>
  </tr>

<?php 
 $no = 1;
 foreach ($row_nya as $row) { 
   ?>  
  <tr>
    <td><?= $no++; ?></td>
    <td><?= $row['nama_santri']; ?></td>
    <td><?= $row['jekel_santri']; ?></td>
    <td><?= $row['alamat_santri']; ?></td>
    <td><?= $row['no_telpon_santri']; ?></td>
    
    <td>
      <a href="<?= base_url('Tutorial/detail_data/'.$row['id_santri']); ?>">detail</a>
      <a href="<?= base_url('Tutorial/edit_data/'.$row['id_santri']); ?>">edit</a>
      <a href="#">delete</a>
      
      
    </td>

  </tr>

<?php } ?>  

</table>

Script Delete data menggunakan Codeigniter ada disini


#Controller 
<?php

// Controller

public function delete_data($id_santri)
{
  
  $this->m_data->m_delete_data($id_santri);

  redirect('Tutorial/index_crud');

}


#Model 
<?php 

// Model

public function m_delete_data($id_santri)
{
  // $this->db->where('id_santri', $id_santri); bisa juga seperti ini
  $this->db->delete('tb_santri', ['id_santri'=>$id_santri]);

}


#View
buka file v_crud.php pada folder view/tutorial 
//

<a href="<?= base_url('Tutorial/delete_data/'.$row['id_santri']); ?>">delete</a>


maka full script nya seperti ini : 
// view

<!-- css -->
<style>
  table, td, th {
    border: 1px solid;
    padding: 10px;
  }

  table {
    border-collapse: collapse;
    width: 100%;
  }
</style>
<!-- css -->

<fieldset>
  FORM TAMBAH DATA <br><br>
  <form method="POST" action="<?= base_url(); ?>Tutorial/tambah_data_baru">
    Nama : <input type="text" name="nama_santri"> <br><br>

    Jenis kelamin : <input type="text" name="jekel_santri"><br><br>

    Alamat : <input type="text" name="alamat_santri"><br><br>

    No Telpon : <input type="text" name="no_telpon_santri"><br><br>

    <input type="submit" value="Simpan">
  </form>
</fieldset>

<br>
<br>

<table>
  <tr>
    <td>No</td>
    <td>Nama</td>
    <td>Jenis Kelamin</td>
    <td>Alamat</td>
    <td>No Telpon</td>
    <td>Option</td>
  </tr>

<?php 
 $no = 1;
 foreach ($row_nya as $row) { 
   ?>  
  <tr>
    <td><?= $no++; ?></td>
    <td><?= $row['nama_santri']; ?></td>
    <td><?= $row['jekel_santri']; ?></td>
    <td><?= $row['alamat_santri']; ?></td>
    <td><?= $row['no_telpon_santri']; ?></td>
    
    <td>
      <a href="<?= base_url('Tutorial/detail_data/'.$row['id_santri']); ?>">detail</a>
      <a href="<?= base_url('Tutorial/edit_data/'.$row['id_santri']); ?>">edit</a>
      <a href="<?= base_url('Tutorial/delete_data/'.$row['id_santri']); ?>">delete</a>
      
      
    </td>

  </tr>

<?php } ?>  

</table>




Demikian cara C.R.U.D pada codeigniter, jika ada kesulitan mengenai artikel ini, bisa tinggalkan komentar dibawah ini. Terima Kasih

TAG TAGS :
CARA C.R.U.D PADA CODEIGNITER | CARA C.R.U.D PADA CODEIGNITER | CARA C.R.U.D MENGGUNAKAN CODEIGNITER | HOW TO C.R.U.D USE CODEIGNITER | HOW TO C.R.U.D WITH CODEIGNITER | C.R.U.D on CODEIGNITER | C.R.U.D on CODEIGNITER langsungkoding.blogspot.com | langsungkoding |


BACA JUGA :

,

      edit

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)