Why the path of file image is not inserted into database MySQL in Laravel?

Question

I'm learning Laravel right now on Laravel From Scratch 2022 by Traversy Media (Youtube). I want to create a file upload function for new listing form. When I tried to upload, the image was uploaded into the right path in public storage but the path is not in the database, instead the value inserted is 0.

Here is the code for ListingController.php

// Store Listing Data
    public function store(Request $request) {
        $formFields = $request->validate([
            'title' => 'required',
            'company' => ['required', Rule::unique('listings','company')],
            'location' => 'required',
            'website' => 'required',
            'email' => ['required', 'email'],
            'tags' => 'required',
            'description' => 'required'
        ]);

        $directory = "logos";

        if($request->hasFile('logo')) {
            $formFields['logo'] = $request->file('logo')->store('logos','public');
        }

        Listing::create($formFields); 


        return redirect('/')->with('message', 'Listing created successfully!');   
    }

Here is the screenshot of image that I successfully uploaded but the value in database is 0.

Screenshot of Laravel storage/app/public/logos directory

Screenshot of MySQL database, column logo is used to store image path

Thank you for your help!

Welcome to Stack Overflow. If it's not storing the paths, are you certain that the $request has a file present in it? — ewokx
– ewokx, Commented May 26, 2022 at 2:15
Are you sure the data type of logo in your database is a string/varchar? — aceraven777
– aceraven777, Commented May 26, 2022 at 2:27
What is the value returned by $request->file('logo')->store('logos','public') ? — Augusto Moura
– Augusto Moura, Commented May 26, 2022 at 2:58
Thank you @ewong , I'm not sure about that, but it did uploaded into storage. — awis
– awis, Commented May 26, 2022 at 8:19
I'm sure it is 'string/varchar' because I already set it to 'string()' in database/migrations/ directory with 'nullable()' @aceraven777 — awis
– awis, Commented May 26, 2022 at 8:22

Francis · Accepted Answer · 2022-08-17 11:00:10Z

3

In my case since he used protected $fillable in Models. I added logo this resolved my issue. See the code below.

protected $fillable = ['title', 'logo','company', 'location', 'website', 'email', 'description', 'tags'];

answered Aug 17, 2022 at 11:00

Francis

311 bronze badge

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

Comments

Henry · Accepted Answer · 2022-08-02 06:03:19Z

2

What Eric commented worked for me as well, in the Models file under Http, you have to add whatever name that you used for the logo ('logo', 'image', 'picture' etc.), since in the course he uses protected $fillable.

answered Aug 2, 2022 at 6:03

Henry

194 bronze badges

Comments

xmrrabbitx · Accepted Answer · 2022-05-26 04:33:58Z

0

I tested it, and your code is fine. probably it might be related to the type of logo column in your database. make sure it's "Varchar" and not "Boolean".

you could use: var_dump($request->file('logo')->store('logos','public')); to see if the path of image showed up or not. if not, try use storeAs() instead of store() .

$request->file('logo')->storeAs('public' , "logo.jpg");

in this alternative code, you can set a proper name for your image as a second parameter and save it in the database.

answered May 26, 2022 at 4:33

xmrrabbitx

641 silver badge6 bronze badges

1 Comment

awis Over a year ago

I already checked the database and it is varchar and not boolean. It seems like var_dump() did not return any result but I use dd() and it return false. Is there any other reason why this could happen?

Augusto Moura · Accepted Answer · 2022-05-26 14:44:18Z

0

It seems $request->file('logo')->store('logos','public') doesn't return the file name or path. Considering that, it might be better to assign a custom file name. In the example below, we use the name of the original uploaded file.

$fileName = $request->file('logo')->getClientOriginalName();
$request->file('logo')->storeAs('logos', $fileName);
$formFields['logo'] = $fileName;

Source: https://blog.quickadminpanel.com/file-upload-in-laravel-the-ultimate-guide/

answered May 26, 2022 at 14:44

Augusto Moura

1,48711 silver badges21 bronze badges

Comments

Eric · Accepted Answer · 2022-07-24 01:03:35Z

0

Are you using "protected $fillable =..." in your model file? If so, you need to add 'logo' to the array.

(I'm doing the course and got stuck at the same part.)

edited Jul 24, 2022 at 1:03

answered Jul 24, 2022 at 1:02

Eric

34 bronze badges

Collectives™ on Stack Overflow

Why the path of file image is not inserted into database MySQL in Laravel?

5 Answers 5

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related