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