mediumtext is long enough, but you are putting binary data into it, not
text. You should be using mediumblob. The limit is 16M for that column
type.
-Rasmus
On Fri, 29 Mar 2002, Jay Paulson wrote:
> Hello--
>
> I can't quite seem to get this to work. What I'm trying to do is pull data
> out of a MySQL db of an image that I had put into the db. When I originally
> put the image into the db I had to use the "addslashes" function so that it
> would be inserted into the db correctly. Now when I select the data out of
> the db I do "stripslashes" on the file data. However, I still get a broken
> image in my test page. So I included the code I'm using below. the only
> ting that I can think of (it actually just popped into my head) is for a 50k
> file how big would the table have to be? I'm currently using the field type
> of mediumtext which should be enough.
>
> Thanks for any help!
> jay
>
> ===================================
> $query = "SELECT filename, filedata, dateline FROM reviews where id=$id";
> $results = dbQuery($query);
>
> $filedata = stripslashes($results["rowData"]["FILEDATA"][0]);
> $filename = $results["rowData"]["FILENAME"][0];
>
> if (strstr($HTTP_USER_AGENT,"MSIE")) {
> $attachment = '';
> } else {
> $attachment = ' atachment;';
> }
>
> header("Cache-control: max-age=31536000");
> header("Expires: " . gmdate("D, d M Y H:i:s",time()+31536000) . "GMT");
> header("Last-Modified: " . gmdate("D, d M Y
> H:i:s",$results["rowData"]["DATELINE"][0]) . "GMT");
> header("Content-disposition:$attachment filename=$filename");
> header("Content-Length: ".strlen($filedata));
> $extension=strtolower(substr(strrchr($filename,"."),1));
>
> if ($extension=="gif") {
> header("Content-type: image/gif");
> } elseif ($extension=="jpg" or $extension=="jpeg") {
> header("Content-type: image/pjpeg");
> } elseif ($extension=="png") {
> header("Content-type: image/png");
> } elseif ($extension=="pdf") {
> header("Content-type: application/pdf");
> } else {
> header("Content-type: unknown/unknown");
> }
> echo $filedata;
>
>
> --
> 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
