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/get.php | 53 +++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 53 insertions(+) create mode 100644 www/get.php (limited to 'www/get.php') diff --git a/www/get.php b/www/get.php new file mode 100644 index 0000000..268bf5b --- /dev/null +++ b/www/get.php @@ -0,0 +1,53 @@ +. +*/ + +require 'config.php'; +require 'common.php'; + +$result = array(); + +try +{ + $db = ConnectDB(); + + $index = 0; + + foreach ($db->query("SELECT * FROM pm_store") as $row) + { + $data = array(); + $data["id"] = $row["id"]; + $data["description"] = $row["description"]; + $data["username"] = $row["username"]; + $data["password"] = $row["password"]; + + $result[$index++] = $data; + } + + $db = null; +} +catch(PDOException $e) +{ + $result["error"] = "DB error:" . $e->getMessage(); +} + +header("Content-type:application/json"); +echo json_encode($result); + +?> -- cgit v1.2.3