Joe,
One approach that works for me is to have a separate IMAGE table with an automatically
generated
primary key image_id (auto_increment with MySQL). I don't use this store the image,
but just to
give me the unique name for the image file. I also use the IMAGE table to store away
the original
image name, and the image type and dimensions from GetImageSize. Type and dimensions
can be useful
to have stored in case you need to set IMG WIDTH and HEIGHT dynamically to maintain
proportions if
the image is over-sized for the page it's on and/or manipulate and image with gd
functions.
The IMAGE table is shared across the whole site to guarantee unique image names and
any updates of
images are always handled as inserts to stop problems with browsers caching old
images. image_id
is then held on the table where the use of the image is recorded e.g. the table
holding a page's
content. The actual directory where the images reside is not actually held in the
database but set
as a global in a standard include. This makes it easier to move between
machines/sites etc. without
changing data.
This seems to work well, you can use standard code for image upload/update/deletion
and functions
for image_insert,
image_delete etc.
Cheers,
George
Joe Van Meer wrote:
Thx Richard, I would like the files to all be dumped into one directory,
each with a unique name. Then I will create a path and store that in the db.
Thx for the ideas, I will check them out and get back to youvia this thread.
Cheers Joe:)
Richard Lynch [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Joe Van Meer wrote:
Hi there, I have an upload form on my website that works great, however
I
have come to a roadblock...how the heck do I rename the copied file?
Everytime I upload an image it overwrites the old one with the new. The
code below uploads the file and displays the following:
Your photo has been uploaded successfully.
Size of Image in Bytes: 36315
Image Type: image/pjpeg
File exists on server.
/rotatingimages/C:\PHP\uploadtemp\php12D.tmp -- I notice that this is
a
temporary name
If two files were being uploaded at once, you'd get two different names...
But it's entirely up to *YOU* to decide where to copy the file to. Maybe
you'd *WANT* to replace files as they were uploaded.
I tend to use the user's filename and preg_replace() to get rid of
everything except a-zA-Z._- and then checking where I'm copying to tack
on
1, 2, 3, ... until I find a new filename that's not in use.
You should also start using http://php.net/move_uploaded_file instead of
copy or whatever you are doing.
--
Like music? http://l-i-e.com/artists.htm
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]