Execute SQL functions with Laravel 5

Question

I have SQL functions stored on my database.

However, I can not call them.

$nb = DB::select('SELECT nb_seances_archivees()');

The result is :

array:1 [▼
   0 => {#186 ▼
      +"nb_seances_archivees": 0
   }
]

But the desired result is just 0.

Thank's for help !

YouneL · Accepted Answer · 2017-12-14 17:53:05Z

12

By default DB::select return an array of objects, you can use collections to get the first result:

 $nb = collect(DB::select('SELECT nb_seances_archivees() AS nb'))->first()->nb;

Or directly access the first object in the array:

 $nb = DB::select('SELECT nb_seances_archivees() AS nb')[0]->nb;

If you want to pass parameters then you should do:

 DB::select('SELECT nb_seances_archivees(?) AS nb', [$parameter]);

answered Dec 14, 2017 at 16:56

YouneL

8,3692 gold badges30 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

And what is DB::table('table') (because functions are not specific at a table)?

Just use: \DB::select(DB::raw('SELECT nb_seances_archivees()'));

With DB::select(DB::raw('SELECT nb_seances_archivees()')); I get the same result and not 0.

Sorry I Thought your query is not working, I updated my answer, take a look

Thank's a lot! What solution do you recommend?

|