在mysql数据库laravel 9中上载多个表单

Question

有人能帮我找出错误吗？只有post_image输入被保存，其他的没有保存在数据库中，我做错了什么？我已经检查过几次了，但是只有post_image字段的文件名保存在数据库中，其他文件没有保存在数据库中，有人能帮我找出错误的地方吗？一切帮助都是受欢迎的。先谢谢你。

create.blade.php

div class="form-group row">
                    <label for="post_image" class="col-md-4 col-form-label text-md-right">{{ __('Image') }}</label>

                    <div class="col-md-6">
                        <input type="file" name="post_image"/>

                        @error('post_image')
                        <span class="invalid-feedback" role="alert">
                                        <strong>{{ $message }}</strong>
                                    </span>
                        @enderror
                    </div>
                    <br>
                    <hr>

                    <label for="post_video" class="col-md-4 col-form-label text-md-right">{{ __('Video') }}</label>
                    <div class="col-md-6">
                        <input type="file" name="post_video"/>

                        @error('post_video')
                        <span class="invalid-feedback" role="alert">
                                        <strong>{{ $message }}</strong>
                                    </span>
                        @enderror
                    </div>

                    <br>
                    <hr>

                    <label for="post_gif" class="col-md-4 col-form-label text-md-right">{{ __('GIF') }}</label>
                    <div class="col-md-6">
                        <input type="file" name="post_gif"/>

                        @error('post_gif')
                        <span class="invalid-feedback" role="alert">
                                        <strong>{{ $message }}</strong>
                                    </span>
                        @enderror
                    </div>

                    <br>
                    <hr>
                </div>

控制器中的函数存储->

public function store(Request $request, Community $community)
{
    $user = Auth::user();

    $creds = $request->validate([

        'post_image' => '|image|mimes:jpeg,jpg,png,svg|max:18048',
        'post_video' => 'mimes:mp4,ogx,oga,ogv,ogg,webm|max:180048',
        'post_gif' => '|image|mimes:gif|max:18048',


        'title' =>  ['required'],
        'post_text' =>  ['required'],
        'post_url' =>  ['required']


    ]);

    //IMAGE JPG,PNG,SVG
    if ($image = $request->file('post_image')) {
        $destinationPath = 'media/uploads';
        $profileImage = date('YmdHis') . "." . $image->getClientOriginalExtension();
        $image->move($destinationPath, $profileImage);
        $input['post_image'] = "$profileImage";
    }
    //END IMAGE JPG,PNG,SVG

    //VIDEO MP4

    if ($image = $request->file('post_video')) {
        $destinationPath = 'media/uploads';
        $profileImage = date('YmdHis') . "." . $image->getClientOriginalExtension();
        $image->move($destinationPath, $profileImage);
        $inputmp4 ['post_video'] = "$profileImage";
    }

    //END VIDEOS

    // GIF IMAGES

    if ($image = $request->file('post_gif')) {
        $destinationPath = 'media/uploads';
        $profileImage = date('YmdHis') . "." . $image->getClientOriginalExtension();
        $image->move($destinationPath, $profileImage);
        $inputgif ['post_gif'] = "$profileImage";
    }

    //END GIF IMAGES



    $post = $community->posts()->create
        (['user_id' => auth()->id(),
        'title' => $creds['title'],
        'post_text' => $creds['post_text'],
        'post_url' => $creds['post_url'],
        'post_image' => $input['post_image'] ?? '',
        'post_video' => $inputmp4['post_video'] ?? '',
        'post_gif' => $inputgif['post_gif'] ?? '',





    ]);

    return redirect()->route('communities.show', $community);

}

Answer 1

post_video和post_gif可能是空的吗？Php有一个在ini文件上定义的上传和最大post大小限制。有可能超出了这一规模。因此，您的文件实际上并没有上传。

还有，你的if语句有点混乱。看看这个：

    //This if statement will always return true. Since you're assigning $image variable to $request->file('post_video').
    if ($image = $request->file('post_video')) {
        //Code For saving file
        //Don't use this
    }

    // Instead you should use hasFile to check if the file is uploaded. here's how
    if ($request->hasFile('post_video')) {
        $video = $request->file('post_video');
        //Code For saving file
        //Use This instead
    }

另外，在最后一行，即调用create()方法时，执行以下操作：

    $post = $community->posts()->create
        (['user_id' => auth()->id(),
        'title' => $creds['title'],
        'post_text' => $creds['post_text'],
        'post_url' => $creds['post_url'],
        'post_image' => $input['post_image'], // skip the "?? ''" part
        'post_video' => $inputmp4['post_video'],
        'post_gif' => $inputgif['post_gif'],
    ]);

现在，如果post_image、post_video或post_gif都是空的，您将得到一个错误，并可以查看数据是否错误。

另外，您知道laravel有一个很好的助手可以在存储中保存文件吗？