Laravel-5 return eloquent object when running MySQL stored procedure

Question

I would like to know if it's possible to return a MySQL stored procedure call as an eloquent object.

The below call works fine for me, but $result always returns an array instead of the usual Eloquent object.

$result = DB::select('call bookings_by_voucher()');

Does anyone know how to return this as an object, so that I can use ->count(), ->get() etc.

I am wondering EXACTLY this. Unfortunately I have inherited a gigantic Piece of dung database that I cannot redo due to money / time constraints. Being able to do the above would simplify SO MUCH for me — Bill Garrison
– Bill Garrison, Commented Oct 13, 2015 at 16:24

Lance Pioch · Accepted Answer · 2015-10-14 20:17:54Z

1

You must pass the array into a new instance of your eloquent object.

$booking = new Booking($result);

answered Oct 14, 2015 at 20:17

Lance Pioch

1,1676 silver badges19 bronze badges

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

Comments

kenji · Accepted Answer · 2017-03-14 17:42:43Z

1

A late question, but if anyone else needs this:

Booking::fromQuery('call bookings_by_voucher()');

The only problem is you can't do further sql operations like where, limit, etc, since you can't manipulate a stored procedure directly, eg: you can't do "call bookings_by_voucher() where active = 1 limit 200". You can use laravel collection operations though.

https://laravel.com/docs/5.4/eloquent-collections

edited Mar 14, 2017 at 17:42

answered Mar 14, 2017 at 17:31

kenji

7938 silver badges15 bronze badges

Comments

Yasin Patel · Accepted Answer · 2016-05-09 17:35:35Z

0

you can use eloquent MODEL. It return an object .

ex.

$user = app\ModelName::all()->count();

get(),count() and other aggregate function works with Models

answered May 9, 2016 at 17:35

Yasin Patel

5,7818 gold badges37 silver badges57 bronze badges

Collectives™ on Stack Overflow

Laravel-5 return eloquent object when running MySQL stored procedure

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related