prepare("SELECT id FROM dns WHERE url = :url"); $urlStmt->bindValue(':url', $dnsUrl, SQLITE3_TEXT); $urlResult = $urlStmt->execute(); $dnsId = $urlResult->fetchArray(SQLITE3_ASSOC)['id']; if ($dnsId) { $updateStmt = $db->prepare("UPDATE playlist SET username = :username, password = :password, dns_id = :dns_id WHERE mac_address = :mac"); $updateStmt->bindValue(':mac', $macAddress, SQLITE3_TEXT); $updateStmt->bindValue(':username', $username, SQLITE3_TEXT); $updateStmt->bindValue(':password', $password, SQLITE3_TEXT); $updateStmt->bindValue(':dns_id', $dnsId, SQLITE3_INTEGER); $updateStmt->execute(); echo json_encode(['success' => true]); } else { echo json_encode(['success' => false, 'error' => 'DNS URL não encontrada']); } exit; } $macAddress = $_POST['mac_address']; $dbPath = __DIR__ . '/api/.db.db'; $db = new SQLite3($dbPath); $stmt = $db->prepare("SELECT p.username, p.password, d.url FROM playlist AS p JOIN dns AS d ON p.dns_id = d.id WHERE p.mac_address = :mac"); $stmt->bindValue(':mac', $macAddress, SQLITE3_TEXT); $result = $stmt->execute(); $data = $result->fetchArray(SQLITE3_ASSOC); if ($data) { $urlStmt = $db->prepare("SELECT url FROM dns"); $urlResult = $urlStmt->execute(); $urls = []; while ($row = $urlResult->fetchArray(SQLITE3_ASSOC)) { $urls[] = $row['url']; } $data['urls'] = $urls; echo json_encode($data); exit; } else { echo json_encode(['error' => 'MAC Address não encontrado']); exit; } } ?> Manage Playlists

Adicionar ou Alterar Clientes!

Username:

Password:

DNS URL: