From 7964a8ba3dd041511c483b7f220b6d14d71ef69e Mon Sep 17 00:00:00 2001 From: Ian C Date: Fri, 22 Jun 2018 12:50:04 +0000 Subject: Initial attempt at data interface. --- www/delete.php | 54 ++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 54 insertions(+) create mode 100644 www/delete.php (limited to 'www/delete.php') diff --git a/www/delete.php b/www/delete.php new file mode 100644 index 0000000..7d97c0c --- /dev/null +++ b/www/delete.php @@ -0,0 +1,54 @@ +. +*/ + +require 'config.php'; +require 'common.php'; + +$result = array(); + +try +{ + $db = ConnectDB(); + + $id = filter_var($_REQUEST["id"], FILTER_VALIDATE_INT); + + if ($id !== FALSE) + { + $cmd = $db->prepare("DELETE FROM pm_store WHERE id = :id"); + $cmd->bindParam(":id", $id); + $cmd->execute(); + $result["status"] = true; + } + else + { + $result["error"] = "Invalid inputs"; + } + + $db = null; +} +catch(PDOException $e) +{ + $result["error"] = "DB error:" . $e->getMessage(); +} + +header("Content-type:application/json"); +echo json_encode($result); + +?> -- cgit v1.2.3