Last active
November 27, 2016 16:33
-
-
Save bangiqi/2d3cbfe8279e4460de6bdb848efdedde to your computer and use it in GitHub Desktop.
query delete di codeigniter
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
//model misal ada di Devisi model | |
public function deleteDivisi($id){ | |
$sql = "DELETE FROM devisi WHERE id=$id"; | |
$query = $this->db->query($sql); | |
return $query->result(); | |
} | |
//view | |
//loop data di view | |
//$dataDivisi berasal dari $this->load->view('lihat_divisi', $data); | |
foreach($dataDivisi as $divisi){ | |
//misal : http://localhost/keuangan/divisi/delete/1 | |
echo "<a href='".base_url()."divisi/delete/".$divisi->id."'></a>"; | |
} | |
//controller | |
//misal disini pake Controller Divisi | |
public function delete($idFromView){ | |
//misal fungsi deleteDivisi ada dimodel Devisi | |
$actDeletedivisi = $this->Divisi->deleteDivisi($idFromView); | |
//kondisi cek jika query delete nilainya benar (TRUE) | |
if($actDeletedivisi){ | |
//maka akan eksekusi | |
echo "berhasil didelete"; | |
//langsung beralih otomatis ke halaman devisi | |
redirect('/devisi'); | |
}else{ | |
echo "gagal didelete"; | |
//bisa kasih peringatan berupa alert notif | |
} | |
} | |
?> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment