How to upload images directly to MySQL database using laravel?

Question

I am new to Laravel 6 and have made a simple blog website, however i am very confused on to how i can add an image directly to the MySQL database. I don't accept user input on my site so i want to post the images directly to the database. Please guide me on how to achieve this. Thanks in advance!

Do you mean you want to put images as a blob column in MySQL? usually putting them on disk with only path in the database is a better practice. — Majed DH
– Majed DH, Commented May 5, 2020 at 9:45
As @Isigiel said in his answer. take a look at the file system in laravel. After you make a disk (or use one of the already exist by default) you can go there and put a file. then go to your database and put it's path in the column. It should be relative to the disk root indicated inside config/filesystems.php later on you can use Storage::disk('your disk name')->file($database_row->filepath) to get your file — Majed DH
– Majed DH, Commented May 5, 2020 at 10:23
The path of the file you've put on the disk :-) , how? since you don't accept user input just open your database editor, go to your table, and write the path! — Majed DH
– Majed DH, Commented May 5, 2020 at 11:02

Isigiel · Accepted Answer · 2020-05-04 19:03:03Z

1

While it is possible to store files directly in the database for example by converting them to base64 strings, that's definitely not good practice.
I suggest reading Laravel's docs on files https://laravel.com/docs/7.x/filesystem to see how you can use files stored on the file system for your project.

I am confused by your need for a database if you're not accepting any input, but that's probably another thing.

answered May 4, 2020 at 19:03

Isigiel

3172 silver badges12 bronze badges

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

1 Comment

User9701 Over a year ago

Thanks for the link, I heard that the laravel's file system is not a very efficient way of storing media files. is that correct? By the way i am creating an article posting website where only admins can write and publish articles and the viewers can only read them.

Collectives™ on Stack Overflow

How to upload images directly to MySQL database using laravel?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related