SQL查询总是在Laravel结束时获得'1'雄辩

Question

I have this code :

$mydata = DB::table('attendances')->where('date_only','=',$newdate)
                                  ->orderBy('logon','asc')
                                  ->count();

Yes, I get the count number, But it's output is wrong. I always get this '1' digit at the result, For example, If I have 7 records the Result will be '71' if I have 8 then '81', 10 then '101'. And so on.

Answer 1

Probably you output somewhere else 1. You should try using it this way:

$mydata = DB::table('attendances')->where('date_only','=',$newdate)
                                  ->orderBy('logon','asc')
                                  ->count();
echo $mydata;
die();

And now check whether you get 1 at the end. Probably you won't so the problem is somewhere else