How to store image path in database - using laravel

Question

currently i can store file name is database and in public folder of laravel but i want to store file path in database?

My Controller:

$image=$userProfile['image'];
$image1 = base64_decode($image);
$filename = time().'.'.$extension;
Storage::disk('public')->put($filename,$image1);
$this->user->where('id', Auth::user()->id)->update(['profile_pic' => $filename]);

How i can store image path in laravel and image name in public folder? i am sending image in json using base64.

Your help will be highly appreciated?

You should put path with name like ['profile_pic' => $filePath.$filename] eventhough I don't recommend to store the path in the DB in case it changes later. If it changes you have to modify all records. — Andrei Lupuleasa
– Andrei Lupuleasa, Commented Apr 17, 2019 at 6:52

Andrei Lupuleasa · Accepted Answer · 2019-04-17 06:56:54Z

1

Use:

$image = $userProfile['image'];
$image1 = base64_decode($image);
$filename = time().'.'.$extension;
Storage::disk('public')->put($filename,$image1);    
$filePath = Storage::disk('public')->getAdapter()->getPathPrefix();
$this->user->where('id', Auth::user()->id)->update(['profile_pic' => $filePath.$filename]);

answered Apr 17, 2019 at 6:56

Andrei Lupuleasa

2,7623 gold badges18 silver badges36 bronze badges

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

1 Comment

Bernard Over a year ago

From where did you get the variable $extension ?

daffaquraisy · Accepted Answer · 2020-12-11 09:03:56Z

0

First type this command :

php artisan storage:link

it will create a symlink to public folder.

in your controller, you can write like this :

if ($request->file('image')) {
    $file = $request->file('image')->store('images', 'public');
    $new_product->image = $file;
 }

this code will insert a random string included the path, so you can have something like this on your image column value 'images/shgsqwerfsd.jpg'

answered Dec 11, 2020 at 9:03

daffaquraisy

2542 silver badges14 bronze badges

Collectives™ on Stack Overflow

How to store image path in database - using laravel

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related