Advertisement
Guest User

Untitled

a guest
Sep 23rd, 2017
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.88 KB | None | 0 0
  1. function getMembers() {
  2. global $database, $pageNum;
  3.  
  4. $con = mysql_connect("$database[host]", "$database[user]", "$database[pass]")or die("COULD NOT CONNECT");
  5. mysql_select_db("$database[name]", $con);
  6.  
  7. $query = "SELECT * FROM users ORDER BY ID";
  8. $result = mysql_query($query);
  9.  
  10. while($row = mysql_fetch_array($result)) {
  11. $id = $row['id'];
  12. $username[$id] = $row['username'];
  13. $active[$id] = $row['active'];
  14. $admin[$id] = $row['admin'];
  15.  
  16. }
  17. mysql_close($con);
  18.  
  19. $num_of_users = $id;
  20. $pageNum = $id/10;
  21. $pageNum = floor($pageNum);
  22.  
  23. for($a=0; $a<=$pageNum; $a++) {
  24. if($a=="0") {
  25. if(empty($_GET['p']) || $_GET['p']=="1") {
  26. $b = 1;
  27. $c = 10;
  28. for($d=$b; $d<=$c; $d++) {
  29. listMembers($d,$username,$active,$admin);
  30. }
  31. }
  32. }
  33. elseif($a>="1" && $a<$pageNum) {
  34. $p = $a+1;
  35. if(isset($_GET['p'])) {
  36. if($_GET['p']==$p) {
  37. $b = $a*10+1;
  38. $c = $b+9;
  39. for($d=$b; $d<=$c; $d++) {
  40. listMembers($d,$username,$active,$admin);
  41. }
  42. }
  43. }
  44. }
  45. elseif($a==$pageNum) {
  46. $p = $a+1;
  47. if(isset($_GET['p'])) {
  48. if($_GET['p']==$p) {
  49. $b = $a*10+1;
  50. $c = $id;
  51. for($d=$b; $d<=$c; $d++) {
  52. listMembers($d,$username,$active,$admin);
  53. }
  54. }
  55. }
  56. }
  57. else {
  58. echo "Unable to List Members.";
  59. }
  60. }
  61. }
  62.  
  63. function listMembers($d,$username,$active,$admin) {
  64. echo "<tr>";
  65. echo "<td>" . $d . "</td>";
  66. echo "<td>" . $username[$d] . "</td>";
  67. echo "<td>" . $active[$d] . "</td>";
  68. echo "<td>" . $admin[$d] . "</td>";
  69. echo "<td><a href=\"admin.php?action=enable&user=" . $username[$d] . "\">Enable</a>";
  70. echo "<td><a href=\"admin.php?action=disable&user=" . $username[$d] . "\">Disable</a>";
  71. echo "</tr>";
  72. }
  73.  
  74. function listPages($pageNum) {
  75. $pageNum = $pageNum + 1;
  76. for($i=1; $i<=$pageNum; $i++) {
  77. echo "<a href=\"admin.php?page=members&p=$i\">$i</a>";
  78. }
  79. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement