多个文件上传,如何包括更多的字段和添加完整的路径到数据库


Multiple file uploads, how to include more fields and add full path to database

我发现一些代码将文件上传到服务器上的文件夹,然后将路径保存到数据库表列。表单的代码:

 <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>

然后是将文件移动到上传文件夹的算法脚本然后将完整路径添加到数据库列

//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.";
}

现在,我需要将文件上传字段的数量增加到至少四个,然后分别将文件的完整路径写入数据库列。该脚本工作得很好,但只是不写完整的路径到数据库,所以我可以调用它以后,并在我的应用程序中显示。"任何人"能帮上忙吗?这简直让我头疼。

提前感谢你的好建议。

Stack Overflow rocks!

您需要支持html5的浏览器进行多次上传或使用不同的技术:java applet, flash, silverlight。jquery有一个插件用于多个上传:http://blueimp.github.io/jQuery-File-Upload/