Level 39
blob is a MySql/MariaDB storage type
base64 decode is a string type
You can insert directly insert a string type in a blob type
Apr 4, 2022
5
Level 4
convert base64 decode to blob
Any Option available in Laravel to convert base64decode to blob??
Level 4
@sr57 I did not understand can you explain.with an example?
Level 39
https://www.php.net/manual/en/function.base64-decode.php
https://laravel.com/docs/8.x/database#running-an-insert-statement
$str = 'VGhpcyBpcyBhbiBlbmNvZGVkIHN0cmluZw==';
$str_decode= base64_decode($str);
// This is an encoded string
DB::insert('insert into my_table (my_blob_field) values (?)', [$str_decode']);
Level 4
@sr57 Okay Thank you.Can I convert base64decode to image?
Level 39
Don't mix different questions in the same thread, it's difficult later with search engine for others. Close this one and open a new one.
Please or to participate in this conversation.