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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Re: upload a image file and save into the table

> 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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Re: upload a image file and save into the table

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/msg0114 0.php

Joe


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)