PHP/Flash Problem
I'm not sure where the problem lies in this process, so I'll just explain and let you decide.
The server in question is running Red Hat Linux, Apache 2, MySQL 3.23.58, and PHP 4.2.2. Image data is being stored in a LONGBLOB field in a MySQL database table. I know, bad situation to be in, but it's the situation I'm in and I can't change it. The MIME type for the image is being stored in a separate VARCHAR field.
I'm using a PHP file to select an image record from the database table and output the MIME type in a Content-Type header, followed by the data. I've got the GD extension (1.6.2+) compiled into PHP and I'm trying to get PHP to use it so that any images that are not non-progressive JPEGs are converted prior to being outputted.
The problem I'm having is that progressive JPEGs (which I'm presuming are denoted by the MIME type image/pjpeg as opposed to image/jpeg) don't seem to be converted properly. Whenever a JPEG is saved in IE on a WinXP PC (the testing ground), it always appears to save it as a progressive JPEG regardless of the original type.
The purpose of this whole situation is to get an image which is not a non-progressive JPEG to be dynamically loaded into a Flash movie. Even with the PHP script using GD to do the image conversion on the fly, images whose original MIME type is image/pjpeg consistently don't appear while images whose original MIME type is image/jpeg show up just fine.
The server in question is running Red Hat Linux, Apache 2, MySQL 3.23.58, and PHP 4.2.2. Image data is being stored in a LONGBLOB field in a MySQL database table. I know, bad situation to be in, but it's the situation I'm in and I can't change it. The MIME type for the image is being stored in a separate VARCHAR field.
I'm using a PHP file to select an image record from the database table and output the MIME type in a Content-Type header, followed by the data. I've got the GD extension (1.6.2+) compiled into PHP and I'm trying to get PHP to use it so that any images that are not non-progressive JPEGs are converted prior to being outputted.
The problem I'm having is that progressive JPEGs (which I'm presuming are denoted by the MIME type image/pjpeg as opposed to image/jpeg) don't seem to be converted properly. Whenever a JPEG is saved in IE on a WinXP PC (the testing ground), it always appears to save it as a progressive JPEG regardless of the original type.
The purpose of this whole situation is to get an image which is not a non-progressive JPEG to be dynamically loaded into a Flash movie. Even with the PHP script using GD to do the image conversion on the fly, images whose original MIME type is image/pjpeg consistently don't appear while images whose original MIME type is image/jpeg show up just fine.