hapus-kriteria.php

<?php require_once('includes/init.php'); ?>


<?php
$ada_error = false;
$result = '';

$id_kriteria = (isset($_GET['id'])) ? trim($_GET['id']) : '';

if(!$id_kriteria) {
	$ada_error = 'Maaf, data tidak dapat diproses.';
} else {
	$query = $pdo->prepare('SELECT id_kriteria FROM kriteria WHERE kriteria.id_kriteria = :id_kriteria');
	$query->execute(array('id_kriteria' => $id_kriteria));
	$result = $query->fetch();
	
	if(empty($result)) {
		$ada_error = 'Maaf, data tidak dapat diproses.';
	} else {
		$handle = $pdo->prepare('DELETE FROM nilai_kenshin WHERE id_kriteria = :id_kriteria');				
		$handle->execute(array(
			'id_kriteria' => $result['id_kriteria']
		));
		$handle = $pdo->prepare('DELETE FROM pilihan_kriteria WHERE id_kriteria = :id_kriteria');				
		$handle->execute(array(
			'id_kriteria' => $result['id_kriteria']
		));
		$handle = $pdo->prepare('DELETE FROM kriteria WHERE id_kriteria = :id_kriteria');				
		$asem = $handle->execute(array(
			'id_kriteria' => $result['id_kriteria']
		));
		redirect_to('list-kriteria.php?status=sukses-hapus&kyu='.$_GET['kyu']);
	}
}
?>

<?php
$judul_page = 'Hapus Kriteria';
require_once('template-parts/header.php');
?>

	<div class="main-content-row">
	<div class="container clearfix">
	
		<?php include_once('template-parts/sidebar-kriteria.php'); ?>
	
		<div class="main-content the-content">
			<h1><?php echo $judul_page; ?></h1>
			
			<?php if($ada_error): ?>
			
				<?php echo '<p>'.$ada_error.'</p>'; ?>
			
			<?php endif; ?>
			
		</div>
	
	</div><!-- .container -->
	</div><!-- .main-content-row -->


<?php
require_once('template-parts/footer.php');