Retain the same file name as in my directory

gthri

Hi,
I have a upload page for uploading images.When doing this upload.php everything works fine but i would like to retain the same file name as it is in my directory(eg.test1.gif,test2.gif etc) instead of file 1 added.In the database it gets added as 1.gif,2.gif and so on.I dont want it to happen like this.
This is my structure of table

how can i change the code.can anyone help?
this is my code
<?php
include("config.inc.php");
//include("design.inc.php");
include("security.inc.php");

// initialization
$result_final = "";
$counter = 0;

// List of our known photo types
$known_photo_types = array(
'image/pjpeg' => 'jpg',
'image/jpeg' => 'jpg',
'image/gif' => 'gif',
'image/bmp' => 'bmp',
'image/x-png' => 'png');

// GD Function Suffix List
$gd_function_suffix = array(
'image/pjpeg' => 'JPEG',
'image/jpeg' => 'JPEG',
'image/gif' => 'GIF',
'image/bmp' => 'WBMP',
'image/x-png' => 'PNG');

// Fetch the photo array sent by preupload.php
$photos_uploaded = $FILES['photo_filename'];
$photoFileName= $FILES['photo_filename'];

// Fetch the photo caption array
$photo_caption = $_POST['photo_caption'];

while( $counter <= count($photos_uploaded) )
{
if($photos_uploaded['size'][$counter] > 0)
{
if(!array_key_exists($photos_uploaded['type'][$counter], $known_photo_types))
{
$result_final .= "File ".($counter+1)." is not a photo! ";
}else{

@( "INSERT INTO gallery_photos(photo_filename, photo_caption, photo_category) VALUES('0', '".addslashes($photo_caption[$counter])."', '".addslashes($_POST['category'])."')" );
$new_id = mysql_insert_id();
$filetype = $photos_uploaded['type'][$counter];
$extention = $known_photo_types[$filetype];
$filename = $new_id.".".$extention;

@( "UPDATE gallery_photos SET photo_filename='".addslashes($filename)."' WHERE photo_id='".addslashes($new_id)."'" );

// Store the orignal file
copy($photos_uploaded['tmp_name'][$counter], $images_dir."/".$filename);

// Let's get the original image size

$size = GetImageSize( $images_dir."/".$filename );

// First Create Thumbnail!
// Thumbnail Settings
$Config_tbwidth_wide = 150; // width of wide image
$Config_tbheight_wide = 125; // height of wide image

$Config_tbwidth_tall = 125; // width of tall image
$Config_tbheight_tall = 150; // height of tall image

// The Code
if($size[0] > $size[1]){
$thumbnail_width = $Config_tbwidth_wide;
$thumbnail_height = (int)($Config_tbwidth_wide * $size[1] / $size[0]);

if($thumbnail_height > $Config_tbheight_wide){
$thumbnail_height = $Config_tbheight_wide;
$thumbnail_width = (int)($Config_tbheight_wide $size[0] / $size[1]);
}
}else{
$thumbnail_width = (int)($Config_tbheight_tall $size[0] / $size[1]);
$thumbnail_height = $Config_tbheight_tall;

if($thumbnail_width > $Config_tbwidth_tall){
$thumbnail_width = $Config_tbwidth_tall;
$thumbnail_height = (int)($Config_tbwidth_tall * $size[1] / $size[0]);
}
}

// Build Thumbnail with GD 2.x.x, you can use the other described methods too
$function_suffix = $gd_function_suffix[$filetype];
$function_to_read = "ImageCreateFrom".$function_suffix;
$function_to_write = "Image".$function_suffix;

// Read the source file
$source_handle = $function_to_read ( $images_dir."/".$filename );

if($source_handle){
// Let's create a blank image for the thumbnail
$destination_handle = ImageCreateTrueColor ( $thumbnail_width, $thumbnail_height );

// Now we resize it
ImageCopyResampled( $destination_handle, $source_handle, 0, 0, 0, 0, $thumbnail_width, $thumbnail_height, $size[0], $size[1] );
}

// Let's save the thumbnail
$function_to_write( $destination_handle, $images_dir."/tb_".$filename, 100 );
ImageDestroy($destination_handle );

// .............................................................................. ...
// Lets resize the image if its width is greater than 500 pixels
// Resized image settings
if ($size[0] > '500'){
$Config_width_wide = 500; // width of wide image
$Config_height_wide = 475; // height of wide image

$Config_width_tall = 475; // width of tall image
$Config_height_tall = 500; // height of tall image

// The Code
if($size[0] > $size[1]){
$image_width = $Config_width_wide;
$image_height = (int)($Config_width_wide * $size[1] / $size[0]);

if($image_height > $Config_height_wide){
$image_height = $Config_height_wide;
$image_width = (int)($Config_height_wide $size[0] / $size[1]);
}
}else{
$image_width = (int)($Config_height_tall $size[0] / $size[1]);
$image_height = $Config_height_tall;

if($image_width > $Config_width_tall){
$image_width = $Config_width_tall;
$image_height = (int)($Config_width_tall * $size[1] / $size[0]);
}
}

// Build image with GD 2.x.x, you can use the other described methods too
$function_suffix = $gd_function_suffix[$filetype];
$function_to_read = "ImageCreateFrom".$function_suffix;
$function_to_write = "Image".$function_suffix;

// Read the source file
$source_handle = $function_to_read ( $images_dir."/".$filename );

if($source_handle){
// Let's create a blank image for the image
$destination_handle = ImageCreateTrueColor ( $image_width, $image_height );

// Now we resize it
ImageCopyResampled( $destination_handle, $source_handle, 0, 0, 0, 0, $image_width, $image_height, $size[0], $size[1] );
}

// Let's save the image
$function_to_write( $destination_handle, $images_dir."/".$filename, 90 );
ImageDestroy($destination_handle );

}

$result_final .= "<img src='".$images_dir. "/tb_".$filename."' /> File ".($counter+1)." Added Successfully! ";

}
}
$counter++;
}

// Print Result
echo <<<__HTML_END

<html>
<head>
<title>Photos uploaded</title>
</head>
<body>
$design_header 
$result_final 
<a href="adminindex.php">Back to Administration Page</a> 
<a href="logout.php">Logout of Administration Area</a> 
$design_footer
</body>
</html>

__HTML_END;
?>

liquorvicar

don't really understand your question.
you set the new uploaded filename yourself here:

$filename = $new_id.".".$extention;

can't you just change that?

ps try not to post so much code. not many people will read through all of that to help you. and make sure you use the board's PHP tags when you post code, like i did.

madmada

So, as I understand it, you want the file after it's been uploaded to the server to have the same name as it did on the client computer that uploaded it? If you check out this overview of file uploads with PHP here http://www.php.net/features.file-upload you'll see all the variables that get set in the $FILES array generated after the file is uploaded. The very first one listed is:

$_FILES['userfile']['name']
The original name of the file on the client machine.

So the first thing you have to do is change the line that says:

$filename = $new_id . "." . $extention;

to say:

$filename = basename($photos_uploaded['name']);

That will save the file on the server to the same name as the file that was uploaded from the client. All the basename function does is to ensure if the full path is passed from the client that it gets removed and you are only left with the straight file name and no path.

Secondly, you need to use this filename var when you're inserting the new row into the database.

Currently you're doing an insert, getting the auto_increment value with mysql_insert_id() and then naming the file based on this id. So, now we can do the whole thing with one query instead of an insert followed by an update. Replace everything from the first insert query down to and including the UPDATE query with the following:

$filename = basename($photos_uploaded['name']); // you need to do this line now BEFORE the sql query as you're going to use it in the INSERT query

@mysql_query( "INSERT INTO gallery_photos(`photo_filename`, `photo_caption`, `photo_category`) VALUES('$filename', '".addslashes($photo_caption[$counter])."', '".addslashes($_POST['category'])."')" ); 
$filetype = $photos_uploaded['type'][$counter]; 
$extention = $known_photo_types[$filetype];

Cheers,
Adam