diff options
| author | Phil Sturgeon <email@philsturgeon.co.uk> | 2012-05-20 13:34:46 +0200 |
|---|---|---|
| committer | Phil Sturgeon <email@philsturgeon.co.uk> | 2012-05-20 13:34:46 +0200 |
| commit | a3ce0ec96f98e1bcd1c5a0bc088d13f3178c01c6 (patch) | |
| tree | 9fa2ee9417387f5cf4bf0f108dcce25f69f0f8c2 /system/database/drivers/pdo/pdo_driver.php | |
| parent | fbd31c8d98bd7e5eac5c8e8c2f102b05350db93e (diff) | |
| parent | 27738491fc11d0b9ce5670b2f6a7957fc421ee4b (diff) | |
Merge pull request #1331 from rogeriopradoj/patch-1
Workaround for PDO Driver in 2.1-stable: num_rows doesn't work for SELECT queries
Diffstat (limited to 'system/database/drivers/pdo/pdo_driver.php')
| -rw-r--r-- | system/database/drivers/pdo/pdo_driver.php | 13 |
1 files changed, 11 insertions, 2 deletions
diff --git a/system/database/drivers/pdo/pdo_driver.php b/system/database/drivers/pdo/pdo_driver.php index c38b79c5a..952016848 100644 --- a/system/database/drivers/pdo/pdo_driver.php +++ b/system/database/drivers/pdo/pdo_driver.php @@ -189,11 +189,20 @@ class CI_DB_pdo_driver extends CI_DB { function _execute($sql) { $sql = $this->_prep_query($sql); - $result_id = $this->conn_id->query($sql); + $result_id = $this->conn_id->prepare($sql); + $result_id->execute(); if (is_object($result_id)) { - $this->affect_rows = $result_id->rowCount(); + if (is_numeric(stripos($sql, 'SELECT'))) + { + $this->affect_rows = count($result_id->fetchAll()); + $result_id->execute(); + } + else + { + $this->affect_rows = $result_id->rowCount(); + } } else { |