Skip to content

Instantly share code, notes, and snippets.

@bangiqi
Last active November 27, 2016 16:33
Show Gist options
  • Save bangiqi/2d3cbfe8279e4460de6bdb848efdedde to your computer and use it in GitHub Desktop.
Save bangiqi/2d3cbfe8279e4460de6bdb848efdedde to your computer and use it in GitHub Desktop.
query delete di codeigniter
<?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