v0.3.3:

[Marketplaylister.git] / searchify.php

diff --git a/searchify.php b/searchify.php
index 949abf9..a6391c0 100644 (file)
--- a/searchify.php
+++ b/searchify.php
@@ -1,48 +1,45 @@
 <?php
 
-    const BASE_URL = 'https://api.spotify.com/v1/';
-    // Currently updated manually whenever I get one from the server
-    const SPOT_TOKEN = 'BQBU1Qs3ROpkN9CwlQNpZS00khdSU61zuejyKbjS4KiIszK8aiLaTd9TfPiSH0OsmtWStOVL7ym-QYEBWyLX3qlFIN5peit0n6_B-LLtz4C8KSh3Dxj5O3jf4HSWf3fFISC4cLbznfSV3QnpQ4vdnCTehz4vT8V54XDiG2hX275Uw_gDHzKjqFWQo249-rY42rBv7pf555wQ2PSBymuZMcDlIDEeAbGiyRI';
-  
-    $pdo = new PDO("sqlite:mktplc.sqlite3");
-    
-    $stmt = $pdo->prepare("SELECT * FROM SONGS WHERE uri IS NULL");
-    $upstmt = $pdo->prepare("UPDATE songs SET (uri) = :uri WHERE id = :id");
-    $upstmt->bindParam(':uri', $uri);
-    $upstmt->bindParam(':id', $id);
-    
-    if ($stmt->execute()) {
-      
-      #print_r($stmt->fetchAll());
-      while ($row = $stmt->fetch()) {
-        
+const BASE_URL = 'https://api.spotify.com/v1/';
+// Currently updated manually whenever I get one from the server
+const SPOT_TOKEN = 'BQBU1Qs3ROpkN9CwlQNpZS00khdSU61zuejyKbjS4KiIszK8aiLaTd9TfPiSH0OsmtWStOVL7ym-QYEBWyLX3qlFIN5peit0n6_B-LLtz4C8KSh3Dxj5O3jf4HSWf3fFISC4cLbznfSV3QnpQ4vdnCTehz4vT8V54XDiG2hX275Uw_gDHzKjqFWQo249-rY42rBv7pf555wQ2PSBymuZMcDlIDEeAbGiyRI';
+
+$pdo = new PDO("sqlite:mktplc.sqlite3");
+
+$stmt = $pdo->prepare("SELECT * FROM SONGS WHERE uri IS NULL");
+$upstmt = $pdo->prepare("UPDATE songs SET (uri) = :uri WHERE id = :id");
+$upstmt->bindParam(':uri', $uri);
+$upstmt->bindParam(':id', $id);
+
+if ($stmt->execute()) {
+    while ($row = $stmt->fetch()) {
+
         $track_opts = [
             'http' => [
                 'method' => 'GET',
-                'header' => 'Authorization: Bearer ' . SPOT_TOKEN . "\r\n"
+            'header' => 'Authorization: Bearer ' . SPOT_TOKEN . "\r\n"
             ]
         ];
-        
+
         $track_context = stream_context_create($track_opts);
-        
+
         $track_search_url = BASE_URL . 'search?q=track:' . urlencode($row['track']) 
-                            . '+artist:' . urlencode($row['artist']) . '&type=track';
+            . '+artist:' . urlencode($row['artist']) . '&type=track';
 
         $trackReq = file_get_contents($track_search_url, false, $track_context);
         if ($trackReq) {
-          $trackJSON = json_decode($trackReq, true);
-          $trackJSON = $trackJSON['tracks'];
-          if ($trackJSON['total'] === 0) {
-            continue;
-          }
+            $trackJSON = json_decode($trackReq, true);
+            $trackJSON = $trackJSON['tracks'];
+            if ($trackJSON['total'] === 0) {
+                continue;
+            }
 
-          $uri = $trackJSON['items'][0]['uri'];
-          $id = $row['id'];
-          $upstmt->execute();
-
-          #rate limit
-          sleep(1);
+            $uri = $trackJSON['items'][0]['uri'];
+            $id = $row['id'];
+            $upstmt->execute();
 
+            sleep(1);
         }
-      }
-    }
\ No newline at end of file
+    }
+}
+