How to upload multiple images into a database using laravel?

Question

I am trying to Upload multiple images into a database but only one is uploading instead of multiple.

How to upload multiple images into a database?

Could anyone tell me what is wrong with my code?

        [database table ][1]
        [1]: https://i.sstatic.net/kgv4r.png

controller

public function singalprojectaction(Request $request)
  {
   $input=$request->all();
   $images=array();
   if($files=$request->file('images')){
   foreach($files as $file){
   $name=$file->getClientOriginalName();
   $file->move(public_path('projects'), $name);
   $images[]=$name;
   }
   }
   $query=DB::table('single_portfolio')->insert( [
  'Project_name' =>$input['project_name'],
  'Client_Name' =>$input['Client_name'],
  'Completion_date' =>$input['Completion_date'],
  'Duration' =>$input['Duration'],
  'project_image_one'=>  implode("|",$images),
  'Description' =>$input['Description'],
   'project_id' =>$input['select_project'],
   ]);
  if($query)
   {
   return response()->json([
  'message'   => 'Image is Successfully Inserted',
  'class_name'  => 'alert-success'
  ]);
   }
  else{

 return response()->json([
'message'   => 'Data  is not inserted Inserted',
'class_name'  => 'alert-warning'
 ]);

  }
  }

html view

<form action="Route('singal.action') }}" id="singal_project" 
   enctype="multipart/form-data">
   {{ csrf_field() }}
   <div class="alert" id="message" style="display:block;"></div>
   <div class="group-form">
      <label>Drop Multple Imges</label>
      <input required type="file" class="form-control" name="images[]"
         multiple>
   </div>
</form>

yes you are saying right i am uploading multiple images but just first one image is uploading into database — Malik Zubair Mukhtar
– Malik Zubair Mukhtar, Commented Dec 24, 2019 at 8:55

VIKAS KATARIYA · Accepted Answer · 2019-12-24 09:23:47Z

2

Try This To insert multiple images

 public function singalprojectaction(Request $request)
  {
     $input=$request->all();
     $datas = [];
     $result = [];
     if ($request->hasfile('images')) {
        foreach ($request->file('images') as $key => $file) {
        $name = $file->getClientOriginalName();
        $file->move(public_path() . '/projects/', $name);
             $datas[$key] = $name;
        }
    }

        $query=DB::table('single_portfolio')->insert( [
                  'Project_name' =>$input['project_name'],
                  'Client_Name' =>$input['Client_name'],
                  'Completion_date' =>$input['Completion_date'],
                  'Duration' =>$input['Duration'],
                  'project_image_one'=>  implode("|",$datas);
                  'Description' =>$input['Description'],
                  'project_id' =>$input['select_project'],
                   ]);
        if($query){
          return response()->json(['message'   => 'Image is Successfully Inserted','class_name'  => 'alert-success']);
                   }
        else{
          return response()->json(['message'   => 'Data  is not inserted Inserted','class_name'  => 'alert-warning'
                 ]);
           }
        }

edited Dec 24, 2019 at 9:23

answered Dec 24, 2019 at 9:07

VIKAS KATARIYA

6,0153 gold badges19 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Malik Zubair Mukhtar Over a year ago

i have used this code but still first one image is uploading into database

Malik Zubair Mukhtar Over a year ago

Let us continue this discussion in chat.

tookoms · Accepted Answer · 2019-12-24 09:09:38Z

You will have to wrapped the insert code in the foreach statement: see below

foreach($files as $file){
                   $name=$file->getClientOriginalName();
                   $file->move(public_path('projects'), $name);


 $query=DB::table('single_portfolio')->insert( [
                      'Project_name' =>$input['project_name'],
                      'Client_Name' =>$input['Client_name'],
                      'Completion_date' =>$input['Completion_date'],
                      'Duration' =>$input['Duration'],
                      'project_image_one'=>  $name),
                      'Description' =>$input['Description'],
                       'project_id' =>$input['select_project'],
                       ]);

                   }

Collectives™ on Stack Overflow

How to upload multiple images into a database using laravel?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related