How to save image path into database in Laravel?

Question

I want to upload an image and retrieve in from database when i need this.My code is perfectly working to upload image but it's path did not save in database.In database it's showing Null.Here is my code:

    if ($request->hasFile('profilePic')) {
        $file = array('profilePic' => Input::file('profilePic'));
        $destinationPath = 'img/'; // upload path
        $extension = Input::file('profilePic')->getClientOriginalExtension(); 
        $fileName = rand(11111,99999).'.'.$extension; // renaming image
        Input::file('profilePic')->move($destinationPath, $fileName);
    }else{
        echo "Please Upload Your Profile Image!";
    }
    $profile->save();

My Question:

How to save image path into database?
And how to retrieve image from database?

Updated: Profile.php

class Profile extends Model
{
    protected $table = "profiles";
    public $fillable = ["firstName","lastName","middleName","DOB","gender","featuredProfile","email","phone","summary","profilePic"];
}

Can you post your profile model file? Can't you just use something like $profile->image_location = $destinationPath . '/' . $filename; — Brett
– Brett, Commented Jun 2, 2016 at 5:24

Hasibur Rahman Omi · Accepted Answer · 2016-06-02 05:28:40Z

2

In your code there should be like this:

$profile->profilePic = $fileName;

& then

$profile->save();

answered Jun 2, 2016 at 5:28

Hasibur Rahman Omi

1095 bronze badges

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

Comments

MJH · Accepted Answer · 2017-01-02 07:35:03Z

1

1.How to save image path into database?

To save your full image path in a database field, the code is:

$profile->profilePic = $destinationPath.$fileName;
$profile->save();

2.And how to retrieve image from database?

In your view file using blade engine, write HTML code like this. In the image src you have to provide profilePic data as shown in the below HTML code:

<img src="{{asset($profile->profilePic)}}"/>

edited Jan 2, 2017 at 7:35

MJH

2,3037 gold badges20 silver badges20 bronze badges

answered Jan 2, 2017 at 6:46

Bhupendra Mistry

6284 silver badges12 bronze badges

Comments

Abdul Hameed · Accepted Answer · 2016-06-02 05:35:37Z

0

try this

$path = $file->getRealPath();;
    $pos = strpos($path,'/public/');
    if ($pos !== false) {
        $path = substr($path, $pos + 1);
    }
    $input['file'] = $path;

answered Jun 2, 2016 at 5:35

Abdul Hameed

2734 silver badges19 bronze badges

Collectives™ on Stack Overflow

How to save image path into database in Laravel?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related