Re: [PHP-DB] Storing JPEG's in MySQL -- Is it possible?
excuses, image/jpeg - Original Message - From: "PaulC" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, November 28, 2001 10:28 AM Subject: Re: [PHP-DB] Storing JPEG's in MySQL -- Is it possible? > I am using this to read the uploaded file > > $attach_data = > addslashes(fread(fopen($HTTP_POST_FILES['attachment']['tmp_name'], "r"), > filesize($HTTP_POST_FILES['attachment']['tmp_name']))); > > I'm then insterting that into the MySQL database, along with the > $attachment_type > > It works fine for a GIF, but a JPEG isn't displayed correctly. > > Thanks, > Paul > > > "Ck Raju" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Please show your script, so that we can answer you better. > > CK Raju > > > > On Tuesday 27 November 2001 16:37, PaulC wrote: > > > Hi, > > > > > > I've wrote a bit of code to upload a file, and store it in a MySQL > > > "longblob" field. > > > If I upload a GIF, and store it in MySQL I am able to retrieve it fine > > > using a PHP script. > > > > > > However, a JPEG uploads, but cannot be retrieved successfully. > > > (I get a broken image symbol in IE) > > > > > > Does anybody know why this is??? > > > > > > Thanks, > > > Paul > > > > -- > PHP Database 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] > > -- PHP Database 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]
Re: [PHP-DB] Storing JPEG's in MySQL -- Is it possible?
Try
header('Content-type: image/gif');
Regards,
Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS
- Original Message -
From: "PaulC" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 28, 2001 10:28 AM
Subject: Re: [PHP-DB] Storing JPEG's in MySQL -- Is it possible?
> I am using this to read the uploaded file
>
> $attach_data =
> addslashes(fread(fopen($HTTP_POST_FILES['attachment']['tmp_name'], "r"),
> filesize($HTTP_POST_FILES['attachment']['tmp_name'])));
>
> I'm then insterting that into the MySQL database, along with the
> $attachment_type
>
> It works fine for a GIF, but a JPEG isn't displayed correctly.
>
> Thanks,
> Paul
>
>
> "Ck Raju" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Please show your script, so that we can answer you better.
> > CK Raju
> >
> > On Tuesday 27 November 2001 16:37, PaulC wrote:
> > > Hi,
> > >
> > > I've wrote a bit of code to upload a file, and store it in a MySQL
> > > "longblob" field.
> > > If I upload a GIF, and store it in MySQL I am able to retrieve it fine
> > > using a PHP script.
> > >
> > > However, a JPEG uploads, but cannot be retrieved successfully.
> > > (I get a broken image symbol in IE)
> > >
> > > Does anybody know why this is???
> > >
> > > Thanks,
> > > Paul
>
>
>
> --
> PHP Database 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]
>
>
--
PHP Database 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]
Re: [PHP-DB] Storing JPEG's in MySQL -- Is it possible?
I am using this to read the uploaded file $attach_data = addslashes(fread(fopen($HTTP_POST_FILES['attachment']['tmp_name'], "r"), filesize($HTTP_POST_FILES['attachment']['tmp_name']))); I'm then insterting that into the MySQL database, along with the $attachment_type It works fine for a GIF, but a JPEG isn't displayed correctly. Thanks, Paul "Ck Raju" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Please show your script, so that we can answer you better. > CK Raju > > On Tuesday 27 November 2001 16:37, PaulC wrote: > > Hi, > > > > I've wrote a bit of code to upload a file, and store it in a MySQL > > "longblob" field. > > If I upload a GIF, and store it in MySQL I am able to retrieve it fine > > using a PHP script. > > > > However, a JPEG uploads, but cannot be retrieved successfully. > > (I get a broken image symbol in IE) > > > > Does anybody know why this is??? > > > > Thanks, > > Paul -- PHP Database 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]
Re: [PHP-DB] Storing JPEG's in MySQL -- Is it possible?
Please show your script, so that we can answer you better. CK Raju On Tuesday 27 November 2001 16:37, PaulC wrote: > Hi, > > I've wrote a bit of code to upload a file, and store it in a MySQL > "longblob" field. > If I upload a GIF, and store it in MySQL I am able to retrieve it fine > using a PHP script. > > However, a JPEG uploads, but cannot be retrieved successfully. > (I get a broken image symbol in IE) > > Does anybody know why this is??? > > Thanks, > Paul -- PHP Database 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]
