740f79f85c6cb4d08f845fd80fe375894f20fb77
3 const BASE_URL
= 'https://api.spotify.com/v1/';
4 // Currently updated manually whenever I get one from the server
5 const SPOT_TOKEN
= 'BQCQTtwO2kiMcV_VDgfSmTXQzGlO47rUuPyc4oCHpRunPQx2ZhhVYOtksVZPMbSgoCy3cGiRMHMygon5-SleqfsP0lvRMQW3gm1Q_a8TRv5MfCGQdNwdUcUu_NBpcSjWDNUadWeg3ps-WTDWxjUWm_FOlfxMy7a2AdI_RHWZ0Lx56WHf8gYA4-YVUm_HxpqDlReqEkWE9DHppQ';
7 $pdo = new PDO("sqlite:mktplc.sqlite3");
9 $stmt = $pdo->prepare("SELECT * FROM SONGS WHERE uri IS NULL");
10 $upstmt = $pdo->prepare("UPDATE songs SET (uri) = :uri WHERE id = :id");
11 $upstmt->bindParam(':uri', $uri);
12 $upstmt->bindParam(':id', $id);
14 if ($stmt->execute()) {
16 print_r($stmt->fetchAll());
18 while ($row = $stmt->fetch()) {
23 'header' => 'Authorization: Bearer ' . SPOT_TOKEN
. "\r\n"
27 $track_context = stream_context_create($track_opts);
29 $track_search_url = BASE_URL
. 'search?q=track:' . urlencode($row['track'])
30 . '+artist:' . urlencode($row['artist']) . '&type=track';
32 $trackReq = file_get_contents($track_search_url, false, $track_context);
34 $trackJSON = json_decode($trackReq, true);
35 $trackJSON = $trackJSON['tracks'];
36 if ($trackJSON['total'] === 0) {
40 $uri = $trackJSON['items'][0]['uri'];