const BASE_URL = 'https://api.spotify.com/v1/';\r
const AUTH_URL = 'https://accounts.spotify.com/';\r
const DATE_FILE = 'prev_date.txt';\r
- const DATE_FORM = 'm/d/Y';\r
const MONTHS = [\r
'01' => 'January',\r
'02' => 'February',\r
/*'header' => "Content-type: application/x-www-form-urlencoded\r\n"\r
. "Content-Length: " . strlen($token_data) . "\r\n"\r
. "Authorization: Basic " . base64_encode('868e2cba00de4819900dd8a647a7ba7d:' . CLIENT_SECRET) . "\r\n",*/\r
- 'header' => "Authorization: Basic " . base64_encode('868e2cba00de4819900dd8a647a7ba7d:' . CLIENT_SECRET) . " \r\n",\r
+ 'header' => "Authorization: Basic " . base64_encode('93a6f9c0375c45d4b348157691aa24e8:' . CLIENT_SECRET) . " \r\n",\r
'content' => $token_data\r
]\r
];\r
$uris = [];\r
\r
$pdo = new PDO("sqlite:mktplc.sqlite3");\r
- $stmt = $pdo->prepare("SELECT uri FROM songs s WHERE (SELECT strftime('%m', s.date) == :month and strftime('%Y', s.date) == :year;");\r
+ $stmt = $pdo->prepare("SELECT uri FROM songs s WHERE uri IS NOT NULL AND strftime('%m', s.date) == :month AND strftime('%Y', s.date) == :year");\r
$stmt->bindParam(':month', $state[0]);\r
$stmt->bindParam(':year', $state[1]);\r
if ($stmt->execute()) {\r
echo '<br />';\r
print_r(json_encode($update_data));\r
$update_req = file_get_contents(BASE_URL . 'users/' . $me_id . '/playlists/' . $playlistID . '/tracks', false, $update_context);\r
- print_r($update_req);\r
- \r
- file_put_contents(DATE_FILE, $recentEpDT->format(DATE_FORM));\r
-
\ No newline at end of file
+ print_r($update_req);
\ No newline at end of file