upload new file but can't rename..???
Posted: Tue Jun 12, 2007 3:49 am
Hi...
I want update (remane) old file name in DB with new file name.
its my code only upload new file but can't update(rename) new file name :
please help..???

I want update (remane) old file name in DB with new file name.
its my code only upload new file but can't update(rename) new file name :
please help..???
Code: Select all
<?php
//Сheck that we have a file
$folder = "../property/$spid";
if(!file_exists($folder))
{
mkdir($folder);
}
$sql = "UPDATE `$table` SET str_image1='$simage1' WHERE int_prop_ID='$spid'";
}
if(mysql_query($sql, $conn) == false)
{
exit(mysql_error());
}
else
{
$property_id = mysql_insert_id();
}
// Process image
for($i = 0; $i < count($_FILES["file"]["name"]); $i++)
{
// Update row
$filename = $_FILES["file"]["name"][$i];
$sql = "UPDATE properties ".
"SET str_image". ($i + 1) ."= '$filename' ".
"WHERE int_prop_ID = $property_id ";
mysql_query($sql, $conn);
// Move file
$tmp_filename = $_FILES["file"]["tmp_name"][$i];
move_uploaded_file($tmp_filename, $folder ."/". $filename);
}
header( 'Location: view.php' );
?>