How to transfer the value received from the database to a variable?

Question

PHP

Sending a query to the database

$items     = $wpdb->get_results( "SELECT count(*) FROM `avt_posts` WHERE `post_type` = 'shop_order'" );
var_dump($items);

get

array(1) { [0]=> object(stdClass)#21691 (1) { ["count(*)"]=> string(3) "145" } }

But I can't figure out how to transfer the value "145" to a variable. Tell me how to do it?

Answer 1

$items = $wpdb->get_results( "SELECT count(*) AS `count` FROM `avt_posts` WHERE `post_type` = 'shop_order'" ); // изменённый запрос
$item = reset($items);
$x = $item->count;

Answer 2

$var = $items[0]['count(*)'];

Answer 3

$count = $wpdb->get_var( "SELECT count(*) FROM `avt_posts` WHERE `post_type` = 'shop_order'" );
echo $count;