在Laravel中插入空字符串或空图像-Java 学习之路

我无法在数据库中插入字符串或空值，从而导致以下错误：

SQLSTATE [HY000]：常规错误：1364字段'paxsafety_video'没有默认值（SQL：插入pax_safeties（paxsafety_image，updated_at，created_at）值（Desert_1543390457.jpg，2018-11-28 15:34:17），2018-11-28 15:34:17））

Controller

$this->validate($request, [
        'paxsafety_image.*' => 'nullable|image|mimes:jpeg,jpg,png',
        'paxsafety_video.*' => 'nullable|mimes:mp4,mov,ogg | max:20000'
    ]);
    $paxSafety = [];
    $paxSafetyVideo = [];
    if ($request->has('paxsafety_image') && $request->has('paxsafety_video'))
    {   
        //Handle File Upload


        foreach ($request->file('paxsafety_image') as $key => $file)
        {
            // Get FileName
            $filenameWithExt = $file->getClientOriginalName();
            //Get just filename
            $filename = pathinfo( $filenameWithExt, PATHINFO_FILENAME);
            //Get just extension
            $extension = $file->getClientOriginalExtension();
            //Filename to Store
            $fileNameToStore = $filename.'_'.time().'.'.$extension;
            //Upload Image
            $path = $file->storeAs('public/paxsafety_folder',$fileNameToStore);
            array_push($paxSafety, $fileNameToStore);
        }



        foreach ($request->file('paxsafety_video') as $key => $file)
        {
            // Get FileName
            $filenameWithExt2 = $file->getClientOriginalName();
            //Get just filename
            $filename = pathinfo( $filenameWithExt2, PATHINFO_FILENAME);
            //Get just extension
            $extension2 = $file->getClientOriginalExtension();
            //Filename to Store
            $fileNameToStore2 = $filename.'_'.time().'.'.$extension2;
            //Upload Image
            $path = $file->storeAs('public/paxsafety_folder',$fileNameToStore2);
            array_push($paxSafetyVideo, $fileNameToStore2);
        }


        $fileNameToStore = serialize($paxSafety);
        $fileNameToStore2 = serialize($paxSafetyVideo);
    }
    else
    {
        $paxSafety[]='noimage.jpg';
        $paxSafetyVideo[]='noimage.jpg';
    }


        foreach ($paxSafety as $key => $value) {
        $paxSafetyContent = new PaxSafety;
        $paxSafetyContent->paxsafety_image =  !empty($value) ? $value : '';
        foreach ($paxSafetyVideo as $key => $values) {
        $paxSafetyContent->paxsafety_video = !empty($values) ? $values : '';
        }

        $paxSafetyContent->save();
    }

2 回答

更改架构PaxSafety设置默认为可空 .

$table->string('paxsafety_video')->nullable()->change();

否则改变控制器..

$paxSafetyContent = new PaxSafety;
$paxSafetyContent->paxsafety_image = !empty($values) ? $values : 'noimage.jpg';
$paxSafetyContent->paxsafety_video = NULL;
$paxSafetyContent->save();

一个或多个技巧是在 PaxSafety 模型中添加 $fillable 列

protected $fillable = ['paxsafety_image','paxsafety_video'];

现在在控制器中使用 create 模型方法

PaxSafety::create(['paxsafety_image' => !empty($values) ? $values : 'noimage.jpg']);

回复于 2024-04-19T02:33:26+08:00

试试这个 .

$paxSafetyContent = new PaxSafety;

$paxSafetyContent->paxsafety_image = !empty($paxSafety) ? $paxSafetyVideo : '';

$paxSafetyContent->paxsafety_video = !empty($paxSafetyVideo) ? $paxSafetyVideo : ''; 

$paxSafetyContent->save();

在PaxSafety中添加以下内容：

protected $casts = [
    'paxsafety_image' => 'array',
    'paxsafety_video' => ' array'
];

还要确保两者都在模型中的$ fillable ariae中 .

这样您就可以将图像和视频URL保存为数据库中的数组 .

希望这可以帮助 .

回复于 2024-04-19T02:33:26+08:00

在Laravel中插入空字符串或空图像

2 回答

相关问题