Passing Array count to a variable

Question

I think I'm close with my code but I am trying to get the count() from the array provided... total users and OS

        $users = array();
        if ($results = $dbh->runQuery($sql)) {

foreach ($results as $key=>$row){
        $users[$row['user_id']][] = array('user_id'=>$row['user_id'],
        'email' => $row['email'],
        'last_login' => $row['last_login'],
        'fname' => $row['fname'],
        'lname' => $row['lname'], 
        'role_id' => $row['role_id'],
        'role_name' => $row['role_name'],
        'os_d_token' => $row['os'],
        'roid_d_token' => $row['roid'],
        'p_name' => $row['p_name']);
            }
        }

Get total count of users

    $user_cnt = count($row['user_id']);

Get total count of users with OS

    $total_os = '';
    if($row['os'] != null || '-1') {

        $total_os = count($row['os']);

    }

$row['os'] is not an array.. maybe use a COUNT in the SQL query? — user2864740
– user2864740, Commented Oct 8, 2018 at 16:09
If you are making unique user entries with $users[$row['user_id']][]... then you may be wanting count($users) to find the end result of unique users? — IncredibleHat
– IncredibleHat, Commented Oct 8, 2018 at 16:10
@acctman after you are done with the foreach, you can do that, and it should give you the count of users by unique user_id (as you have it). However getting count of unique OS would require a bit more like MattS's answer. — IncredibleHat
– IncredibleHat, Commented Oct 8, 2018 at 16:47

Matt S · Accepted Answer · 2018-10-08 16:11:51Z

2

count does not retain a counter for you. It immediately returns the number of items in an array. Since you're already looping, set counter variables:

$total = 0;
$total_os = 0;
foreach ($results as $key=>$row) {
    $total++;
    if ($row['os'] != null || $row['os'] != '-1') {
        $total_os++;
    }
    ...
}

answered Oct 8, 2018 at 16:11

Matt S

15.5k6 gold badges60 silver badges79 bronze badges

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

1 Comment

acctman Over a year ago

I would add the $total++; code within the current foreach statement that I have running correct?

Collectives™ on Stack Overflow

Passing Array count to a variable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related