Stored Procedures in Laravel

How to use stored procedure in laravel

DB::select('exec my_stored_procedure("Param1", "param2",..)');
or

DB::select('exec my_stored_procedure(?,?,..)',array($Param1,$param2));
Try this for without parameters

DB::select('EXEC my_stored_procedure')

Source: stackoverflow.com

Stored Procedures in Laravel

DB::connection("sqlsrv")->statement('exec Pro_Internal_Transfer_Note_post @mvoucherid='.$VMID);

Source: stackoverflow.com

Similar codes

4 votes202 views3 answers
Laravel migration index
PHP Laravel
0 vote177 views1 answer
Check mobile or email in laravel
PHP
0 vote153 views1 answer
Wordpress featured image as a background image
PHP Wordpress
3 votes203 views2 answers
Laravel model exists id
PHP Laravel
0 vote206 views1 answer
Ajouter du contenu personnalisé sous chaque article/publication WordPress
PHP
0 vote168 views1 answer
In Connection.php line 664: could not find driver (SQL: select * from information_schema.tables where table_schema = news and table_name = migrations) In Connector.php line 67: could not find driver
PHP
2 votes155 views3 answers
Laravel many to many relationship with pivot table
PHP Laravel
1 vote161 views2 answers
Teaching php in interactive mode
PHP
3 votes130 views3 answers
Laravel pagination bootstrap 5
PHP
3 votes138 views2 answers
Set php var to html
PHP