laravel-jquery,ajax-将可空数据作为数组插入数据库

lnvxswe2  于 2021-06-17  发布在  Mysql
关注(0)|答案(1)|浏览(264)

我正在尝试插入2个文件 image 以及 video 和additional image,这是一个数组,现在我可以插入两者,但当我尝试添加另一个图像作为数组并保存它时,输出也插入了窗体上选择的视频。如何将图像数组保存为独立的图像并删除自动插入的视频
这是我的用户界面,请看我的网页,我把它保存为图像和视频和添加图像再次

这是我的数据库输出
这里我想要的输出是绿灯和黄灯应该是单一的,没有视频插入到它的页面上,他们只是数组,没有连接到视频

这是我的控制器代码

$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 = $value;
        foreach ($paxSafetyVideo as $key => $values) {
        $paxSafetyContent->paxsafety_video = $values;
        }
        $paxSafetyContent->save();
    }

这是我的视图代码

{{ Form::file('paxsafety_image[]') }} &nbsp;&nbsp; <strong>  <span class="fa fa-camera"></span> Upload Image&nbsp;&nbsp; </strong>

 {{ Form::file('paxsafety_video[]') }} &nbsp;&nbsp; <strong>  <span class="fa fa-video-camera"></span> Upload Video&nbsp;&nbsp; </strong>

我的脚本代码

<script>  
        $(document).ready(function(){  
             var i=1;  
             $('#add').click(function(){  
                  i++;  
                  $('#dynamic_field').append('<tr id="row'+i+'"><th>Upload new Image</th><td>{{ Form::file('paxsafety_image[]') }} <button type="button" name="remove" id="'+i+'" class="btn btn-danger btn_remove fa fa-minus-circle"></button></td></tr>');  
             });  
             $(document).on('click', '.btn_remove', function(){  
                  var button_id = $(this).attr("id");   
                  $('#row'+button_id+'').remove();  
             });  
             $('#submit').click(function(){  
            var form = $('#add_name')[0];
            var formData = new FormData(form);

              $.ajax({   
                   method:"POST",  
                   data:formData,  
                   success:function(data)  
                   {  
                        alert(data);  
                        $('#add_name')[0].reset();  
                   }  
              });  
         });

        });  
 </script>

另外,这是我的表模式

$table->string('paxsafety_image')->nullable();
  $table->string('paxsafety_video')->nullable();
pu3pd22g

pu3pd22g1#

错误的部分在这里

foreach ($paxSafety as $key => $value) {
    $paxSafetyContent = new PaxSafety;
    $paxSafetyContent->paxsafety_image = $value;
  /***
   foreach ($paxSafetyVideo as $key => $values) {
    $paxSafetyContent->paxsafety_video = $values;
    }

**/

    $paxSafetyContent->save();
}

每次创建新的paxsafety时都会插入视频,如果确定只有一个视频附加在第一个图像上,则可以执行此操作

foreach ($paxSafety as $key => $value) {
    $paxSafetyContent = new PaxSafety;
    $paxSafetyContent->paxsafety_image = $value;
   /**if it's the first image && the first video exists insert the first video**/
   if($key == 0 && isset($paxSafetyVideo[$key]) && $paxSafetyVideo[$key]){
    $paxSafetyContent->paxsafety_video = $paxSafetyVideo[$key];
    }

    $paxSafetyContent->save();
}

或者你可以这样做,如果你想附加一个视频与多个图像在未来

foreach ($paxSafety as $key => $value) {
    $paxSafetyContent = new PaxSafety;
    $paxSafetyContent->paxsafety_image = $value;
   /**if a video with the current image index exists insert the video value**/
   if(isset($paxSafetyVideo[$key]) && $paxSafetyVideo[$key]){
    $paxSafetyContent->paxsafety_video = $paxSafetyVideo[$key];
    }

    $paxSafetyContent->save();
}

相关问题