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 [2014/08/14 09:36] – [Retrieving the Data] tw
@@ Line 74: / Line 74: @@
 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.