Storage procedures in Laravel does not return more than one table

Question

Storage procedures in Laravel does not return more than one table

Navigation

#1 by (0 votes)

0

I have a procedure stored in mysql that returns 3 tables, but when invoking it with laravel it only shows me the contents of the first table.

route::get('/prueba/{id}','Emergencia\AsistenciaMedicaController@prueba');

 public  function  prueba($id) {
>        dd ($this->EmergenciaProcedure->prueba()) ;
>         //dd($datos);
>        //dd( DB::select('exec prueba '));
>     }
> 
>  public function prueba() {
>         return \DB::select('call prueba');
>     }

I leave the route, the function, the method to call the sp

image 1 is the sp in mysql, the second as the content in the browser is displayed

mysql php laravel-5 rutas

asked by bryan silva 12.06.2018 в 06:40

source

1 answer

Designer error Visual Studio 2005 Get an ulimo record of a list vb.net

score 0 · Answer 1

Try to launch the query with cursors so that eloquent does not parsee the answer

$db = DB::connection()->getPdo();

$sql = "EXEC prueba"; // Aqui poner los que quieras

$cursor = $db->prepare($sql);
$cursor->execute();

while $dato= $cursor->fetch()) {
    echo $dato . "<br>";
}