This may help you a bit , this is a long ago answer for executing stored procedures in laravel 4
based on this answer I've created a example to execute stored procedure on laravel 5
This includes a model, a view and and stored procedure call included in routes.php file using DB:: class in laravel.
Route routes.php
<?php
use App\Document;
use Illuminate\Support\Facades\Input;
Route::group(['middleware' => ['web']], function ()
{
Route::get('documents/send',function()
{
return view('documents/create');
});
Route::post('documents/add',function(\Illuminate\Http\Request $request)
{
if(isset($request['name']) && ($request['path']))
{
$doc_name = Input::get('name');
$doc_path = Input::get('path');
return DB::select('call sp_insert_document_details(?,?)',array($doc_name,$doc_path));
}
return redirect()->back();
});
});
The model Document.php
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
use DB;
class Document extends Model
{
protected $table = 'document_details';
protected $fillable = ['document_name','document_path'];
}
and lastly the view create.blade.php
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="csrf-token" content="{{ csrf_token() }}">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>Main template</title>
<link href="{{asset('css/bootstrap.css')}}" rel="stylesheet">
<link href="{{asset('css/lato.css')}}" rel="stylesheet">
<script src="{{asset('js/jquery.js')}}"></script>
<style>
body { font-family: 'Calibri'; }
</style>
<head/>
<body>
<div class="panel panel-primary">
<div class="panel-heading">Stored Procedures Panel</div>
<div class="panel-body">
@if (session()->has('success'))
<div class="alert alert-success" role="alert">{{ session('success') }} </div>
@endif
<form method="POST" action="add" class="form-horizontal panel">
{!! csrf_field() !!}
<div class="form-group ">
<label for="name" class="col-md-4 control-label">Document name:</label>
<div class="col-md-6">
<input class="form-control" name="name" type="text" id="name" value="">
</div>
<label for="name" class="col-md-4 control-label">Document path:</label>
<div class="col-md-6">
<input class="form-control" name="path" type="text" id="path" value="">
</div>
<div class="col-md-6 col-md-offset-4">
<button type="submit" class="btn btn-success">Send Data</button>
</div>
<div class="col-md-6 col-md-offset-4">
<input type="hidden" value="{{ Session::token()}}" name="_token">
</div>
</div>
</form>
</div>
</div>
</body>
</html>
The mysql db and table create commands (insert these lines in mysql console in windows or linux environment)
mysql>create schema nerds;
mysql>use nerds;
Database changed
mysql>CREATE TABLE document_details (
->id int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
->document_name VARCHAR(100) NOT NULL,
->document_path VARCHAR(100) NOT NULL);
The mysql stored procedure (insert these lines in mysql console in windows or linux environment)
mysql>DELIMITER//
mysql>CREATE PROCEDURE sp_insert_document_details
->(IN name VARCHAR(100), IN path VARCHAR(100) )
->BEGIN
->INSERT INTO document_details(document_name,document_path) VALUES(name,path);
->END//
mysql>DELIMITER;
This is worked well and has speed execution than mysql queries
below is the link for the whole example.
this is not met with active records , but hope this example will help you as a working example!
The performance of stored function vs standard mysql query
extracted from the book "MYSQL stored procedure programming"
Stored procedure is a generic program unit have the ability of execution on request that can accept multiple input and output parameters.
