Image return

nasty_psycho

Hello !

I have a small problem, how to make a php script return an image, given the path in the db

I want the script image.php?id=726

to return an image path stored in the db under the id 726.

I tried to look up the documentations but there for each type I should make other function and it's not working well.

Thanks in advance

barand

You need a function to return the image path given the id

function getImagePath ($id) {
   $sql = "SELECT imagepath FROM mytable WHERE id = $id";
   $res = mysql_query($sql);
   if ($row = mysql_fetch_row($res)) {
      return $row[0];
   else
      return "";
}

Then in your page,

echo "<img src=\"" . getImagePath($id) . "\">";

hth

onion2k

Originally posted by barand

function getImagePath ($id) {
   $sql = "SELECT imagepath FROM mytable WHERE id = $id";
   $res = mysql_query($sql);
   if ($row = mysql_fetch_row($res)) {
      return $row[0];
   else
      return "";
}

[/B]

You've missed a } in there.

nasty_psycho

no I ment how to make the thing this way working in the page

what is the image.php script ?

nasty_psycho

So I'll not give the user the image path on my server.
for security reasons, like I'll place it outside my server root

barand

Something like this, assuming jpg images

:: image.php ::

   $id = $_GET['id']
   $sql = "SELECT imagepath FROM mytable WHERE id = $id"; 
   $res = mysql_query($sql); 
   if ($row = mysql_fetch_row($res)) { 
      $ipath = $row[0];
   } else {
       $ipath = "default/image/path";
   }

  $im = imagecreatefromjpeg($ipath);
  header("content-type=image/jpg");
  imagejpeg($im);
  imagedestroy($im);

hth