如何检查查询的数据是否不包含任何记录 - How to check if queried data does not contain any record

How to check if queried data does not contain any record

我有如下代码：

 $order = $this->getTableGateway('order');
        $select = new Select();
        if($txtFromOrderDate!="" && $txtToOrderDate=="")
        {
        $select->from('order')
            ->join('user', 'order.user_id = user.id', array('email'))
            ->where ("order.created between ".$txtFromOrderDate." and (
                        SELECT MAX(  `created` ) 
                        FROM  `order`
                        )"
                     );
        }
        else if($txtFromOrderDate=="" && $txtToOrderDate!="")
        {
         $select->from('order')
            ->join('user', 'order.user_id = user.id', array('email'))
            ->where ("order.created between  (
                        SELECT MIN(  `created` ) 
                        FROM  `order`
                        ) and ".$txtToOrderDate
                     );
        }

        else if($txtFromOrderDate!="" && $txtToOrderDate!="")
        {
        $select->from('order')
            ->join('user', 'order.user_id = user.id', array('email'))
            ->where ("order.created between ".$txtFromOrderDate." and ".$txtToOrderDate);
             //->where ('order.created between '.$txtFromOrderDate.'  and '.$txtToOrderDate);
        }
        else if($txtFromOrderDate=="" && $txtToOrderDate=="")
        {
        $select->from('order')
            ->join('user', 'order.user_id = user.id', array('email'));
        }   
        $data = $order->selectWith($select)->toArray();

正如我们所看到的，如果select语句正在更改，则取决于不同的条件。

最后我通过执行它

$data = $order->selectWith($select)->toArray();

我想检查查询是否返回了$data中的任何记录。

如何检查查询是否返回了0条记录？？？？

请帮帮我。

我使用MySQL服务器和Zend Framework进行PHP

$data将是array。如果没有记录，则

count($data)将返回0

使用sizeof（$data）或count（$data

if(!empty($data)) {
   //query has returned 1 or more results
}
else {
   //query has returned 0 result
}