Insert image and pdf into mysql - Laravel / PHP

Question

I want to insert image and pdf into mysql database with updateOrCreate()

I tried this but it returns 1 or 0 instead of actual file ..

$info = Info::updateOrCreate(
        ['user_id' => Auth::id()],

        [
         'image' => $request->hasFile('image') && $request->image->move(public_path('uploads'),$request->full_name.'.'.$request->image->getClientOriginalExtension()),
         'cv' => $request->hasFile('cv') && $request->cv->move(public_path('uploads'),$request->user_id.'.'.$request->cv->getClientOriginalExtension())
        ]
    );

Because you're checking for if-and-move-was-successful, which only returns true or false. Move your if-and-move lines out of the upadteOrCreate, and assign those variables properly. — aynber
– aynber, Commented Dec 2, 2021 at 18:49
I'am new these things .. May I ask how should it to be done ? — Fatih Can
– Fatih Can, Commented Dec 2, 2021 at 19:05

Gian Lorenzo Abaño · Accepted Answer · 2021-12-02 20:34:34Z

1

Based on your code, you are assigning the values of image and cv by the result of 'hasFile && move_uploaded_file' which returns true or false (0 or 1). what you should do is if has_file and move_uploaded_file returns true, return the file path location. if not, leave it blank.

$info = Info::updateOrCreate(
['user_id' => Auth::id()],

[
 'image' => $request->hasFile('image') && $request->image->move(public_path('uploads'),$request->full_name.'.'.$request->image->getClientOriginalExtension()) ? public_path('uploads').$request->full_name.'.'.$request->image->getClientOriginalExtension() : "",
 'cv' => $request->hasFile('cv') && $request->cv->move(public_path('uploads'),$request->user_id.'.'.$request->cv->getClientOriginalExtension()) ? public_path('uploads').$request->user_id.'.'.$request->cv->getClientOriginalExtension() : ""
]
);

the code above only returns the string of the file location where you uploaded the file (from move_uploaded_file). if you want to insert it directly to the database, you need a blob/binary column and insert the blob to the database using mysql stmt (prepared statement).

edited Dec 2, 2021 at 20:34

answered Dec 2, 2021 at 20:01

Gian Lorenzo Abaño

6727 silver badges21 bronze badges

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

2 Comments

Fatih Can Over a year ago

Thanks but Gives syntax errors like "unexpected , "

Gian Lorenzo Abaño Over a year ago

i edited the code. kindly try the updated code again.

Collectives™ on Stack Overflow

Insert image and pdf into mysql - Laravel / PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related