I found some code that uploads a file to a folder on my server and then saves the path to a database table column. the code for the form:
<form method="post" action="add_member.php" enctype="multipart/form-
data">
<p>Please Upload a Photo of the Member in gif or jpeg format. The file
name should be named after the Members name. If the same file name is
uploaded twice it will be overwritten! Maxium size of File is 35kb.
</p>
<p>
Photo:
</p>
<input type="hidden" name="size" value="350000">
<input type="file" name="cert_1">
<br/>
<br/>
<input TYPE="submit" name="upload" title="Add data to the
Database" value="Add Member"/>
</form>
And then the script with the algo that moves the file to the upload folder and then adds the full path to the database column
//This is the directory where images will be saved
$target = "upload";
$target = $target . basename( $_FILES['cert_1']['name']);
//This gets all the other information from the form
$pic=($_FILES['cert_1']['name']);
// Connects to your Database
mysql_connect("host", "db_user", "_db_pass") or
die(mysql_error()) ;
mysql_select_db("your_db") or die(mysql_error()) ;
//Writes the information to the database
mysql_query("INSERT INTO student_biodata_master
(cert_1)
VALUES ('$pic')") ;
//Writes the photo to the server
if(move_uploaded_file($_FILES['cert_1']['tmp_name'], $target))
{
//Tells you if its all ok
echo "The file ". basename( $_FILES['cert_1']['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.";
}
Now, I need to increase the number of file upload fields to four at the least and then write the full path of the files to the database columns respectively. The script works very well but only does not write the full path into the database so i can call it later and display in my application. Can "anygoodbody" help with this? its actually doing my head in.
Thanks in advance for the great advice always.
Stack Overflow rocks!
