Use PDO::FETCH_ASSOC

[zavre-c]

USE PDO::FETCH_ASSOC

For Example we will use sqlsrv here

In AppServiceProvider -> boot() , we replicated config in database.php with name mssql and driver mssql

Use either of the both

• Using DB::extend()

DB::extend("mssql",function($config, $name) {
    $pdo = function() use ($config) {
        return (new SqlServerConnector)->connect($config);
    };
    return (new class($pdo,$config['database'],$config['prefix'],$config) extends SqlServerConnection {
        protected $fetchMode = PDO::FETCH_ASSOC;
    });
});

• Using DB::resolveFor() and Container Binding

$this->app->bind("db.connector.mssql",function() {
    return new SqlServerConnector;
});
DB::resolverFor("mssql",function() {
    return (new class(...func_get_args()) extends SqlServerConnection {
        protected $fetchMode = PDO::FETCH_ASSOC;
    });
});

Tried this but didn't work [DEPRECATED] #3512

$this->app['config']['database.fetch'] = PDO::FETCH_ASSOC;

[spudro228]

Laravel developers deliberately made the code not expandable
Weird thing