how to check if ADOdb recordset is empty

Question

I ran into the problem while checking emptiness of the ADODB5 recordset

$db = ADONewConnection($dbdriver);
$db->Connect($dbhost, $dbuser, $dbpass, $dbname);
$rs = $db->Execute($query);

now, if I try to check recordset

if(isset($rs[0]))
...
...

I get the error Cannot use object of type ADORecordSet_mysqli as array

How do you check whether returned recordset is or isn't empty?

Does https://stackoverflow.com/questions/2216052/how-to-check-whether-an-array-is-empty-using-php help? — Richard Chambers, Nov 08 '17 at 18:01
thank you for providing the answer you figured out. it helps other people with a similar problem. — Richard Chambers, Nov 08 '17 at 19:51

score 1 · Accepted Answer · answered Nov 08 '17 at 18:15

1

before isset evaluation I converted ADODB recordset to array

$ra = $rs->getRows();

then tested if $ra array is empty

if(empty($ra)){
...
...
}

answered Nov 08 '17 at 18:15

m1k3y3

2,762
8
39
68

Daniel Faure · Answer 2 · 2018-04-17T22:04:58.530

1

If the $db->Execute($query) method fails, it may not return a ADORecordSet object. I would not call the $rs->getRows() method before being sure $rs is valid, so,

if (is_subclass_of($rs, 'ADORecordSet') AND $rs->recordCount()) {
    // I have rows
    // ...
}

edited Apr 17 '18 at 22:04

answered Apr 17 '18 at 21:40

Daniel Faure

391
6
14

how to check if ADOdb recordset is empty

2 Answers2