文件路径插入多行MySQL和Php(File path insert multiple rows MySQL and Php)

 我目前能够执行多个图像的上传，然后将文件路径插入数据库中的一行。 理想情况下，我需要找到一种方法来将这些文件路径作为具有自己ID的单独条目上载。 原因是我插入的图像路径被绑定到插入到单独表中的任务。 
 
function upload_file_new_task(){

global $db;

if(isset($_POST['create'])) {
    $path = "../uploads/";
    for ($i=0; $i<count($_FILES['files']['name']); $i++) {
        $ext = explode('.', basename( $_FILES['files']['name'][$i]));
        $path = $path . md5(uniqid()) . "." . $ext[count($ext)-1]; 
        move_uploaded_file($_FILES['files']['tmp_name'][$i], $path);
    }

    $sql = "INSERT INTO upload_data (`image`) VALUES ('$path');";
    $res = mysqli_query($db,$sql);
    echo "<p>Post Created $date</p>";
}

}
 
 因此将图像上载到/ uploads文件夹中，然后将该路径作为单行加载到数据库中， ID字段中具有id，并且路径被加载到image字段中。 

I am currently able to perform an upload of multiple images and then inserting the file paths into a row in the database. Ideally I need to find a way to upload these files paths as separate entries with their own ID. The reason why is because the image paths I am inserting are to be bound to a task which is inserted into a separate table.
 
function upload_file_new_task(){

global $db;

if(isset($_POST['create'])) {
    $path = "../uploads/";
    for ($i=0; $i<count($_FILES['files']['name']); $i++) {
        $ext = explode('.', basename( $_FILES['files']['name'][$i]));
        $path = $path . md5(uniqid()) . "." . $ext[count($ext)-1]; 
        move_uploaded_file($_FILES['files']['tmp_name'][$i], $path);
    }

    $sql = "INSERT INTO upload_data (`image`) VALUES ('$path');";
    $res = mysqli_query($db,$sql);
    echo "<p>Post Created $date</p>";
}

}
 
So theimage is uploaded into the /uploads folder, the path is then loaded into the database as a single row with an id in the ID field and the path(s) are loaded into the image field.

原文：https://stackoverflow.com/questions/36514507