in reply to DBI file input to blob

amracel,

Begin with File Upload To Selected Directory. This should answer questions on writing the CGI to parse the form and place the data into a variable.

Then check this out MySQL: BLOB/TEXT. This should give you more understanding on MySQL blob(actually it is called TEXT).

And finally check out MySQL & DBI for standard connection code, and other mundane stuff.

And as a final word of caution IF the data that you are going to be putting into the TEXT/BLOB field is very large (like say 1 meg IMAGES!) your database will become HUGE, very very fast. In this case I would recomend simply writing the uploaded file to your webserver, and then placing a file pointer (non C++ reference! :-D )in a varchar filed (i.e. the link to the file such as "/home/httpd/htdocs/files/super_cool.txt") and then using the file pointer in your script.


HTH

-f o o g o d

--- ruining the bell curve for everyone else ---