PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE orders ( id int, status enum('new','complete') ); INSERT INTO orders (id, status) VALUES (1, 'complete'), (2, 'complete'), (3, 'new'), (4, 'new'), (5, 'new'), (6, 'complete'), (7, 'new'), (8, 'new');
Copy Clear
Copy Format Clear
<?php var_export( $db::table('orders') ->get() ->countBy('status') ->pipe( fn($coll) => $coll->put('count', $coll->sum()) ) ->toArray() );
Show:  
Copy Clear