Loading Images

jpeg

Can someone tell me how I can load images into a MYSQL table?

Thanks

rIkLuNd

<?php

$connect = mysql_connect($host,$user,$pass);
$select = mysql_select_db($db);

// path to the images dir
// no / in the end!!!
$iDir = 'images';

// open the dir
$open = opendir($iDir);

// loop through the dir
while($image = readdir($open))
{
  if(($image != '.') && ($image != '..'))
  {
    // save to the db
    $iAdd = mysql_query("insert into images(name,path) values('".$image."','".$iDir."')");
  }
}

?>

jpeg

Thanks, almost there. Just need to know what type do I use in SQL for the image? I tried a number of types, but it doesn't take?

driverdave

http://www.mysql.com

Check out BLOB

Why you would ever want to store images in a database, now that's the real question.

jpeg

I do a lot of photography and am building a stock photo web site. So far I am using SQL to keep data of all my photos that are on my hard drive and keeping a listing of their locations in the tables too. Here's a seqment of what I am doing:

$ResultsArr=mysql_fetch_array($Results);

<?
$ThumbFileName = $ResultsArr[Path].$ResultsArr[FileName].'.'.$ResultsArr[Type];

$EnlargeFileName = $ResultsArr[EnlargePath].$ResultsArr[FileName].'.'.$ResultsArr[Type];
?>
<a class="black" href="DP_Enlarge.php?EnlargeFileName=
<?echo $EnlargeFileName?>">
<img src="<?echo $ThumbFileName?>" border="0"><br>
<?echo $ResultsArr[WebPhotoFileName];
?></a>

Then I came up with the idea of putting the images right in the DB, making it simpler by eliminating the Path and Filename fields, but I guess by your question, that is not the standard way of doing it? Well, still on the learning curve. Would you suggest that I keep to my original method then?

Thanks