Meet 6 – Menampilkan Detail Data dan Pencarian
Buat Sebuah Controller dengan nama Mahasiswa.php (dalam folder application/controllers)
<?php defined('BASEPATH') OR exit('No direct script access allowed'); class Mahasiswa extends CI_Controller { function __construct() { parent::__construct(); $this->load->model('Mhs_model'); } public function index() { $data = array( 'judul' => 'Daftar Nama Mahasiswa', 'jurusan' => 'Informatics Computer', 'cari' => '', 'mhs' => $this->Mhs_model->data(), ); $this->load->view('data_mhs',$data); } public function penggunaan_where($id){ $mhs = $this->Mhs_model->data_where($id); if($mhs){ $data_where = array( 'judul' => 'Daftar Nama Mahasiswa (Menggunakan Where ID)', 'jurusan' => 'Informatics Computer', 'nim' => $mhs->nim, 'nama' => $mhs->nama, 'jur' => $mhs->jurusan, ); $this->load->view('data_mhs_where',$data_where); }else{ redirect('mahasiswa'); } } public function pencarian(){ $cari = urldecode($this->input->get('cari', TRUE)); $data = array( 'judul' => 'Daftar Nama Mahasiswa (Pencarian untuk Kata '.$cari.' )', 'jurusan' => 'Informatics Computer', 'cari' => $cari, 'mhs' => $this->Mhs_model->data_pencarian($cari), ); $this->load->view('data_mhs',$data); } }
Kemudian Buat Sebuah Model dengan nama Mhs_model (dalam folder application/models)
<?php if (!defined('BASEPATH')) exit('No direct script access allowed'); class Mhs_model extends CI_Model { function __construct() { parent::__construct(); } function data(){ return $this->db->get('data_mhs')->result(); } function data_where($id){ $this->db->select('*'); $this->db->where('id',$id); $this->db->from('data_mhs'); return $this->db->get()->row(); } function data_pencarian($cari){ $this->db->select('*'); $this->db->like('nim',$cari); $this->db->or_like('nama',$cari); $this->db->or_like('jurusan',$cari); $this->db->from('data_mhs'); return $this->db->get()->result(); } }
Buat 2 buah View dalam folder application/views :
- buat view dengan nama data_mhs.php
<!doctype html> <html> <head> <title>Data Mahasiswa</title> </head> <body> <h1>### CONTOH MENAMPILKAN DATA ###</h1><hr> <h1><?php echo $judul;?></h1> Kolom Pencarian <form action="<?php echo base_url('mahasiswa/pencarian?')?>" method="get"> <input type="text" value="<?php echo $cari;?>" name="cari"> <button type="submit">Cari</button> <a href="<?php echo base_url('mahasiswa')?>">Kembali</a> </form> <table width="100%" border="1"> <tr> <th>No</th> <th>NIM</th> <th>Nama</th> <th>Jurusan</th> <th>Aksi</th> </tr> <?php $nomor = 1; foreach($mhs as $mhs){ ?> <tr> <td><?php echo $nomor++;?></td> <td><?php echo $mhs->nim;?></td> <td><?php echo $mhs->nama;?></td> <td><?php echo $mhs->jurusan;?></td> <td><a href="<?php echo base_url('mahasiswa/penggunaan_where/'.$mhs->id)?>">Lihat Data</a></td> </tr> <?php } ?> </table> </body> </html>
- buat view dengan nama data_mhs_where.php
<!doctype html> <html> <head> <title>Data Mahasiswa</title> </head> <body> <h1>### CONTOH MENAMPILKAN DATA ###</h1><hr> <h1><?php echo $judul;?></h1> <table width="50%" border="1"> <tr> <td>NIM</td> <td>:</td> <td><?php echo $nim;?></td> </tr> <tr> <td>NAMA</td> <td>:</td> <td><?php echo $nama;?></td> </tr> <tr> <td>JURUSAN</td> <td>:</td> <td><?php echo $jur;?></td> </tr> </table> <a href="<?php echo base_url('mahasiswa');?>">Kembali</a> </body> </html>
*** Selamat Mencoba ***