invisio v2.0

<!DOCTYPE html>
<html lang="en">
	<head>
		<meta charset="utf-8" />
	</head>
	<body>
		<?php
			include('config.php');
			
			$jvstat = 'Pending';
			echo $refid = filter_input(INPUT_GET, 'expid');
			
			$resultq = $js->prepare('SELECT * FROM `expenses` WHERE `expid` = :refid');
			$resultq->execute(array(':refid' => $refid));	
			while($row = $resultq->fetch(PDO::FETCH_ASSOC)) 
			
			{
				 $jvid = $row['jvid'];
			}

if($jvid != '')
			{
				$sql = 'UPDATE `journal_voucher` SET jvstatus = :jvstat WHERE `id` = :jvid';
				
				$js->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$query1 = $js->prepare($sql);
				$status1 = $query1->execute(array(':jvid' => $jvid,
												  ':jvstat' => $jvstat));	
			}
			
			$js->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
			$result11 = $js->prepare('DELETE FROM `expenses` WHERE `expid` = :refid ');
			$result11->bindParam(':refid', $refid);
			$result11->execute();

if ($result11) {
				$f = 1;
			} else {
				print_r($js->errorInfo());
			}

if($f == 1) {
		?>
				<script type="text/javascript">
				alert("Have Successfully Deleted The Expense Made");
				window.location = 'companyexpense.php'</script>
				<?php
			} 
		?>
	</body>
</html>