CRUD

Kamis, 19 Februari 2015

model.php

<?php
class M_asu extends CI_Model{

   function show(){
   $query = $this->db->get('mahasiswa'); //SELECT * FROM mahasiswa
   return $query->result();
   }

   function per_id($id){
   $this->db->where('nim',$id); //select * from mahasiswa where nim=$id
   $query=$this->db->get('mahasiswa');
   return $query->result();
   }

   function update($id,$data){
   $this->db->where('nim',$id);
   $update=$this->db->update('mahasiswa',$data);
   return $update; //update mahasiswa set nim='$baru',nama='$baru',jurusan='$baru' where nim=3123311091

   }

   function insert($data){
   $tambah=$this->db->insert('mahasiswa',$data);
   return $tambah; //insert into mahasiswa values ('extrax data');

   }

   function delete($id){
   $this->db->where('nim', $id);
   $delete=$this->db->delete('mahasiswa');
   return $delete; //delete from mahasiswa where nim=3123311091
   }

}

controller.php

<?php
class C_asu extends CI_Controller{
   function __construct(){
   parent::__construct();
   $this->load->helper('url');
   $this->load->model('m_asu');
   }

   function index(){
   $data['data']=$this->m_asu->show(); //memanggil model kemudian nama function show untuk menampikan data
   $this->load->view('asu/display',$data);
   }

   function frm_insert(){
   $this->load->view('asu/frm_insert');
   }

   function frm_edit(){
   $nim=$this->uri->segment(3);
   $data['data']=$this->m_asu->per_id($nim); //controller memanggil model
   $this->load->view('asu/frm_update',$data);
   }
   function proses_update(){ //update
   $nim=$this->input->post('nim');
   $data=array('nim'=>$this->input->post('nim'),
   'nama'=>$this->input->post('nama'),
   'jurusan'=>$this->input->post('jurusan'),
   'alamat'=>$this->input->post('alamat'));
   $this->m_asu->update($nim,$data); //memanggil model dan function insert
   redirect('c_asu');
   }

   function proses_insert(){ //insert
   $data=array('nim'=>$this->input->post('nim'),
   'nama'=>$this->input->post('nama'),
   'jurusan'=>$this->input->post('jurusan'),
   'alamat'=>$this->input->post('alamat'));
   $this->m_asu->insert($data); //memanggil model dan function insert
   redirect('c_asu');

   }

   function delete(){
   $nim=$this->uri->segment(3); //delete data sudah
   $this->m_asu->delete($nim);
   redirect('c_asu');


   }



}

view :
1. display
2. frm_insert
3. frm_update

1. display

<h1>Data Mahasiswa</h1>

<a href="<?php echo site_url();?>/c_asu/frm_insert">Tambah Data</a>

<tr><td>No</td><td>Nim</td><td>Nama</td><td>Jurusan</td><td>Alamat</td><td>Action</td></tr>

<?php

$no=0;

foreach ($data as $row):

$no++;

<tr>

<td><?php echo $row->jurusan; ?></td>

<td><?php echo $row->alamat; ?></td>

<td>

<a href="<?php echo site_url();?>/c_asu/frm_edit/<?php echo $row->nim; ?>">edit</a> |

<a href="<?php echo site_url();?>/c_asu/delete/<?php echo $row->nim; ?>">delete</a></td>

<?php endforeach;?>

</tr>

</table>

2. frm_insert

<h1>Tambah Data Mahasiswa</h1>

<form action="<?php echo site_url(); ?>/c_asu/insert" method="post">

nim <input type="text" name="nim"/><br />

nama <input type="text" name="nama"/><br />

jurusan <input type="text" name="jurusan"/><br />

alamat <input type="text" name="alamat"/><br />

</form>

3. frm_update

<h1>Tambah Data Mahasiswa</h1>
<form action="<?php echo site_url();?>/c_asu/proses_update" method="post">
<?php foreach ($data as $row): ?>
nim <input type="text" name="nim" value="<?php echo $row->nim; ?>"/><br />
nama <input type="text" name="nama" value="<?php echo $row->nama; ?>"/><br />
jurusan <input type="text" name="jurusan" value="<?php echo $row->jurusan; ?>"/><br />
alamat <input type="text" name="alamat" value="<?php echo $row->alamat; ?>"/><br />
<input type="submit" name="simpan" value="UPDATE"/>
<?php endforeach;?>
</form>

http://tempatberbagi.com/2013/01/belajar-php-menghitungmengurangi-tanggal-pada-pemrograman-php/

https://ghantexs16.wordpress.com/2014/03/17/aplikasi-perpustakaan-dengan-codeigniter-bootstrap-3/

http://melciorseisura.blogspot.com/2012/06/contoh-aplikasi-crud-codeigniter.html
http://ilmukomputer.org/2012/07/29/aplikasi-crud-dengan-codeigniter/
http://jagocoding.com/tutorial/684/Fungsi_Insert_Data_dalam_CRUD_CREATE_READ_UPDATE_DELETE_di_Codeigniter
http://seputarpemrograman.com/contoh-create-read-update-dan-delete-crud-menggunakan-framework-codeigniter-dan-twitter-bootstrap.html
http://amitavroy.com/justread/content/articles/part-4-basic-crud-codeigniter

Previous

0 Komentar untuk "CRUD"