How to get the number of orders for today?

Question

PHP

The bottom line is, I want to display the total number of orders for today (not for 24 hours) in the admin panel.
I try like this:

$day_orders = $db->query("SELECT COUNT(*) FROM 'oc_order' WHERE 'date_add' >= CURDATE() ");
$day_orders_count = count($day_orders);
echo $day_orders;

Tell me which way to dig? Suggest a bright idea, how to get a variable with the number of orders?
Don't kick too hard, I don't know php well, mysql with google :)

Answer 1

$day_orders = $db->query("SELECT COUNT(*) as cnt FROM 'oc_order' WHERE 'date_add' >= CURDATE() ");
echo $day_orders['cnt'];