. */ require 'config.php'; require 'common.php'; $result = array(); try { $db = ConnectDB(); $index = 0; foreach ($db->query("SELECT * FROM pm_store ORDER BY display") as $row) { $data = array(); $data["id"] = $row["id"]; $data["description"] = $row["description"]; $data["group"] = $row["groupname"]; $data["username"] = $row["username"]; $data["password"] = $row["password"]; $data["display"] = $row["display"]; $result[$index++] = $data; } $db = null; } catch(PDOException $e) { $result["error"] = "DB error:" . $e->getMessage(); } header("Content-type:application/json"); echo json_encode($result); ?>