done7.php

<?php
include("staffconn.php");
$id = intval($_GET['id']);
$result = mysqli_query($con,"INSERT INTO product SELECT product_id, product_name, product_price, product_image, product_code FROM staffproduct WHERE product_id=$id");

$sql = "UPDATE staffproduct SET product_status='Available' WHERE product_id=$id";
	if(!mysqli_query($con,$sql))
	{
	die('Error:'.mysqli_error($con));
	}	
	echo '<script>alert("Successfully Updated!");
	window.location.href="updateprice.php";
	</script>';	
mysqli_close($con);

?>