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
$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