<?php
	//first:connect to db
	include "conn.php";
	
	//second?
	$oid = $_GET['id'];

	//create sql
	$sql="DELETE FROM online_ordering WHERE Order_ID= $oid";
	mysqli_query($conn, $sql);
	
	//if unsuccessfully deleted...then
	if(mysqli_affected_rows($conn)<=0)
	{
	echo "<script>alert('Unable to delete data!');";
	die ("window.location.href='my_purchases.php';</script>");
	}
	
	//successfully deleted then...
	echo "<script>alert('Your order has been cancelled!');</script>";
    echo "<script>window.location.href='my_purchases.php';</script>";
    
    $sql1 = "DELETE FROM online_payment WHERE Payment_ID = '$oid'";
    $result1 = mysqli_query($conn, $sql1);
	
?>