It basically comes down to speed. While there is nothing "Technicaly" wrong
with storing the images in the database, accessing the images will become
slower as the database gets larger, than if the files were stored on the
filesystem. Whether or not this degredation of performance is acceptable or
not is up to you, but... if you still want to pull an image directly from
the database, try the following method. Please note that you must have the
image type stored in the database as well.
Create a seperate PHP script called getimg.php:
/* Begin getpic.php */
<?php
if($id) {
$dbhost = ""; /* MySQL Server */
$dbuser = ""; /* MySQL UserName */
$dbpass = ""; /* MySQL Password */
$dbname = ""; /* MySQL Database */
$db = mysql_connect("$dbhost", "$dbuser", "$dbpass");
mysql_select_db("$dbname",$db);
$query = "select image,type from images where id=$id";
$result = mysql_query($query);
$data = mysql_result($result,0,"image");
$type = mysql_result($result,0,"type");
Header( "Content-type: $type");
echo $data;
};
?>
/* End getpic.php
Now that you have this, when you want to display a picture, call getpic.php
in your <img> tag like so:
<IMG SRC=getpic.php?id=12> (obviously, this gets the picture with ID 12
from the database. )
There are probably more elegant ways of doing this, but it works. :)
----- Original Message -----
From: "Gonzalez, Zara E" <[EMAIL PROTECTED]>
To: "'Lerp'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 1:52 PM
Subject: RE: [PHP] Re: Image Fields and PHP...
> Joe (And/Or others),
>
> We are storing the actual images in the DB. We did not want our pictures
to be
> on our webserver. Instead we felt it would be better to keep them on the
> database server. In order to do this, they had to be stored in the
database
> itself since the database server is not accesible by the web. (I.e. the
only way
> to get stuff off of it via the web is to pull it out through the DB
connection)
>
> Now, You say that it is not recommended that we store our images in our
> database, can you give me a reasons why?
>
> Thanks,
>
> Zara
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
