how to use count() in controller?

Question

How do I get the number of rows here? When I use $count = $flights->count(); I get this error Count all elements in an array, or something in an object

public function index(Request $request) { $airline = airline::all(); $search = $request->get('search'); if($search!=""){ $flights = DB::table('flights') ->join('airlines', 'flights.AirlineId', '=', 'airlines.id') ->select('flights.*', 'airlines.name', 'airlines.country','airlines.logo') ->where(DB::raw("CONCAT(flights.id,' ',flights.flightDesignator,' ',airlines.country,' ',airlines.name,' ',flights.departureFrom,' ',flights.arriveTo,' ',flights.departureTime,' ',flights.ArrivalTime)"),'LIKE','%'.$search.'%') ->paginate(4); $flights->appends(['search' => $search]); $count = $flights->count(); if($count == 0) return view('admin.flights')->with(['flights' => $flights,'airline' => $airline, 'NoFound' => 'There is no result 😔']); else return view('admin.flights')->with(['flights' => $flights,'airline' => $airline,'found' => ' records founded']); } }

@ZeroOne yes I just changed it with total() and it's working properly now thanks — oliver
– oliver, Commented Apr 20, 2022 at 6:54

ANAS MK · Accepted Answer · 2022-04-20 09:58:55Z

1

There is pagination is used so just change

$count = $flights->count(); to $count = $flights->total();

answered Apr 20, 2022 at 9:58

ANAS MK

1311 silver badge10 bronze badges

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

Comments

Hilmi · Accepted Answer · 2022-04-20 02:21:39Z

0

try to use collection

$data = collect($flights);

and then you can count it with

$data->count();

answered Apr 20, 2022 at 2:21

Hilmi

4457 silver badges19 bronze badges

1 Comment

oliver Over a year ago

did not work I get this error Object of class Illuminate\Support\Collection could not be converted to int

Collectives™ on Stack Overflow

how to use count() in controller?

2 Answers 2

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Related