User Tools

Site Tools


tutorials:other:online_playlist_on_your_website_with_php_mysql

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
tutorials:other:online_playlist_on_your_website_with_php_mysql [2014/08/14 09:33] – [Setting up mAirList HTTP Logging] twtutorials:other:online_playlist_on_your_website_with_php_mysql [2021/06/18 06:40] (current) – Version ohne Datenbank 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). 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 ===== ===== 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.
 +
 +====== Alternative Version without MySQL ======
 +
 +Here's a simple alternative version of the approach that does not use a database but only stores the current artist/title in a temporary file:
 +
 +inject.php:
 +
 +<code php>
 +<?php
 +
 +$handle = fopen('/tmp/nowplaying.txt', 'w');
 +fwrite($handle, $_REQUEST['artist']. "\n");
 +fwrite($handle, $_REQUEST['title']. "\n");
 +fclose($handle);
 +
 +print "OK";
 +</code>
 +
 +nowplaying.php:
 +
 +<code php>
 +<?php
 +
 +$handle = fopen('/tmp/nowplaying.txt', 'r');
 +$artist = fgets($handle);
 +$title = fgets($handle);
 +fclose($handle);
 +
 +print "Now playing: $artist - $title";
 +</code>
  
tutorials/other/online_playlist_on_your_website_with_php_mysql.1408008835.txt.gz · Last modified: 2019/07/09 16:19 (external edit)

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki