I have the following migration:
(Schema::create('user_images',function(Blueprint $table){ $table->id(); $table->binary('image'); $table->unsignedBigInteger('user_id'); $table->foreign('user_id')->references('id')->on('users'); });)
And the following corresponding model:
`class UserImage extends Model { protected $fillable=[ ‘image’ ];
public function user():BelongsTo{
return $this->belongsTo(User::class);
}
}`
I am trying to create new UserImage records with UserImage::create but it is always failing, I am sending the image data using curl:
curl -v -F image=@$1 $URL/api/users -H "Accept: application/json"
I have tried so many things but I got different SQL-related errors, I am not sure how am I supposed to encode the image data to get them stored, I know that accessing $request->image returns only a temporary path of the image on the HDD.
Are you set on storing your image in the database?
If not I’d recommend the spatie media library:
https://spatie.be/docs/laravel-medialibrary/v11/introduction