summaryrefslogtreecommitdiffstats
path: root/admin/index.php
diff options
context:
space:
mode:
Diffstat (limited to 'admin/index.php')
-rw-r--r--admin/index.php16
1 files changed, 10 insertions, 6 deletions
diff --git a/admin/index.php b/admin/index.php
index 1cddb8c..7e0b838 100644
--- a/admin/index.php
+++ b/admin/index.php
@@ -14,13 +14,17 @@ require '../core/application.php';
# TRY: PDOException
#===============================================================================
try {
- $LastPageStatement = $Database->query(sprintf('SELECT id FROM %s ORDER BY time_insert DESC LIMIT 1', Page\Attribute::TABLE));
- $LastPostStatement = $Database->query(sprintf('SELECT id FROM %s ORDER BY time_insert DESC LIMIT 1', Post\Attribute::TABLE));
- $LastUserStatement = $Database->query(sprintf('SELECT id FROM %s ORDER BY time_insert DESC LIMIT 1', User\Attribute::TABLE));
+ $execute = 'SELECT id FROM %s ORDER BY time_insert DESC LIMIT 1';
- $PageCountStatement = $Database->query(sprintf('SELECT COUNT(*) FROM %s', Page\Attribute::TABLE));
- $PostCountStatement = $Database->query(sprintf('SELECT COUNT(*) FROM %s', Post\Attribute::TABLE));
- $UserCountStatement = $Database->query(sprintf('SELECT COUNT(*) FROM %s', User\Attribute::TABLE));
+ $LastPageStatement = $Database->query(sprintf($execute, Page\Attribute::TABLE));
+ $LastPostStatement = $Database->query(sprintf($execute, Post\Attribute::TABLE));
+ $LastUserStatement = $Database->query(sprintf($execute, User\Attribute::TABLE));
+
+ $execute = 'SELECT COUNT(*) FROM %s';
+
+ $PageCountStatement = $Database->query(sprintf($execute, Page\Attribute::TABLE));
+ $PostCountStatement = $Database->query(sprintf($execute, Post\Attribute::TABLE));
+ $UserCountStatement = $Database->query(sprintf($execute, User\Attribute::TABLE));
}
#===============================================================================