Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function getMembers() {
- global $database, $pageNum;
- $con = mysql_connect("$database[host]", "$database[user]", "$database[pass]")or die("COULD NOT CONNECT");
- mysql_select_db("$database[name]", $con);
- $query = "SELECT * FROM users ORDER BY ID";
- $result = mysql_query($query);
- while($row = mysql_fetch_array($result)) {
- $id = $row['id'];
- $username[$id] = $row['username'];
- $active[$id] = $row['active'];
- $admin[$id] = $row['admin'];
- }
- mysql_close($con);
- $num_of_users = $id;
- $pageNum = $id/10;
- $pageNum = floor($pageNum);
- for($a=0; $a<=$pageNum; $a++) {
- if($a=="0") {
- if(empty($_GET['p']) || $_GET['p']=="1") {
- $b = 1;
- $c = 10;
- for($d=$b; $d<=$c; $d++) {
- listMembers($d,$username,$active,$admin);
- }
- }
- }
- elseif($a>="1" && $a<$pageNum) {
- $p = $a+1;
- if(isset($_GET['p'])) {
- if($_GET['p']==$p) {
- $b = $a*10+1;
- $c = $b+9;
- for($d=$b; $d<=$c; $d++) {
- listMembers($d,$username,$active,$admin);
- }
- }
- }
- }
- elseif($a==$pageNum) {
- $p = $a+1;
- if(isset($_GET['p'])) {
- if($_GET['p']==$p) {
- $b = $a*10+1;
- $c = $id;
- for($d=$b; $d<=$c; $d++) {
- listMembers($d,$username,$active,$admin);
- }
- }
- }
- }
- else {
- echo "Unable to List Members.";
- }
- }
- }
- function listMembers($d,$username,$active,$admin) {
- echo "<tr>";
- echo "<td>" . $d . "</td>";
- echo "<td>" . $username[$d] . "</td>";
- echo "<td>" . $active[$d] . "</td>";
- echo "<td>" . $admin[$d] . "</td>";
- echo "<td><a href=\"admin.php?action=enable&user=" . $username[$d] . "\">Enable</a>";
- echo "<td><a href=\"admin.php?action=disable&user=" . $username[$d] . "\">Disable</a>";
- echo "</tr>";
- }
- function listPages($pageNum) {
- $pageNum = $pageNum + 1;
- for($i=1; $i<=$pageNum; $i++) {
- echo "<a href=\"admin.php?page=members&p=$i\">$i</a>";
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement