Admin - Delete Product

function deleteProduct()
{
   if (isset($_GET['productId']) && (int)$_GET['productId'] > 0) {
      $productId = (int)$_GET['productId'];
   } else {
      header('Location: index.php');
   }

   // remove any references to this product from
   // tbl_order_item and tbl_cart
   $sql = "DELETE FROM tbl_order_item
           WHERE pd_id = $productId";
   dbQuery($sql);

   $sql = "DELETE FROM tbl_cart
           WHERE pd_id = $productId";
   dbQuery($sql);

   // get the image name and thumbnail
   $sql = "SELECT pd_image, pd_thumbnail
           FROM tbl_product
           WHERE pd_id = $productId";

   $result =& dbQuery($sql);
   $row =& dbFetchAssoc($result);

   // remove the product image and thumbnail
   if ($row['pd_image']) {
      unlink(SRV_ROOT . 'images/product/' . $row['pd_image']);
      unlink(SRV_ROOT . 'images/product/' . $row['pd_thumbnail']);
   }

   // remove the product from database;
   $sql = "DELETE FROM tbl_product
           WHERE pd_id = $productId";
   dbQuery($sql);

   header('Location: index.php');
}