I am uploading files from a form and then writing a path to that file in a database but when I retrieve the information the picture doesn't load becuase of the spaces in the file name. Does any one know how I could edit the following php script so that when the file is uploaded it is given a unique id. When I attempted this in the path it would rename the file but not tell it what the file type was or put its link into the database.
Code: Select all
<?php
//This is the directory where images will be saved
$target = "images/";
$target = $target . basename( $_FILES['photo']['name']);
//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.";
}
?>Thanks
Colin