Hi every one, i try to upload form field into database along with the image but i want the the image name to be in my database as a link while the image itself will be in a directory. I have use something like this code before it works i think but the problem with this code is what i dont know.Is the problem from the directory where i want to store the image as was it keeps on returning the error below
-------Sorry, there was a problem uploading your file------
the code is ststed below
--------------------image.php------------------
<form enctype="multipart/form-data" action="addimage.php" method="POST">
Name: <input type="text" name="name"><br>
E-mail: <input type="text" name = "email"><br>
Phone: <input type="text" name = "phone"><br>
Photo: <input type="file" name="photo"><br>
<input type="submit" value="Add">
</form>
----------------addimage.php----------------------
<?php
//This is the directory where images will be saved
$target = "C:/Tomcat 6.0/webapps/fphp/image/";
$target = $target . basename( $_FILES['photo']['name']);
//This gets all the other information from the form
$name=$_POST['name'];
$email=$_POST['email'];
$phone=$_POST['phone'];
$pic=($_FILES['photo']['name']);
// Connects to your Database
mysql_connect("localhost", "root", "root") or die(mysql_error()) ;
mysql_select_db("student") or die(mysql_error()) ;
//Writes the information to the database
mysql_query("INSERT INTO `employees` VALUES ('$name', '$email', '$phone', '$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.";
}
?>
the table is as follow
CREATE TABLE employees (name VARCHAR(30), email VARCHAR(30), phone VARCHAR(30), photo text);
please i need your help so that the code will work .if you have similar code that does the same thing i will appreciate .thanks for your help and concern