title: How to call mysql stored procedure in laravel 5.3 ORM illuminate with parameter
body: <p>I have created a stored procedure called <code>new_user</code> and tested it, works fine when I do a call in sequel pro and workbench. </p>
  
  <p>I am now trying to call the stored procedure using laravel 5.3. I did a test using laravel insert create function and it works fine, which tells me I have set up laravel ORM correctly. </p>
  
  <p>I then googled around looked on laravel site doc and saw a few stackoverflow solution and tried implement it, but none seem to work. Here is what I have tried so far </p>
  
  <p>The model php is pretty simple </p>
  
  <pre><code>&lt;?php
  
  namespace App\Models;
  
  use Illuminate\Database\Eloquent\Model as EloquentModel;
  
  class Model extends EloquentModel {
     protected $table = null;
  }
  </code></pre>
  
  <p>and in another class i used the following functions</p>
  
  <pre><code> $user = new \App\Models\Model;
  //this calls but nothing gets inserted into the database
   $user::select('call new_user("myemail@test.com","mypassword","myname","mysurname");');
  
  //same thing happens but nothing gets inserted into the database
       $user::select($user::raw('call new_user("myemail@test.com","mypassword","myname","mysurname");'));
  
   // this makes slim 3 throw BadMethodCallException
      $user::statement('call new_user("myemail@test.com","mypassword","myname","mysurname");');
  
  // this makes slim 3 throw BadMethodCallException
   $user::statement('call new_user(_email,_password,_name,_surname)values(?,?,?,?)',["myemail@test.com","mypassword","myname","mysurname"]);
  </code></pre>
  
  <p>Now am not sure how to call a stored procedure. I am just wondering what am i doing wrong. Thanks for your help</p>