select('playlist', '*', 'mac_address = :mac_address', '', [':mac_address' => $macAddress]); if (!empty($result)) { if ($result[0]['pin'] == $pin) { echo '{"status":true,"message":"Parental Pin Set"}'; }else{ $data = ['pin' => $pin]; $db->update('playlist', $data, 'mac_address = :mac_address', [':mac_address' => $macAddress]); echo '{"status":true,"message":"Parental Pin updated Successfully"}'; } } }else{ $newURL = $playlistData['playlist_url']; $dnsId = $playlistData['playlist_id']; $playlistName = $playlistData['playlist_name']; $urlParts = parse_url($newURL, PHP_URL_QUERY); parse_str($urlParts, $parsed); $username = $parsed['username']; $password = $parsed['password']; $result = $db->select('playlist', '*', 'dns_id = :dns_id AND mac_address = :mac_address', '', [':dns_id' => $dnsId,':mac_address' => $macAddress]); if (!empty($result)) { $data = ['username' => $username,'password' => $password,]; $db->update('playlist', $data, 'dns_id = :dns_id AND mac_address = :mac_address', [':dns_id' => $dnsId,':mac_address' => $macAddress]); $response = ['success' => 1, 'id' => $dnsId, 'name' => $playlistName, 'url' => $newURL]; echo json_encode($response); } else { echo ['success' => 0]; } }