Take a look at this url ...Originally Posted by timmy
http://orac.caffeine.co.nz/logo.php?channel=1001
Channel number change to 1002 ... 1003 ... 1004 etc ... you'll get the logos for each channel.
Here is the php code, pretty basic
Code:<? // Connect to orac (local host and select user only) $db = mysql_connect('localhost', ...user..., ...pass...); mysql_select_db('guideData', $db); // Query the database $out = mysql_query("SELECT logoS1 FROM channels WHERE channel_id='$channel'", $db); if (mysql_num_rows($out) > 0) { // Get the blob $row = mysql_fetch_array($out); $jpg = $row["logoS1"]; // Stream the file to the browser header("Content-type: image/jpeg"); echo $jpg; } mysql_close($db) ?>
Bookmarks