render_status(true, false); echo json_encode($array); }else{ // get id of service, check if service exists $queryId = $mysqli->prepare("SELECT id from services where id = ?;"); $queryId->bind_param("i", $_GET['id']); $queryId->execute(); $result = $queryId->get_result()->fetch_assoc(); if (!count($result)) { die(json_encode(["error" => _("Service does not exist!")])); } // get name, description and status.type (status of service) by id $query = $mysqli->prepare("select services.id, name, description, status.type from services inner join status on status.id = services.id where services.id = ?;"); $query->bind_param("i", $_GET['id']); $query->execute(); $result = $query->get_result()->fetch_assoc(); // if type is a number then return it, else just return the service name/desc if (is_numeric($result["type"])) { $service = new Service($_GET["id"], $result["name"], $result["description"], '', $result["type"]); } else { $service = new Service($_GET["id"], $result["name"], $result["description"]); } echo json_encode($service); } }