Trying to store pics in a database...

[Matt Shudy]

Hi,

I would like to have a page on my web that a user would be
able to submit pictues to be displayed on another page...
I am using FP 2002, and have a mysql db setup on the
server. I was wondering if there was a way to do this
using FP? I also know a fair amount of asp code. Would
the pictures need to be uploaded to the server first? If
so, is there a way to do that using asp code, or would i
have to get a program (like asp upload)?

Thanks,

Matt Shudy

 

[Thomas A. Rowe]

I would recommend that you using a ASP upload component, which one depends
on your host, as they may already support one, and if not may or may not be
willing to install one, however I would not recommend storing the actual
image within the database, instead have the image uploaded to a folder, then
in the database the store the filename and any additional info related to
the image and/or the user uploading it.

I use ASPUpload on a number of sites, along with ASPJpeg which allows you to
control the size of the image, etc.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

 

[Matt Shudy]

Thank you, I will contact my host.

Matt Shudy

-----Original Message-----
I would recommend that you using a ASP upload component, which one depends
on your host, as they may already support one, and if not may or may not be
willing to install one, however I would not recommend storing the actual
image within the database, instead have the image uploaded to a folder, then
in the database the store the filename and any additional info related to
the image and/or the user uploading it.

I use ASPUpload on a number of sites, along with ASPJpeg which allows you to
control the size of the image, etc.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp




.

 

[chris leeds]

it is possible to store pictures in a database using asp or php, and
probably some others. I have some sample code for this if you want it.
it's supposed to be improper to do this, from what I understand you're just
supposed to store a reference to the pictures location in the db and the
actual picture in a folder.
If you want the code I will give it to you.