Level 75
Cast to int if needed. But in php should just work as integer anyway unlike some languages.
Are you getting expected results.
2 likes
Jul 8, 2021
4
Level 4
get value from query as integer
How do i get the present_count value from the query below as an integer?
$attendance = Attendance::selectRaw('count(present) as present_count')
->whereMonth('date', $month)
->whereYear('date', $year)
->where('staff_id', $request->input('user_id'))
->get()->toArray();
Level 4
Yes i am getting my expected value, but i'd love to get my present_count as just integer outside the query.
right now my result is
array:1 [▼
0 => array:1 [▼
"present_count" => 2
]
]
i want it to be like this instead
2
Level 104
If you want $attendance as the integer result only:
$attendance = Attendance::whereMonth('date', (int) $month)
->whereYear('date', (int) $year)
->where('staff_id', $request->input('user_id'))
->count('present');
3 likes
Level 4
I've been getting 0 with this
[$year, $month]= explode('-', $day->date);// e.g. [2021, 7]
$check = IOU::whereMonth('date', '=',(int)$month)
->whereYear('date', (int)$year)
->where('staff_id', $request->input('staff_id'))
->sum('amount');
When i change it to
[$year, $month]= explode('-', $day->date);// e.g. [2021, 7]
$check = IOU::whereMonth('date', '=',(int)$month)
->whereYear('date', (int)$year)
->where('staff_id', $request->input('staff_id'))
->get('amount');
and i dd it i get []. and it's not throwing in any error
Please or to participate in this conversation.