Font face and size in PHP Script

Garcia6666

I'm running a script that grabs xml information from my radiostation and generates a table with the most popular tracks. Everything works fine, but I want the output to be displayed in Arial, size 2. Now it's something else. I know HTML code, but it doesn't seem to work to put in a font tag like that in an PHP script. How should I do?

TheDefender

You can code HTML into PHP code. Post what you have, and how you are trying to accomplish this, and we'll help you tweak it.

Garcia6666

OK, great. First there is this page (topten.php):

<?php
@ini_set('memory_limit', '16M');

$username = "XXX";
$password = "XXX";

$url = "http://www.live365.com/cgi-bin/api_track_stats.cgi?version=1&action=tracks&filter=current&member_name=$username&password=$password";

if (!function_exists("file_get_contents")) {
function file_get_contents($filename, $use_include_path = 0) {
$data = ""; // just to be safe. Dunno, if this is really needed
$file = @fopen($filename, "rb", $use_include_path);
if ($file) {
while (!feof($file)) $data .= fread($file, 1024);
fclose($file);
}
return $data;
}
}

if($data = @file_get_contents($url)) {
$p = xml_parser_create();
xml_parse_into_struct($p, $data, $vals, $index);
xml_parser_free($p);

for($i=0; $i<count($index["ARTIST"]); $i++) { 
    $tracks[$i]["rating"] = $vals[$index["POWER_RATING"][$i*3+2]]["value"]; 
    $tracks[$i]["artist"] = $vals[$index["ARTIST"][$i]]["value"]; 
    $tracks[$i]["title"] = $vals[$index["TITLE"][$i]]["value"]; 
    $tracks[$i]["album"] = $vals[$index["ALBUM"][$i]]["value"]; 
} 

$as_of = explode("-", $vals[$index["AS_OF"][0]]["value"]); 

unset($vals); 
unset($index); 

rsort($tracks); 

$fp2 = fopen("topten.inc", "w"); 
fwrite($fp2, "\n<? // " . $as_of[2] . $as_of[0] . $as_of[1] . " ?>\n"); 
fwrite($fp2, '<table>'); 
fwrite($fp2, "<tr><td colspan=\"5\" align=\"center\"><big>Top Ten Tracks As Of " . date("F d, Y", strtotime($as_of[2] . $as_of[0] . $as_of[1])) ."</big></td></tr>\n"); 
fwrite($fp2, "<tr><td>#</td><td>Artist</td><td>Title</td><td>Album</td></tr>\n"); 

for($i=0; $i<10; $i++) { 
    $j = $i + 1; 
    fwrite($fp2, "<tr>"); 
    fwrite($fp2, "<td>" . $j . "</td>"); 
    fwrite($fp2, "<td>" . $tracks[$i]['artist'] . "</td>"); 
    fwrite($fp2, "<td>" . $tracks[$i]['title'] . "</td>"); 
    fwrite($fp2, "<td>" . $tracks[$i]['album'] . "</td>"); 
    fwrite($fp2, "</tr>\n"); 
} 


fwrite($fp2, '<tr><td colspan="5">This list is generated daily from a ranking based on your votes in the Live365 playlist window.</td></tr>'); 
fwrite($fp2, "</table>\n"); 
fclose($fp2);

} else {
echo "Couldn't connect to Live365.";
}
?>

I run it once a day to update the statistics. It creates a file called topten.inc which in turn is included on another page (<?php include("topten.inc");?>) where the stats are presented.

The process works fine as I said, but I want to be able to control font, color etc. on the output page, and also line breaks.

Garcia6666

Btw, here is a pic of how the output looks if that will help.

http://forgottenjewels.sytes.net/toptenpic.jpg

TheDefender

OK, let's look at this line:

fwrite($fp2, "<td>" . $tracks[$i]['artist'] . "</td>");

Instead of a font tag, code styles into the tag.

fwrite($fp2, "<td style=\"font-family: arial; font-size: 2\">" . $tracks[$i]['artist'] . "</td>");

OR, instead of inlining your CSS, you can do a separate style block, or linked style sheet. W3C's site has good info on using CSS.

Garcia6666

I've gone through the script now, modified it and it works! Thanks a lot for helping me out.

Here you can look at it:

http://forgottenjewels.sytes.net

(Enter and chose Playlist in the menu and scroll down to bottom of page)

There is one minor thing left though. I would like to have the numbers presented in another format. Now it looks like...

1 - Black Sabbath (1980) - Children Of The Sea

I want it to look like:

001 - Black Sabbath (1980) - Children Of The Sea

How do I change this? This is the code:

<?php
@ini_set('memory_limit', '16M');

$username = "XXX";
$password = "XXX";

$url = "http://www.live365.com/cgi-bin/api_track_stats.cgi?version=1&action=tracks&filter=current&member_name=$username&password=$password";

if($data = @file_get_contents($url)) {
$p = xml_parser_create();
xml_parse_into_struct($p, $data, $vals, $index);
xml_parser_free($p);

for($i=0; $i<count($index["ARTIST"]); $i++) { 
    $tracks[$i]["rating"] = $vals[$index["POWER_RATING"][$i*3+2]]["value"]; 
    $tracks[$i]["artist"] = $vals[$index["ARTIST"][$i]]["value"]; 
    $tracks[$i]["title"] = $vals[$index["TITLE"][$i]]["value"]; 

} 

$as_of = explode("-", $vals[$index["AS_OF"][0]]["value"]); 

unset($vals); 
unset($index); 

rsort($tracks); 

$fp2 = fopen("O-topten.inc", "w"); 
fwrite($fp2, "\n<? // " . $as_of[2] . $as_of[0] . $as_of[1] . " ?>\n"); 

fwrite($fp2, "<big><strong><font color=#752020 size=2>Top Ten Tracks as of " . date ("F d, Y", strtotime($as_of[2] . $as_of[0] . $as_of[1])) .":<p></strong></big>\n"); 
fwrite($fp2, "\n"); 

for($i=0; $i<10; $i++) { 
    $j = $i + 1; 

    fwrite($fp2, "<font color=#666666 size=2><li>" . $j . " - "); 
    fwrite($fp2, "" . $tracks[$i]['artist'] . " - ");
    fwrite($fp2, "" . $tracks[$i]['title'] . "<br></li>");

    fwrite($fp2, "\n"); 
} 


fwrite($fp2, '<p><HR NOSHADE width="745" height="1" align=left color="#666666"><p><font color=#666666 size=1>* Statistics generated daily from ranking based on votes in the Live 365 playlist window'); 
fwrite($fp2, "\n"); 
fclose($fp2);

} else {
echo "Couldn't connect to Live365.";
}
?>

TheDefender

// Change this line:
fwrite($fp2, "<font color=#666666 size=2><li>" . $j . " - ");

// to this:
fwrite($fp2, "<font color=#666666 size=2><li>" . str_pad($j, 3, 0, STR_PAD_LEFT) . " - ");

This will pad all of the numbers on the left using 0s out to 3 digits. (giving you 001, 002, 003, 004, 005, 006, 007, 008, 009, 010)

Garcia6666

Magic! Thanks!

TheDefender

You're welcome. Be sure to mark this thread resolved using the "Mark Thread Resolved" link located at the bottom of the page. Have a good day!

Garcia6666

Same to you!