LaravelSPMultiResponse is a powerful Laravel package designed to streamline the execution of SQL stored procedures with the capability to handle multiple response sets effortlessly. With this package, you can seamlessly integrate stored procedures into your Laravel application, simplifying database interactions and enhancing performance. Say goodbye to complex database queries and hello to efficient, organized, and scalable database operations with LaravelSPMultiResponse.
laravel-hrdk/laravel-s-p-multi-response is a Laravel package for laravelspmultiresponse is a powerful laravel package designed to streamline the execution of sql stored procedures with the capability to handle multiple response sets effortlessly. with this package, you can seamlessly integrate stored procedures into your laravel application, simplifying database interactions and enhancing performance. say goodbye to complex database queries and hello to efficient, organized, and scalable database operations with laravelspmultiresponse..
It currently has 0 GitHub stars and 1 downloads on Packagist.
Install it with composer require laravel-hrdk/laravel-s-p-multi-response.
Discover more Laravel packages by laravel-hrdk
or browse all Laravel packages to compare alternatives.
Last updated
LaravelSPMultiResponse is a powerful Laravel package designed to streamline the execution of SQL stored procedures with the capability to handle multiple response sets effortlessly. With this package, you can seamlessly integrate stored procedures into your Laravel application, simplifying database interactions and enhancing performance. Say goodbye to complex database queries and hello to efficient, organized, and scalable database operations with LaravelSPMultiResponse.
Use the composer to install laravel-s-p-multi-response.
composer required laravel-s-p-multi-response
After installation, you can use the package by importing the SPMultiResponse class and the Laravel App facade.
Create an instance of the SPMultiResponse class using App::make().
Call the desired stored procedure using the callStoredProcedure() method, providing the procedure name and an array of parameters.
Receive and work with the multiple response sets returned by the stored procedure.
Here's a sample code snippet:
use laravel_hrdk\LaravelSPMultiResponse\SPMultiResponse;
use Illuminate\Support\Facades\App;
// Create an instance of SPMultiResponse
$service = App::make(SPMultiResponse::class);
// Call the stored procedure and pass parameters
$multipleRowsets = $service->callStoredProcedure('store_procedure_name', ['param1', 'param2', '...']);
// Display the multiple response sets
dd($multipleRowsets);
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
Please make sure to update tests as appropriate.
