PHP preg question

windisch · 05-20-2006, 06:47 PM

I am trying to take data off of the shoutcast page I use on my Linux box, and create a status page off of it, but I am not having luck on my own.

I want to take this line for example:
[HTML]<tr><td width=100 nowrap>Current Song: </td><td>15 Ahhh</td></tr>[/HTML]

And pull the data between
[HTML]<tr><td width=100 nowrap>Current Song: </td><td>[/HTML]
and
[HTML]</td></tr>[/HTML]

Out of this code:

[HTML]<HTML><HEAD><meta http-equiv="Content-Language" content="en-us"><meta http-equiv="Content-Type" content="text/html; charset=windows-1252"><meta http-equiv="Pragma" content="no-cache"><meta http-equiv="Expires" content="Mon, 01 Jan 1990 12:00:00 GMT"><title>SHOUTcast Administrator</title><style type="text/css"></style></HEAD><BODY topmargin=0 leftmargin=0 marginheight=0 marginwidth=0 bgcolor=#000000 text=#EEEEEE link=#001155 vlink=#001155 alink=#FF0000><table width=100% border=0 cellpadding=0 cellspacing=0><tr><td height=50>U SHOUTcast D.N.A.S. Status</td></tr><tr><td height=14 align=right><a id=ltv href="http://www.shoutcast.com/">SHOUTcast Server Version 1.9.5/Linux</a></td></tr><tr><td bgcolor=#DDDDDD height=20 align=center><table width=100% border=0 cellpadding=0 cellspacing=0><tr><td align=center><a id=tnl href="index.html">Status</a></td><td align=center> | </td><td align=center><a id=tnl href="played.html">Song History</a></td><td align=center> | </td><td align=center><a id=tnl href="listen.pls">Listen</a></td><td align=center> | </td><td align=center><a id=tnl href="home.html">Stream URL</a></td><td align=center> | </td><td align=center><a id=tnl href="admin.cgi">Admin Login</a></td></tr></table></td></tr></table> <table cellpadding=5 cellspacing=0 border=0 width=100%><tr><td bgcolor=#000025 colspan=2 align=center>Current Stream Information</td></tr></table><table cellpadding=2 cellspacing=0 border=0 align=center><tr><td width=100 nowrap>Server Status: </td><td>Server is currently up and private.</td></tr><tr><td width=100 nowrap>Stream Status: </td><td>Stream is up at 96 kbps with 1 of 3 listeners (1 unique)</td></tr><tr><td width=100 nowrap>Listener Peak: </td><td>2</td></tr><tr><td width=100 nowrap>Average Listen Time: </td><td>1h 10m 09s</td></tr><tr><td width=100 nowrap>Stream Title: </td><td>Windisch Radio: Windisch Radio</td></tr><tr><td width=100 nowrap>Content Type: </td><td>audio/mpeg</td></tr><tr><td width=100 nowrap>Stream Genre: </td><td>Misc</td></tr><tr><td width=100 nowrap>Stream URL: </td><td><a href="http://windisch.no-ip.org:8088/wmp.html">http://windisch.no-ip.org:8088/wmp.html</a></td></tr><tr><td width=100 nowrap>Stream ICQ: </td><td><a href="http://wwp.icq.com/scripts/contact.dll?msgto=1971259">1971259</a></td></tr><tr><td width=100 nowrap>Stream AIM: </td><td><a href="aim:goim?screenname=draco103">draco103</a></td></tr><tr><td width=100 nowrap>Stream IRC: </td><td><a href="http://www.shoutcast.com/chat.phtml?dc="></a></td></tr><tr><td width=100 nowrap>Current Song: </td><td>15 Ahhh</td></tr></table> <table cellpadding=0 cellspacing=0 border=0 width=100%> <tr><td bgcolor=#DDDDDD nowrap colspan=5 align=center><table cellspacing=0 cellpadding=0 border=0><tr><td>Written by Stephen 'Tag Loomis, Tom Pepper and Justin Frankel</td></tr></table></td></tr><tr><td nowrap colspan=5 align=center><a href="http://www.shoutcast.com/disclaimer.phtml">Copyright Nullsoft Inc</a><a href="/llamacookie">.</a> 1998-2004</td></tr></table></body></html>[/HTML]
Sorry about this code, thats what I get when I do a view source on the page....

I'm hoping if I could get some help on how to get a simple page that can pull this data, I can then manage to figure the rest out on my own. Any help would be appreciated.

graemef · 05-20-2006, 10:47 PM

You probably want to have a look at the strip_tags() function. That will make you data much simpler to work with.

windisch · 05-21-2006, 05:13 PM

Thanks that has gotten me started.

This is what I am up to now:

PHP Code:



<?php 
function getcontent($server, $port, $file) 
{ 
   $cont = ""; 
   $ip = gethostbyname($server); 
   $fp = fsockopen($ip, $port); 
   if (!$fp) 
   { 
       return "Unknown"; 
   } 
   else 
   { 
       $com = "GET $file HTTP/1.1\r\nAccept: */*\r\nAccept-Language: de-ch\r\nAccept-Encoding: gzip, deflate\r\nUser-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)\r\nHost: $server:$port\r\nConnection: Keep-Alive\r\n\r\n"; 
       fputs($fp, $com); 
       while (!feof($fp)) 
       { 
           $cont .= fread($fp, 500); 
       } 
       fclose($fp); 
       $cont = substr($cont, strpos($cont, "\r\n\r\n") + 4); 
       $cont = strip_tags($cont); 
 
        @preg_match('/Current Song[:][ ][a-zA-Z0-9]*/', $cont, $match); 
        $cont = ((strlen($match[1]) > 1) ? $match[1] : 'N/A'); 
 
       return $cont; 
   } 
} 
echo getcontent("windisch.no-ip.org", "8083", "/"); 
?>

I'm having difficulty getting the preg match to work correctly. I'm trying to get everything after "Current Song: " and before "Written by Stephen 'Tag Loomis,". Could someone give me some help with Regular Expressions in PHP?

Thanks

graemef · 05-21-2006, 05:25 PM

From there I'd use strstr() to find the location of the substrings and then substr() to extract the data you want.

windisch · 05-22-2006, 09:34 AM

That was exactly what I needed, thanks!
Here is what I am up to now:

PHP Code:



<?php 
 
function getcontent($server, $port, $file) 
{ 
   $cont = ""; 
   $ip = gethostbyname($server); 
   $fp = fsockopen($ip, $port); 
   if (!$fp) 
   { 
       return "Unknown"; 
   } 
   else 
   { 
       $com = "GET $file HTTP/1.1\r\nAccept: */*\r\nAccept-Language: de-ch\r\nAccept-Encoding: gzip, deflate\r\nUser-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)\r\nHost: $server:$port\r\nConnection: Keep-Alive\r\n\r\n"; 
       fputs($fp, $com); 
       while (!feof($fp)) 
       { 
           $cont .= fread($fp, 500); 
       } 
       fclose($fp); 
       $cont = substr($cont, strpos($cont, "\r\n\r\n") + 4); 
       $cont = strip_tags($cont); 
 
function remover($string, $sep1, $sep2) 
{ 
       $string = substr($string, 0, strpos($string,$sep2)); 
#       $string = substr($string, strpos($string,$sep2), 0); 
       $string = substr(strstr($string, $sep1), 14); 
 
 
$username="mythtv"; 
$password="mythtv"; 
$database="mythconverg"; 
 
mysql_connect('localhost',$username,$password); 
@mysql_select_db($database) or die( "Unable to select database"); 
echo "($string)"; 
$query="SELECT * FROM `musicmetadata` WHERE `filename` LIKE '%$string%'"; 
$result=mysql_query($query); 
 
$num=mysql_numrows($result); 
 
mysql_close(); 
 
echo "<h1><b><center>Search Results</center></b></h1>"; 
echo "<h3><b>Found $num Matching Songs To Your Search.</b></h3>"; 
echo "<h3><b>Click On The Song Title To Request The Song To Be Played.</b></h3><br>"; 
$i=0; 
while ($i < $num) { 
 
$artist=mysql_result($result,$i,"artist"); 
$album=mysql_result($result,$i,"album"); 
$title=mysql_result($result,$i,"title"); 
$genre=mysql_result($result,$i,"genre"); 
$year=mysql_result($result,$i,"year"); 
$length=mysql_result($result,$i,"length"); 
$length2= floor ($length/60000); 
$length3= fmod ($length, 60000); 
$length2= floor ($length2); 
#$length3 = $length3 * 60; 
$intid=mysql_result($result,$i,"intid"); 
$filename=mysql_result($result,$i,"filename"); 
 
echo "<b>Artist: <P2>$artist</P2> Title: <P2><a target='Log' href='request.php?request_id=$intid'>$title</a></P2><br>Album: <P2>$album</P2></b> Year: <P2>$year</P2><br>Song # <P2>$intid</P2> Genre: <P2>$genre</P2><br> Length: <P2>$length ms or $length2:$length3.</P2><br>Filename: $filename<br><hr>"; 
 
$i++; 
} 
 
 
 
 
 
 
       return $string; 
} 
 
#$string = "Current Song: 10 Walk On The Ocean - Toad the Wet Sprocket Written By blah blah"; 
$string = $cont; 
$str1 = "Current Song: "; 
$str2 = "Written"; 
 
echo remover($string, $str1, $str2); 
 
$cont = " "; 
       return $cont; 
   } 
} 
echo getcontent("windisch.no-ip.org", "8083", "/"); 
?>

My only issue that I am having now is that I can't seem to get rid of a space at the end of the string I pull out of the data. I'm using the data to search though mySQL and pull down data. I've tried messing with the code, but can't get rid of that space on the end. Any idea on how to do that?

graemef · 05-22-2006, 09:55 AM

The trim() function can be used to strip whitespace from both ends of a string, there is also ltrim() and rtrim() to strip it from the start or end respectively.

windisch · 05-23-2006, 08:23 AM

Thanks graemef, you've been a huge help. I've got the basic frontpage going for what I wanted to do, a lot faster than I thought I could.

I have 1 side question. I am trying to convert milliseconds to minutes:seconds. And I am so close to getting it correct.

This is what I have:

PHP Code:



$length=mysql_result($result,$i,"length");
$length2= floor ($length/60000);
$length2= floor ($length2);
$length3= ($length - ($length2 * 60000));
$length3= ($length3 / 1000);
#       if (strlen($length3) == 1){
#               $length3 = "0$length3";
#                               }
$length3= floor ($length3);

I've got the minutes and seconds perfect, unless a song comes up that is, for example, 1:03. It shows up as 1:3 with what I have. All I need is to add a 0 to the front of the variable when it happens. You can see my pathetic attempt at doing that. Any clues for me?

graemef · 05-23-2006, 08:37 AM

Look at the sprintf() function:

You will want something like:

$time = sprintf("$d:%02d",$length2,$length3);

windisch · 05-23-2006, 11:41 AM

Thanks graemef! That worked perfectly. I think that takes care of this part of my project. If I have any other questions, I'll open a new thread. Thanks again!