What does PDO (MYSQL) return when there is an empty result set?

[guillermobytes]

Hi,

I was wondering what does PDO return when there are no records matching the query? i.e. i query for a column.name = 'John' and there is no 'John' in the table.


thanks for your answer.

guillermobytes

[Atli]

Hey.

It returns an "empty" PDOStatement object, in much the same way the classic mysql_query function returns an "empty" resource.

[guillermobytes]

thnaks Atli,

so how should i test that it is an emptyPDO statement?

$dbh = new PDO('connection info',...);
$sql = 'SELECT something FROM somewhere WHERE id = inexistent';
$ps = $dbh->query($sql);
if ($ps->rowCount() > 0) {
    $resultSet = $ps->fetchAll();
    print_r($resultSet);
} else {
    echo 'Empty result set';
}

[Markus]

PDOStatement::rowCount() does that for you.