diff options
| author | canyonknight <canyonknight@gmail.com> | 2012-05-23 15:25:23 -0400 |
|---|---|---|
| committer | Lukas Fleischer <archlinux@cryptocrack.de> | 2012-07-06 11:26:54 +0200 |
| commit | 71f2efd7af4b32eb514c134769fc969e5e64bd2b (patch) | |
| tree | a7fd8afcfac1a79289d86d9dc27ea404d69c4e5a | |
| parent | c2b65f2b7bffeed46a2981f4eeb04e063c379ac0 (diff) | |
| download | aurweb-71f2efd7af4b32eb514c134769fc969e5e64bd2b.tar.xz | |
account_search_results.php: Pull out DB code
* Move DB code from account_search_results.php to already existing function
in acctfuncs.inc.php
* Centralization of DB code important in a future transition to PDO interface
Signed-off-by: canyonknight <canyonknight@gmail.com>
Signed-off-by: Lukas Fleischer <archlinux@cryptocrack.de>
| -rw-r--r-- | web/lib/acctfuncs.inc.php | 6 | ||||
| -rw-r--r-- | web/template/account_search_results.php | 3 |
2 files changed, 7 insertions, 2 deletions
diff --git a/web/lib/acctfuncs.inc.php b/web/lib/acctfuncs.inc.php index bb1f6e8..7a18f76 100644 --- a/web/lib/acctfuncs.inc.php +++ b/web/lib/acctfuncs.inc.php @@ -323,6 +323,12 @@ function search_results_page($UTYPE,$O=0,$SB="",$U="",$T="", $dbh = db_connect(); $result = db_query($q, $dbh); + $num_rows = mysql_num_rows($result); + + while ($row = mysql_fetch_assoc($result)) { + $userinfo[] = $row; + } + include("account_search_results.php"); return; } diff --git a/web/template/account_search_results.php b/web/template/account_search_results.php index 88d6bb6..f2ed62e 100644 --- a/web/template/account_search_results.php +++ b/web/template/account_search_results.php @@ -2,7 +2,6 @@ if (!$result): print __("No results matched your search criteria."); else: - $num_rows = mysql_num_rows($result); if ($num_rows): ?> <table class="results"> @@ -20,7 +19,7 @@ else: </thead> <?php $i = 0; - while ($row = mysql_fetch_assoc($result)): + while (list($indx, $row) = each($userinfo)): if ($i % 2): $c = "even"; else: |