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/edit.php | 57 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 57 insertions(+) create mode 100644 www/edit.php (limited to 'www/edit.php') diff --git a/www/edit.php b/www/edit.php new file mode 100644 index 0000000..1c61148 --- /dev/null +++ b/www/edit.php @@ -0,0 +1,57 @@ +. +*/ + +require 'config.php'; +require 'common.php'; + +$result = array(); + +try +{ + $db = ConnectDB(); + + $id = $_REQUEST["id"]; + $description = $_REQUEST["description"]; + $username = $_REQUEST["username"]; + $password = $_REQUEST["password"]; + + $cmd = $db->prepare("UPDATE pm_store " . + "set description=:description, " . + "username=:username, " . + "password=:password) where id = :id"); + $cmd->bindParam(":id", $id); + $cmd->bindParam(":description", $description); + $cmd->bindParam(":username", $username); + $cmd->bindParam(":password", $password); + $cmd->execute(); + + $result["status"] = true; + + $db = null; +} +catch(PDOException $e) +{ + result["error"] = "DB error:" . $e->getMessage(); +} + +header("Content-type:application/json"); +echo json_encode($result); + +?> -- cgit v1.2.3