dynamically naming images using file upload

atsphpflash

Hello,

I want users to be able to upload image files, and then be able ot access it from the db - No prob uploading files, but how would I store the name of that file in the users db?

Related. What happens if multiple users try to upload file with same name? Is there a way to dynamically name that file before it gets stored?

Thanks in advance....

cgraz

use the function file_exists() to see whether or not a file with that name already exists. To insert into database, just use

$query = mysql_query("INSERT INTO table (picture) VALUES('". $_POST["userfile"]["name"] . "'") or die(mysql_error());

Cgraz

atsphpflash

Thanks - easy enough.

What if I want to add a number of images via the same form, by giving each file input field a distinct name? How would I manage that?

cgraz

it would be the same thing, just w/more images.

$query = mysql_query("INSERT INTO table (picture1, picture2, picture3) VALUES('". $_POST["picture1"]["name"] . "', '". $_POST["picture2"]["name"] . "', '". $_POST["picture3"]["name"] . "'") or die(mysql_error());

Cgraz

atsphpflash

Cgraz

Thanks for your help...forgive my ignorance, but now I'm really confused. Below is what I'm using to process the file upload. This works, but how could it work with multiple files? I tried a series of else statements like 'if ($file1)...' 'if ($file2), etc., naming the input field appropriately, but that kept forcing errors. The use of $_POST in your code would completely change this setup, wouldn't it? IF you can help clarify, I'd appreciate it! Here's my code that works:

$path_to_upload_dir = "../../images/user";

if($file){

print("File name: $file_name<P>/n");
print("File size: $file_size bytes<P>/n");

if(copy($file, "$path_to_upload_dir/$file_name")){

$connect = mysql_connect ($hostname, $username, $password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "UPDATE images SET content_1='$file_name' WHERE id='1'";
mysql_query($query);

print("Your File was uploaded successfully - continue selecting images.");
}else{
print("ERROR, your file was not successfully uploaded");
}
unlink($file);
mysql_close($connect);
}
?>