Laravel do not retrieve double value from database

Question

I have been trying to get price data from table 'rates' and store it in another table 'bookings'.

$duit =Booking::Join('rates', 'bookings.park_area','=', 'rates.areaid')
    ->where('bookings.user_id', '=', Auth::user()->userid)
    ->where('bookings.park_area','=',$bookings->park_area)
    ->where('bookings.semester','=',$bookings->semester)
    ->first(['rates.price']);  
$bookings->price=($duit);
    $bookings->save();

However, i get an error stating that the value retrieve is not of a double datatype: {"price":80}. So, I tried changing first(['rates.price']); to value('rates.price') but it stores as null.

So, why does {"price":80} become null and how to get the value of 80?

Try var_dump the $duit and check what it gives?

Kamal Paliwal
– Kamal Paliwal

2019-02-09 07:41:59 +00:00
Commented Feb 9, 2019 at 7:41 — Kamal Paliwal
– Kamal Paliwal, Commented Feb 9, 2019 at 7:41

Jignesh Joisar · Accepted Answer · 2019-02-09 07:45:33Z

2

you can used like that use select method here or directly get

get object value directly ->first()->price instead or this -->first(['rates.price']);

$duit = Booking::Join('rates', 'bookings.park_area','=', 'rates.areaid')
    ->where('bookings.user_id', '=', Auth::user()->userid)
    ->where('bookings.park_area','=',$bookings->park_area)
    ->where('bookings.semester','=',$bookings->semester)
    ->select('rates.price')
    ->first()->price;  

$bookings->price = $duit;
$bookings->save();

answered Feb 9, 2019 at 7:45

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

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

Collectives™ on Stack Overflow

Laravel do not retrieve double value from database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related