Laravel 5.2 + upload file and save name in database

Question

In laravel 5.2, I could upload file using below code but could not find a way to store uploaded filename in database.

    $destinationPath = "test/";
    $file = $request->file('profile_pic');
    if($file->isValid()){
        $file->move($destinationPath, $file->getClientOriginalName());
        $user = User::findOrFail(Auth::user()->id);
        $input = $request->all();
        $input['profile_pic']->pathname = $destinationPath.$file->getClientOriginalName();
        $user->update($request->all());
    }

Does anyone know how to store filename in db?

$filename = $file->getClientOriginalName();This is how to get the name of file and this is how you merge it to inputs Input::merge(array('file_name' => $filename )); — Pardeep Poria
– Pardeep Poria, Commented May 9, 2016 at 6:58

lewis4u · Accepted Answer · 2020-08-21 07:20:44Z

7

Code for uploading files/images and writing real names into database

public function store(Request $request)
{
    $data = $request->all();

    if($file = $request->file('your_file')){

        $name = $file->getClientOriginalName();
        $file->move('folder_where_to_save', $name);
        $data['your_file'] = $name;

    }

    Model_name::create($data); // where $data can be $request->all() or you can manually assign the fields you need
}

edited Aug 21, 2020 at 7:20

answered May 10, 2016 at 9:51

lewis4u

15.3k22 gold badges116 silver badges161 bronze badges

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

Comments

Ali · Accepted Answer · 2016-05-09 06:59:24Z

2

You can try this, It wiil help you:

$destinationPath = "test/";
    $file = $request->file('profile_pic');
    if($file->isValid()){
        $file->move($destinationPath, $file->getClientOriginalName());
        $user = User::findOrFail(Auth::user()->id);
        $input = $request->all();
        $input['profile_pic']->pathname = $destinationPath.$file->getClientOriginalName();
        $user->update($request->all()); // Remove This

        // Add this lines

        $data['YOUR_DB_FIELD_NAME'] = $file->getClientOriginalName();
        $user->update($data);
    }

answered May 9, 2016 at 6:59

Ali

1,43810 silver badges17 bronze badges

Comments

ImBhavin95 · Accepted Answer · 2017-04-24 10:01:28Z

2

Check this full code

$destinationPath = 'uploads';
$extension = Input::file('prd_img')->getClientOriginalExtension(); 
$fileName = rand(11111,99999).'.'.$extension;
Input::file('prd_img')->move($destinationPath, $fileName);
$data = array(
    'prd_name' => $prd_name,
    'prd_cat' => $prd_cat,
    'prd_sub_cat' => $prd_sub_cat,
    'prd_img' => $fileName,
    'remember_token' => $remember_token,
    'created_at' => $time,
);
if(DB::table('products')->insert($data)){
    return redirect('add-product')->with('success', 'Product Succssfully Added.');
}else{
    return redirect('add-product')->with('error', 'Something wrong please try again.');
}

edited Apr 24, 2017 at 10:01

answered May 10, 2016 at 13:53

ImBhavin95

1,5232 gold badges18 silver badges29 bronze badges

Comments

Rukmi Patel · Accepted Answer · 2016-05-09 07:04:56Z

0

I got that. Silly Mistake!!

need to replace line from

$input['profile_pic']->pathname = $destinationPath.$file->getClientOriginalName();

to

$input['profile_pic'] = $destinationPath.$file->getClientOriginalName();

answered May 9, 2016 at 7:04

Rukmi Patel

2,5619 gold badges29 silver badges42 bronze badges

Collectives™ on Stack Overflow

Laravel 5.2 + upload file and save name in database

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related