Обсуждение: upload a image file and save into the table

Hello:


I want to let users  upload a image file (jpg or gif or any binary file)
from browser and save these files into one column of a table, how can i
implement it ?

Thanks in advance.

Zhidian Du


_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

> I want to let users  upload a image file (jpg or gif or any binary file)
> from browser and save these files into one column of a table, how can i
> implement it ?

Use the 'bytea' column type.  You must properly escape the binary data
before inserting it tho. There are functions in PHP's postgres module to do
this.

Chris

Zhidian Du wrote:
> I want to let users  upload a image file (jpg or gif or any binary file)
> from browser and save these files into one column of a table, how can i
> implement it ?
>

Please search the archives. There have been multiple discussions about this in
the past. Here's a link to one thread:

http://archives.postgresql.org/pgsql-general/2002-02/msg01140.php

Joe