cs1h Posted September 13, 2007 Share Posted September 13, 2007 Hi, I am trying to rename an uploaded file and then reference it to a database, so far I have managed to rename the file to the way I want it on the server but I am not able to put the new name onto the databse, only the old one goes up. My script is <?php // Generate a random number $newname = rand(); //This is the directory where images will be saved $target = "imgs/"; $target = $target . basename( $_FILES['photo']['name']); $target = str_replace(' ', $newname, $target); // <--- then add the random number in here to replace any spaces $target = str_replace('o', $newname, $target); $target = str_replace('a', $newname, $target); $target = str_replace('e', $newname, $target); //This gets all the other information from the form $name=$_POST['name']; $country=$_POST['menuFilesDMA']; $type=$_POST['Catagory']; $Email=$_POST['Email']; $Title=$_POST['title']; $Abstract=$_POST['message']; $Article=$_POST['messagetwo']; $pic=($_FILES['photo']['name']); // Connects to your Database mysql_connect("localhost", "adder", "clifford") or die(mysql_error()) ; mysql_select_db("real") or die(mysql_error()) ; //Writes the information to the database mysql_query($sql = "insert into `items` (`name`, `country`, `type`, `Email`, `Title`, `Abstract`, `Article`, `photo`) values ('$name', '$country', '$type', '$Email', '$Title', '$Abstract', '$Article', '$pic')"); //Writes the photo to the server if(move_uploaded_file($_FILES['photo']['tmp_name'], $target)) { //Tells you if its all ok echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory"; } else { //Gives and error if its not echo "Sorry, there was a problem uploading your file."; } ?> If any one can help it will be much appriciated. thanks Colin Quote Link to comment Share on other sites More sharing options...
phat_hip_prog Posted September 13, 2007 Share Posted September 13, 2007 In your sql statement there is no $target, which is the renamed filename, yes... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.