CODEWITHSUNDEEP
phpmysqlzend-framework
C Sharper
C Sharper

Reputation: 8626

How to check if queried data does not contain any record

I have code as follows:

 $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();

As we can see depending on different conditions in if select statement is changing.

at last I am executing it through:

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

i want to check if query has returned any record in $data or not.

How to check if query has returned 0 records????

Please help me.

I am using MySQL server and Zend Framework for PHP

Upvotes: 0

Views: 75

Answers (3)

Affan
Affan

Reputation: 1140

use sizeof($data) or count($data)

Upvotes: 3

Sanath Ballal
Sanath Ballal

Reputation: 1738

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

Upvotes: 2

Sougata Bose
Sougata Bose

Reputation: 31749

$data will be an array. if no records are present then

count($data) will return 0

Upvotes: 3

Related Questions