Differences

This shows you the differences between two versions of the page.

--- tutorials:other:online_playlist_on_your_website_with_php_mysql [2014/08/14 09:33] – [Setting up mAirList HTTP Logging] tw
+++ tutorials:other:online_playlist_on_your_website_with_php_mysql [2019/07/09 16:18] – external edit 127.0.0.1
@@ Line 72: / Line 72: @@
 That's pretty much it. If you protected your script with an ''.htaccess'' file, enter the user/password. If you only want particular item types to be logged (e.g. only music but no jingles), go to the //Item Types// tab and uncheck the types that should be filtered.
-Now run mAirList, start a couple of songs and watch how the ''playlistlog'' table is populated. In case of any errors, it is a good idea to check the mAirList System Log (double-click the status bar at the bottom of the mAirList main window).
+Now run mAirList, start a couple of songs and watch how the ''playlistlog'' table is populated. If it doesn't work, it's a good idea to check the mAirList System Log for any error messages (double-click the status bar at the bottom of the mAirList main window).
 ===== Retrieving the Data =====
+Once the data is in the ''playlistlog'' table, you can use very simple PHP code to retrieve the last few songs:
+<code php>
+<?php
+  $db = mysqli_connect('localhost', 'mairlist', 'secret', 'logdatabase');
+  $res = mysqli_query($db, 'SELECT starttime, artist, title FROM playlistlog ORDER BY starttime DESC LIMIT 10');
+  print "<table>\n";
+  while (list ($starttime, $artist, $title) = mysqli_fetch_row($res)) {
+    print "<tr><td>$starttime</td><td>$artist</td><td>$title</td></tr>\n";
+  }
+  mysqli_free_result($res);
+  print "</table>\n";
+</code>
+As all entries are stored along with the date/time the song was started, it is also possible to implement a search function that looks up the songs played in a given time frame.