Ekspresi | Belajar HTML dan PHP | Sunda | Kontak | Gmail | Uang Adsense
Kemahasiswaan Kilas Santai
PMB Online STMIK Jabar 2021
STMIK JABAR
LP3I Tasikmalaya
STAI Al-Falah
Pengobatan Ruqyah
Belajar Pemrograman PHP, MySQL, Framework CI, Domain, Hosting, CMS Wordpress, Framework Laravel. Yang Penting ada menu DAFTAR ISI
Inkubator | Daftar Isi | Bisnis Bitcoin | Tools Penting | PrivacyPolicy | Inggris Arab

Thursday, June 3, 2021

CI Pertemuan 5: Tampil, Edit, Hapus (CRUD)

 Bismillah.

Insyaallah ini materi terakhir mata kuliah web 2.

Untuk eksplorasi sendiri, banyak di tutorial di Internet.

Tidak diberikan di sini, mengingat masa Covid-19 banyak teman-teman kita yang tidak punya laptop.

Bagi yang masih pusing, minimal teman-teman rajin berlatih sampai membuat tombol tambah dan fungsi tampilnya untuk persiapan UAS.

**

Agar tidak pusing, kita sekarang membuat file baru yaa...

1. Buka application/controller

2. Buatlah file Mhs.php

3. Salin script ini

<?php

defined('BASEPATH') OR exit('No direct script access allowed');


class Mhs extends CI_Controller {


function __construct()

    {

        parent::__construct();

        $this->load->model('M_Mhs');


    }


function index()

{

$data['hasil']=$this->M_Mhs->TampilMahasiswa();

$this->load->view('tasdik/v_mhs',$data);

}

function tambah()

{

$this->load->view('tasdik/v_tambah_mhs'); 

}

function simpan_mahasiswa()

    {

        $data = array(

            'nim'=>$this->input->post('nim'),

'nama'=>$this->input->post('nama')

        );

        $this->db->insert('tasdik',$data);

        redirect('mhs/index');

}


function update($nik)

    {

        $data['ambil']=$this->M_Mhs->GetNik($nik);

        $this->load->view('tasdik/v_update_mhs',$data);

}

    function simpan_update()

    {

        $data = array(

        

            'nama'=>$this->input->post('nama')

);

$nik = $this->input->post('nim');

$this->db->where('nim', $nik);

        $this->db->update('tasdik',$data);

        redirect('mhs');

}


function hapus($nik)

    {

        $this->M_Mhs->HapusMahasiswa($nik);

        redirect('mhs');

    }

}


?>


4. Buka direktori application/views/folder masing-masing

5. Buatlah file v_mhs.php

6. Salinlah script ini:

<!DOCTYPE html>

<html>

<head>

    <!-- Load file CSS Bootstrap -->

    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">


    <!-- Load file library jQuery -->

    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>


    <!-- Load file library Popper JS -->

    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>


    <!-- Load file library JavaScript -->

    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>

</head>

<body>

    <div class='container'>

    

        <table class="table table-bordered">

            <thead>

                <tr>

                    <th> No</th> <th>NIK</th> <th>Nama</th> <th colspan='2'>Aksi</th>

                </tr>

            </thead>

            <tbody>

                <?php

                $no=1;

                foreach ($hasil as $item)

                {

                ?>

                <tr>

                    <td><?php echo $no;?></td>

                    <td><?php echo $item->nim;?></td>

                    <td><?php echo $item->nama;?></td>

                    

                    

                    <td> <a href="<?php echo base_url()?>mhs/update/<?php echo $item->nim; ?>" class="btn btn-warning" role="button">Update</a></td>

                    <td> <a href="<?php echo base_url()?>mhs/hapus/<?php echo $item->nim; ?>" class="btn btn-danger" role="button">Delete</a></td>

                </tr>

                <?php

                        $no++;

                }

                 ?>

            </tbody>

        </table>

        <a href="<?php echo base_url()?>mhs/tambah" class="btn btn-primary" role="button">Tambah Data</a>

    </div>

</body>

</html>


7. Buka direktori application/views/folder masing-masing

8. Buatlah file v_tambah_mhs.php

9. Salinlah script ini:

<!DOCTYPE html>

<html>

<head>

    <!-- Load file CSS Bootstrap -->

    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">


    <!-- Load file library jQuery -->

    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>


    <!-- Load file library Popper JS -->

    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>


    <!-- Load file library JavaScript -->

    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>

</head>

<body>

<div class="container">

    <h2>Tambah mahasiswa</h2>

    <form action="<?php echo base_url()?>mhs/simpan_mahasiswa" method="post">

        <div class="form-group">

            <label>NIM:</label>

            <input type="text" name="nim" class="form-control" placeholder="NIM" />

        </div>

        <div class="form-group">

            <label>Nama:</label>

            <input type="text" name="nama" class="form-control" placeholder="Nama" />

        </div>

        


        <button type="submit" class="btn btn-primary">Tambah</button>


    </form>

</div>

</body>

</html>


10. Buka direktori application/views/folder masing-masing

11. Buatlah file v_update_mhs.php

12. Salinlah script ini:

<!DOCTYPE html>

<html>

<head>

    <!-- Load file CSS Bootstrap -->

    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">


    <!-- Load file library jQuery -->

    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>


    <!-- Load file library Popper JS -->

    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>


    <!-- Load file library JavaScript -->

    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>

</head>

<body>

<div class="container">

    <h2>Update mahasiswa #<?php echo $ambil->nim; ?></h2>

    <form action="<?php echo base_url()?>mhs/simpan_update" method="post">

       

        <input type="hidden" name="nim"  value="<?php echo $ambil->nim; ?>" />

       

        <div class="form-group">

            <label>Nama:</label>

            <input type="text" name="nama" class="form-control" value="<?php echo $ambil->nama; ?>" placeholder="Nama" />

        </div>

        


        <button type="submit" class="btn btn-primary">Update</button>


    </form>

</div>

</body>

</html>


13. Buka application/models

14. Buatlah file M_Mhs.php

15. Salinlah script ini:

<?php

Class M_Mhs extends CI_Model

{

  function TampilMahasiswa() 

    {

        $this->db->order_by('nim', 'ASC');

        return $this->db->from('tasdik')

          ->get()

          ->result();

    }


    function GetNik($nik = '')

    {

      return $this->db->get_where('tasdik', array('nim' => $nik))->row();

    }

    function HapusMahasiswa($nik)

    {

        $this->db->delete('tasdik',array('nim' => $nik));

    }

}

?>


16. Jalankan dengan link seperti ini

lab1.katabah.com/pagi/mhs

*mhs ganti dengan nama file masing-masing

*Kelas sore, ganti pagi menjadi sore


17. Selesai.


Tutorial Lainnya:

 CI Pertemuan 4 Tombol Tambah Hingga Berfungsi (Di Hosting)

CI Pertemuan 3 Membuat Form Tambah di Code Igniter (Di Hosting)


"Bitcoin and Forex are high risk business. We must join them smartly."
Belajar Bahasa Inggris dan Arab di Telegram dan FB Gratis!
Youtube: Katabah Com: Menuju 1 jt Konten :)

No comments:

Post a Comment