The ability to customize the fetch mode was removed from L5.4 and is defaulted to PDO::FETCH_OBJ.
The upgrade guide states that you can override this by using an event listener:
Event::listen(StatementPrepared::class, function ($event) {
$event->statement->setFetchMode(...);
});
I can't for the life of me understand how to implement this:
1) Where should I place the code? Should I register it with the EventServiceProvider
?
2) When does the StatementPrepared
event fire? (I only need to change the Fetch Mode for specific repository functions, not on a global scale).
3) Does the FetchMode revert itself automatically for subsequent queries?
Here's an example of my code:
<?php
namespace App\Repositories\Backend;
use DB;
use PDO;
class SystemRepository
{
/**
* Get the connection status variables.
*
* @return array
*/
public function getConnectionStatus()
{
DB::connection('backend')->setFetchMode(PDO::FETCH_ASSOC);
$result = DB::connection('backend')
->select(DB::raw("
SHOW STATUS
WHERE Variable_name = 'Max_used_connections'
OR Variable_name = 'Max_used_connections_time'
OR Variable_name = 'Threads_connected'
"))
;
DB::connection('backend')->setFetchMode(PDO::FETCH_CLASS);
return $result;
}
}
Thank you!
Go to: app/Providers/EventServiceProvider.php
Add this to the top of the file:
use Illuminate\Database\Events\StatementPrepared;
In the boot method add:
Event::listen(StatementPrepared::class, function ($event) {
$event->statement->setFetchMode(\PDO::FETCH_ASSOC);
});
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With