num_rows < 1){ echo '{"error":"device-id does not exist", "device-id": "' . $device_id . '"}'; exit; } $result = $query->fetch_assoc(); $id = $result['id']; //Delete all related data $sql = "DELETE FROM device WHERE id=$id"; ExecQuery($mysqli, $sql); $sql = "DELETE FROM alarm WHERE dev_id=$id"; ExecQuery($mysqli, $sql); $sql = "DELETE FROM stream WHERE dev_id=$id"; ExecQuery($mysqli, $sql); echo '{"success":"true"}'; ?>