how to upload binary image to sql server using php laravel [duplicate]

You can save the image to a temp location then read it into a var with file_get_contents() then insert it into your database column (needs to be binary blob or something similar). To display it you can use a route like this:

Route::get('images/{id}', function($id)
{
    $image = Images::find($id);
    $image = Response::make($image->content, 200);
    $image->header('Content-Type', 'image/jpeg');
    return $image;
});

This assumes you are using Eloquent for dealing with your DB.

Tested this using help from here: https://laravel.io/forum/02-17-2014-how-do-you-save-image-to-database-and-display-it-on-website

My answer is bit messy, as Eloquent doesn't support Image BLOB to SQL Server, so the concept is we treat the image as param to SQLSrv driver based on PHP PDO load image into MS SQL Server 2012 , then we can upload it using bare PDO SQLSrv using BindParam.

example

Route::post("/example", function(Request $request) {
    /** @var \PDO $db */
    $db = DB::connection("sqlsrv")->getPdo();

    $stmt = $db->prepare("INSERT INTO gambar VALUES(:id, :gambar)");
    $stmt->bindValue("id", $request->input("angka"), PDO::PARAM_INT);
    $gambar = $request->file("gambar")->getContent();
    $stmt->bindParam("gambar", $gambar,
    PDO::PARAM_LOB, 0, PDO::SQLSRV_ENCODING_BINARY);
    // $stmt->bindValue("gambar", $request->file("gambar")->getContent(),
    // PDO::PARAM_LOB);
    dd($stmt->execute());

});

It's quite messy, as I can't use the built in Eloquent ORM, sad... noises...