How to rename file name in DB

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • aris1234
    New Member
    • May 2007
    • 9

    How to rename file name in DB

    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]
    Last edited by pbmods; Jun 14 '07, 02:14 PM. Reason: Changed code language. Thanks for using CODE tags!
Working...