<?php require_once('header.php'); ?>

<?php
if (!isset($_REQUEST['id'])) {
	header('location: logout.php');
	exit;
} else {
	// Check the id is valid or not
	$statement = $pdo->prepare("SELECT * FROM tbl_service WHERE id=?");
	$statement->execute(array($_REQUEST['id']));
	$total = $statement->rowCount();
	if ($total == 0) {
		header('location: logout.php');
		exit;
	}
}
?>

<?php

// Getting photo ID to unlink from folder
$statement = $pdo->prepare("SELECT * FROM tbl_service WHERE id=?");
$statement->execute(array($_REQUEST['id']));
$result = $statement->fetchAll(PDO::FETCH_ASSOC);
foreach ($result as $row) {
	$photo = $row['photo'];
}

// Unlink the photo
if ($photo != '') {
	unlink('assets/images/services-image/' . $photo);
}

// Delete from tbl_service
$statement = $pdo->prepare("DELETE FROM tbl_service WHERE id=?");
$statement->execute(array($_REQUEST['id']));

header('location: service.php');
?>