PHP将4个图像上传到文件，并将其路径上传到数据库MYSQL

Question

这几天来，我一直对这个问题耿耿于怀，似乎在任何地方都找不到正确的答案。任何帮助都将不胜感激！

最终目标：让用户上传最多4张图片。检查错误。使用文件名上传图片到文件系统中的用户文件夹中（mkdir如果不存在），将文件路径存储在SQL表的相应部分。

我不断地改变事情以获得部分结果，现在我已经把自己编码成了一个大习惯。如果您有任何问题，请告诉我，甚至可以建议一个更好的方法来实现最终目标。

谢谢！！

SQL表：post\u id、user\u id、created、post\u title、short\u descripp、Long\u descripp、image1、image1\u cap、image2、image2\u cap、image3、image3\u cap、image4\u cap

<form method ='post' enctype='multipart/form-data' action='/posts/p_add'>
<h1><label for = 'content'>CREATE POST:</label><br></h1>
Post Title <input type='text' name='post_title'><br><br>
Short Description <input type='text' name='shortDescrip'><br><br>
Long Description<textarea name = 'longDescrip' id = 'longDescrip'></textarea>
<br><br>

<label for="image1">Image 1:</label>
<input type="file" name="image1" id="image1"><br>
Image Caption<input type='text' name='image1_cap'><br>

<label for="image2">Image 2:</label>
<input type="file" name="image2" id="image2"><br>
Image Caption<input type='text' name='image2_cap'><br>

<label for="image3">Image 3:</label>
<input type="file" name="image3" id="image3"><br>
Image Caption<input type='text' name='image3_cap'><br>

<label for="image4">Image 4:</label>
<input type="file" name="image4" id="image4"><br>
Image Caption<input type='text' name='image4_cap'><br>

<input type = 'Submit' value = 'POST'>
</form>

public function p_add(){
        # associate post with the user
        $_POST['user_id'] = $this->user->user_id;

        # unix timestamp for created & modified
        $_POST['created'] = Time::now();
        $filename = $_POST['filename'];

        # create file path for images
        $imgPath = '/uploads/images/'.$this->user->user_id.'/';
        if (!file_exists($imgPath)){
            mkdir($imgPath, 0777, true);
        }
        if ($_FILES["file"]["error"] == 0){
                for($x=1; $x<=4 ; $x++){
                    //print_r($_FILES);
                    # upload the user-chosen file and save to img file

                    $image = Upload::upload($_FILES, 'uploads/images/', 
                        array("jpg", "JPG", "jpeg", "JPEG", "gif", "GIF", "png", "PNG"), $filename);
                    print_r($image);
                    # notify of error 
                    if($image == 'Invalid file type.') {
                        echo "invalid file type";
                    }
                    else {
                        # add to DB                
                        $data = Array("image".$x => $image);
                        DB::instance(DB_NAME)->insert('posts', $data);

                        # resize the image and save again
                        /*$imgObj = new Image($_SERVER["DOCUMENT_ROOT"].'/uploads/images/'.$image);
                        $imgObj->resize(100,100,"crop");
                        $imgObj->save_image($_SERVER["DOCUMENT_ROOT"].'/uploads/images/'.$image);*/
                    }
                }
            }else{
                # if there is an error let it be known
                echo "there has been an error"; 
            }

        # insert into db
        DB::instance(DB_NAME)->insert('posts', $_POST);

        # feedback
        echo "Your post was added";
    }

从框架上传功能：

public static function upload($file_obj, $upload_dir, $allowed_files, $new_file_name = NULL) {      

    # Access first element in file_obj array (b/c we're dealing with single file uploads only)
    $key = key($file_obj);

    $original_file_name = $file_obj[$key]['name'];
    $temp_file          = $file_obj[$key]['tmp_name'];
    $upload_dir         = $upload_dir;

    # If new file name not given, use original file name
    if($new_file_name == NULL) $new_file_name = $original_file_name;

    $file_parts  = pathinfo($original_file_name);
    $target_file = getcwd().$upload_dir . $new_file_name . "." . $file_parts['extension'];

    # Validate the filetype
    if (in_array($file_parts['extension'], $allowed_files)) {

        # Save the file
            move_uploaded_file($temp_file,$target_file);
            return $new_file_name . "." . $file_parts['extension'];

    } else {
        return 'Invalid file type.';
    }

}

Answer 1

indexname中有一个错误：

 if ($_FILES["file"])...

您没有

 if ($_FILES["image1"]["error"] == 0)

在这种情况下重写代码。

更新：

非常有趣的上传功能...糟糕的解决方案。

试试这个：

$image = Upload::upload(array($_FILES['image'.$x]), 'uploads/images/',