HEre is a question that I have been wondering about:
- Does the image file use more space in the db or as a file itself
(Do Not count the extra data that one would store in the db along with
the image... ie. ID number)
Thanks
On Thu, 30 Sep 2004 09:55:30 -0700, Jasper Howard <[EMAIL PROTECTED]> wrote:
> If you're uploading a file then you can make a script that reads the
> temp file into the database (otherwise you need to muck around with
> image functions and I'm not the one to ask about that), something
> like:
>
> $image = mysql_escape_string(fread(fopen($_FILES['file']['tmp_name'],
> "r"), filesize($_FILES['file']['tmp_name'])));
>
> Then you just put $image in the db under a BLOG field type. This is
> what I did when I needed to save some images to a db and it seemed to
> work fine. Make sure you save the file type to the database so you can
> display the image properly. When you are ready to display an image,
> just create the html for an image and set the source to a php script
> that will output the image:
>
> <img src="scripts/display_image.php?id=1">
>
> And in the display_image.php script do something like this:
>
> <?
> ...DB QUERY...
>
> $type = $row['file_type'];
> $dfile = $row['file_data'];
> header("Content-Type: $type");
> header("Content-Disposition: filename=".basename($dfile).";");
> header("Content-Length: ".filesize($dfile));
> readfile("$dfile");
> exit;
> ?>
>
> That code was modified a bit from its origional function (forcing
> download of the file) but I think it should just work, but there's
> always the chance I messed it up somehow.
>
> hope that works for someone,
> -Jasper Howard
>
>
>
>
> On Mon, 27 Sep 2004 19:05:16 -0500, Jim Grill <[EMAIL PROTECTED]> wrote:
> > > 1) there is no need to fiddle with directory permissions to write images.
> > > 2) if the content is sensitive you have the added security of the database
> > > password (and the fact that the database is ususally not directly
> > > accessible).
> > > 3) a mysqldump gives a backup of all images along with other persistent
> > data
> > >
> > > Other disadvantages follow:
> > > 1) excessive load on the server for loading each image
> > > 2) the load mentioned above causes a slow down in the script
> > > 3) images usually need to be written to file before using GD for
> > > manipulation, inclusion in PDFs, etc.
> > >
> > That's a very good list.
> >
> > I just wanted to pipe in on this one thing:
> >
> > "3) images usually need to be written to file before using GD for
> > manipulation, inclusion in PDFs, etc."
> >
> > There is actually a function for this: imagecreatefromstring()
> >
> > I'll don't want to touch the rest of this topic though. :-)
> >
> > Jim Grill
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> --
> <<--------------------------------------------------------
> Jasper Howard - Database Administration
> ApexEleven.com
> 530 559 0107
> ------------------------------------------------------->>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
