diff options
| author | Andreas Fischer <bantu@phpbb.com> | 2012-02-18 19:29:32 +0100 |
|---|---|---|
| committer | Andreas Fischer <bantu@phpbb.com> | 2012-03-03 21:04:01 +0100 |
| commit | f9953fc3395e6b206c0789d40f89f9d2463348e7 (patch) | |
| tree | ab9160650d7178ce814f67a3b2245e4c8f62a918 /phpBB/includes/db/mysql.php | |
| parent | 97cf433dea658127ed60c70ea47d1c3830964f25 (diff) | |
| download | forums-f9953fc3395e6b206c0789d40f89f9d2463348e7.tar forums-f9953fc3395e6b206c0789d40f89f9d2463348e7.tar.gz forums-f9953fc3395e6b206c0789d40f89f9d2463348e7.tar.bz2 forums-f9953fc3395e6b206c0789d40f89f9d2463348e7.tar.xz forums-f9953fc3395e6b206c0789d40f89f9d2463348e7.zip | |
[ticket/10653] Add ability to count table rows to database abstraction layer.
PHPBB3-10653
Diffstat (limited to 'phpBB/includes/db/mysql.php')
| -rw-r--r-- | phpBB/includes/db/mysql.php | 70 |
1 files changed, 70 insertions, 0 deletions
diff --git a/phpBB/includes/db/mysql.php b/phpBB/includes/db/mysql.php index 1e24c79577..87413e808d 100644 --- a/phpBB/includes/db/mysql.php +++ b/phpBB/includes/db/mysql.php @@ -319,6 +319,76 @@ class dbal_mysql extends dbal } /** + * Gets the estimated number of rows in a specified table. + * + * @param string $table_name Table name + * + * @return string Number of rows in $table_name. + * Prefixed with ~ if estimated (otherwise exact). + * + * @access public + */ + function get_estimated_row_count($table_name) + { + $table_status = $this->get_table_status($table_name); + + if (isset($table_status['Engine'])) + { + if ($table_status['Engine'] === 'MyISAM') + { + return $table_status['Rows']; + } + else if ($table_status['Engine'] === 'InnoDB' && $table_status['Rows'] > 100000) + { + return '~' . $table_status['Rows']; + } + } + + return $this->get_row_count($table_name); + } + + /** + * Gets the exact number of rows in a specified table. + * + * @param string $table_name Table name + * + * @return string Exact number of rows in $table_name. + * + * @access public + */ + function get_row_count($table_name) + { + $table_status = $this->get_table_status($table_name); + + if (isset($table_status['Engine']) && $table_status['Engine'] === 'MyISAM') + { + return $table_status['Rows']; + } + + return parent::get_row_count($table_name); + } + + /** + * Gets some information about the specified table. + * + * @param string $table_name Table name + * + * @return array + * + * @access protected + */ + function get_table_status($table_name) + { + $sql = "SHOW TABLE STATUS + LIKE '" . $this->sql_escape($table_name) . "'"; + $result = $this->sql_query($sql); + $table_status = $this->sql_fetchrow($result); + $this->sql_freeresult($result); + + return $table_status; + } + + /** * Build LIKE expression * @access private */ |