A service for calling MySQL stored procedures with multiple data sets
rodion-arr/laravel-mysql-stored-procedures is a Laravel package for a service for calling mysql stored procedures with multiple data sets.
It currently has 2 GitHub stars and 173 downloads on Packagist (latest version v2.0.0).
Install it with composer require rodion-arr/laravel-mysql-stored-procedures.
Discover more Laravel packages by rodion-arr
or browse all Laravel packages to compare alternatives.
Last updated
Laravel's DB facade does not support calling stored procedures that returns multiple data sets in result out of the box. This package provides a simple service for calling and retrieving MySQL stored procedures by name and getting all its returned datasets back.
Based on @tommyready's PDOService class. Refactored, covered with unit tests and issued as Composer package from my side.
composer require rodion-arr/laravel-mysql-stored-procedures
require_once __DIR__.'/vendor/autoload.php'; // Autoload files using Composer
use RodionARR\PDOService;
use Illuminate\Support\Facades\App;
/**
@var PDOService $service
*/
$service = App::make(PDOService::class);
$multipleRowsets = $service->callStoredProcedure('store_procedure_name', ['param1', 'param2', '....']);
dd($multipleRowsets);
