how to rename file name in DB..???
this my code, but this code only save image to folder, can't rename file in DB :
[CODE=php]
<?php
//Сheck that we have a file
$folder = "../property/$spid";
if(!file_exists ($folder))
{
mkdir($folder);
}
$sql = "UPDATE `$table` SET str_image1='$si mage1' WHERE int_prop_ID='$s pid'";
}
if(mysql_query( $sql, $conn) == false)
{
exit(mysql_erro r());
}
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($sq l, $conn);
// Move file
$tmp_filename = $_FILES["file"]["tmp_name"][$i];
move_uploaded_f ile($tmp_filena me, $folder ."/". $filename);
}
header( 'Location: view.php' );
?>
[/CODE]
this my code, but this code only save image to folder, can't rename file in DB :
[CODE=php]
<?php
//Сheck that we have a file
$folder = "../property/$spid";
if(!file_exists ($folder))
{
mkdir($folder);
}
$sql = "UPDATE `$table` SET str_image1='$si mage1' WHERE int_prop_ID='$s pid'";
}
if(mysql_query( $sql, $conn) == false)
{
exit(mysql_erro r());
}
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($sq l, $conn);
// Move file
$tmp_filename = $_FILES["file"]["tmp_name"][$i];
move_uploaded_f ile($tmp_filena me, $folder ."/". $filename);
}
header( 'Location: view.php' );
?>
[/CODE]