从没有PHP循环的数组中检查状态== 1或0

Question

For a WordPress plugin, I am using a simple $wpdb query like:

global $wpdb;
$table = $wpdb->wp_table_name = $wpdb->prefix . "wp_table_name";

$the_query = $wpdb->get_results(
    "SELECT *
        FROM $table;
    ");

It gives array like (using var_dump()):

array
  0 => 
    object(stdClass)[342]
       public 'id' => string '1' (length=1)
       public 'name' => string 'The Name' (length=8)
       public 'status' => string '1' (length=1)
  1 => 
    object(stdClass)[341]
       public 'id' => string '2' (length=1)
       public 'name' => string 'The Name 2' (length=10)
       public 'status' => string '0' (length=1)

On the view list I want to show a simple counter like:

Total: 2; Active: 1; Inactive: 1

For the total, I used a simple count():

<?php echo count($the_query); ?>

It's working fine. Now I want to show the other two numbers, but [if possible] WITHOUT ANY LOOP.

I guess using many loops can slow down the page. I searched many, they are suggesting in_array() or array_key_exists(). But they seems search for the index, they can't check whether it's == 1 or 0.

Answer 1

Agreeing with the other responses, loops aren't inherently bad. In this case, a loop is probably the simplest way to get what you're after.

There are ways to avoid the loop by using a more functional style, such as using array_reduce. eg.

$active = array_reduce($the_query, function ($result, $item) {
  if ($item->status === '1') {
    return $result + 1;
  }
  return $result;
});

var_dump($active);

Though, this is still going to perform a loop it's abstracted away into the underlying C implementation.

Whether this is a performance improvement or not, I'm not certain (I suspect not). You'd have to profile your code. It's mostly a stylistic choice.

Here is a codepad of the example working: http://codepad.viper-7.com/JFzUga