<?php
/**
* silpb_getimage.php
*
* retrieves image # $_REQUEST["img"]
* and displays it
*/


/***** CONFIG *****/
$GLOBALS["silpb"]["dbhost"] = "localhost";
$GLOBALS["silpb"]["dbuser"] = "silpb";
$GLOBALS["silpb"]["dbpass"] = "silpb";
$GLOBALS["silpb"]["dbname"] = "silpb";


/***** MAIN *****/

// check variables
if (empty($_REQUEST["img"]))
{
	exit(1);
} // end if no variables to check

// connect to server
$silpb_conn = mysql_connect($GLOBALS["silpb"]["dbhost"], $GLOBALS["silpb"]["dbuser"], $GLOBALS["silpb"]["dbpass"])
	or die("ERROR: Couldn't connect to database");
mysql_select_db($GLOBALS["silpb"]["dbname"], $silpb_conn) 
	or die("ERROR: Couldn't select database");

// get data
$img_query = "SELECT mimetype, image FROM silpb_image WHERE id = '{$_REQUEST['img']}'";
$img_res   = mysql_query($img_query, $silpb_conn) 
	or die("ERROR: $img_query\n".mysql_error($silpb_conn));
if (mysql_num_rows($img_res) > 0)
{
	$imgrow = mysql_fetch_array($img_res);
	header("Content-type: {$imgrow['mimetype']}");
	echo $imgrow['image'];
} // end if rows returned

?>