/** * @param Statement $statement * @return null|int */ public function getCountForStatement(Statement $statement) { $countStmt = clone $statement; $sql = $statement->getSql(); if ($sql == '' || stripos(strtolower($sql), 'select') === false) { return; } $countSql = 'SELECT COUNT(*) as "count" FROM (' . $sql . ')'; $countStmt->prepare($countSql); $result = $countStmt->execute(); $countRow = $result->current(); return $countRow['count']; }