Count model result

how can i count  rows of model result ? 
For example :

Code:

$usersModel = new UsersModel();
$users = $usersModel->findAll();
//count all users
?

Hi,

Code:

public function number_of_x_item($x_id){
$db      = \Config\Database::connect();
$builder = $db->table('your_db_table as dbt');
$query = $builder->select('*')
->where('dbt.item_id', $x_id);

return $query->countAllResults();
}

Hi,

Code:

public function number_of_x_item($x_id){
$db      = \Config\Database::connect();
$builder = $db->table('your_db_table as dbt');
$query = $builder->select('*')
->where('dbt.item_id', $x_id);

return $query->countAllResults();
}

with model is not possible ?

Yeah, it was for model. You can also check on Documentation page

how can i count  rows of model result ? 
For example :

Code:

$usersModel = new UsersModel();
$users = $usersModel->findAll();
//count all users
?

This should help:
lazy way to count user:  count($users);

Code:

 $count = $userModel->select('*')->countAllResults();

Yeah, it was for model. You can also check on Documentation page

This isn't for model ....

You can create a helper function to simplify things:

PHP Code:

if (!function_exists('numRows'))
{
  /**
    * Accepts database result object and returns number of rows found.
    *
    * @param obj $dbObject The returned database object from running query.
    *
    * @return int The row count.
    */
  function numRows($dbObject): int
  {
      return $dbObject->resultID->num_rows;
  }

} 


PHP Code:

count($users); 


ci-phpunit-test | CodeIgniter Testing Guide | CodeIgniter 3 to 4 Upgrade Helper

Hi,

Code:

public function number_of_x_item($x_id){
$db      = \Config\Database::connect();
$builder = $db->table('your_db_table as dbt');
$query = $builder->select('*')
->where('dbt.item_id', $x_id);

return $query->countAllResults();
}

Thank's, very good help.

[Image: https://i.ibb.co/9t33pTc/hexomecloud.jpg]