Gecko [ midwest-tb.com ]

Name	Size	Permission
.pkexec	[ DIR ]	drwxr-xr-x
GCONV_PATH=.	[ DIR ]	drwxr-xr-x
assets	[ DIR ]	drwxr-xr-x
css	[ DIR ]	drwxr-xr-x
functions	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
includes	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
scss	[ DIR ]	drwxr-xr-x
vendor	[ DIR ]	drwxr-xr-x
.mad-root	0 B	-rw-r--r--
add_amount.php	1 KB	-rw-r--r--
add_code.php	3.24 KB	-rw-r--r--
add_user.php	15.1 KB	-rw-r--r--
admin_transactions.php	2.17 KB	-rw-r--r--
adminer.php	465.43 KB	-rw-r--r--
bulksms2.php	1.98 KB	-rw-r--r--
bulksms20.php	8.42 KB	-rw-r--r--
contact_students.php	1.76 KB	-rw-r--r--
db.php	30 B	-rw-r--r--
del_deposit.php	425 B	-rw-r--r--
delete.php	2.66 KB	-rw-r--r--
delete_banner.php	721 B	-rw-r--r--
delete_beneficiary.php	368 B	-rw-r--r--
delete_code.php	371 B	-rw-r--r--
delete_loan.php	355 B	-rw-r--r--
delete_user.php	991 B	-rw-r--r--
edit_banner.php	3.1 KB	-rw-r--r--
edit_transfer.php	3.18 KB	-rw-r--r--
edit_user.php	18.08 KB	-rw-r--r--
editsettings.php	2.54 KB	-rw-r--r--
error_log	160.39 KB	-rw-r--r--
function_users.php	6.17 KB	-rw-r--r--
functions.php	7.15 KB	-rw-r--r--
home.php	4.07 KB	-rw-r--r--
index -.html	41.78 KB	-rw-r--r--
index.php	56 B	-r--r--r--
insert_banners.php	2.84 KB	-rw-r--r--
login.php	1.57 KB	-rw-r--r--
login_admin.php	3.11 KB	-rw-r--r--
logout.php	164 B	-rw-r--r--
member.php	23.81 KB	-rw-r--r--
picupload.php	2.12 KB	-rw-r--r--
pwnkit	10.99 KB	-rwxr-xr-x
register_admin.php	8.45 KB	-rw-r--r--
remove_amount.php	1.01 KB	-rw-r--r--
searchmembers.php	2.94 KB	-rw-r--r--
send_email.php	6.9 KB	-rw-r--r--
testimony.php	3.15 KB	-rw-r--r--
transactions.php	2.66 KB	-rw-r--r--
upload_files.php	2.59 KB	-rw-r--r--
user_error.php	188 B	-rw-r--r--
user_transfer.php	6.3 KB	-rw-r--r--
user_withdrawal.php	4.85 KB	-rw-r--r--
view_admin.php	2.84 KB	-rw-r--r--
view_banners.php	2.23 KB	-rw-r--r--
view_beneficiary.php	3.74 KB	-rw-r--r--
view_cards.php	3.03 KB	-rw-r--r--
view_codes.php	3.07 KB	-rw-r--r--
view_loans.php	2.8 KB	-rw-r--r--
view_referrals.php	1.67 KB	-rw-r--r--
view_users.php	4.37 KB	-rw-r--r--
viewconversation.php	5.25 KB	-rw-r--r--
viewmessage.php	2.4 KB	-rw-r--r--
viewmessages.php	3.15 KB	-rw-r--r--

Code Editor : view_users.php

<?php include("includes/header.php");
include("includes/navbar.php");

if(isset($_GET['delete'])){
$id= $_GET['id'];

$sql = "SELECT username FROM users WHERE id='$id'";
$run= mysqli_query($con, $sql);
$count = mysqli_num_rows($run);
while($row= mysqli_fetch_array($run)){
  $show = $username = $row ['username'];
echo$sql1 = "DELETE FROM users WHERE username='$show'";
}

}
?>

<head>
<title>USERS </title>
<head>
<div class="card shadow mb-4">
                
                <div class="card-header py-3 d-flex flex-row align-items-center justify-content-between">
                  <h3 class="m-0 font-weight-bold text-primary">View Users</h3>
                  
                </div>
  
<?php

if(isset($_GET['deleted'])){
echo "<br/><b style='color:red'>User was deleted succesfully</b><br/>";
	}
?>

<thead>
<tr>
<th>Name</th>
<th>Acct No.</th>
<th>Acct Type</th>
<th>Email</th>
<th>Balance</th>
<th>Gender</th>
<th>Option</th>

</tr>
</thead>
<tbody>

<?php

$offset= 0;
$page_result= 50;
				
				if(isset($_GET['pageno'])){

$page_value = $_GET['pageno'];

if($page_value > 1){
						$offset= ($page_value - 1) * $page_result;
					}
				}

$sql = "SELECT * FROM users WHERE role='' ORDER BY id DESC LIMIT $offset, $page_result ";
$run= mysqli_query($con, $sql);
$count = mysqli_num_rows($run);
?><h4>Total of <?php CountUsers()?> users</h4> Arranged in desending order by time of registration
<?php
while($row= mysqli_fetch_array($run)){
  $id = $row ['id'];
    $username = strtolower($row['username']);
    $password = $row['password'];
    $balance = $row['balance'];
    $fullname = $row['fullname'];
    $phone_number = $row['phone_number'];
    $state_of_residence = $row['state_of_residence'];
    $city_of_residence = $row['city_of_residence'];
    $occupation = $row['occupation'];
    $email = $row['email'];
    $account_type = $row['account_type'];
    $next_of_kin = $row['next_of_kin'];
    $pin = $row['pin'];
    $location = $row['location'];
    $contact_address = $row['contact_address'];
    $gender = $row['gender'];
    $marital_status = $row['marital_status'];
    $pin = $row['pin'];
    $account_number = $row['account_number'];

<tr class="div<?php echo $id?>">
<td><a href="<?php echo $username?>"> <?php echo $fullname?>(@<?php echo $username?>)</a></td>
<td><?php echo $account_number?></td>
<td><?php echo $account_type?></td>
<td><?php echo $email?></td>
<td><?php echo Currency($balance)?></td>
<td><?php echo $gender?></td>
<td><a href="<?php echo $username?>">View</a><br/>
<a href="edit_user.php?user=<?php echo $username?>">Edit</a>
 <br/><a href="#" onclick="DeleteUser(<?php echo $id?>)">Delete</a>  </td>
</tr>

<?php

}
?>
</tbody>
</table>

function DeleteUser(div){

confirm('Are you sure you want to delete?');
 $.ajax({
        url:"functions/delete_user.php?id="+div+"&delete=yes",
        success:function(data)
        {
    $(".div"+div+"").hide(); }
        });

}
</script>

<div id="pagination"><br/><ul>
<?php

$result =mysqli_query($con, "SELECT id from users");
$numrows=mysqli_num_rows($result);

$pagecount = $numrows; // Total number of rows
$num = $pagecount / $page_result ;

if($_GET['pageno'] > 1)
{
   echo "<li><a href = 'view_users.php?pageno=".($_GET['pageno'] - 1)." '> Prev </a></li>";
}

if($_GET['pageno'] < $num)
{
   echo "<li><a href = 'view_users.php?pageno=".($_GET['pageno'] + 1)." '> next </a></li>";
}

if($_GET['pageno']+1 <= $num){
for($i = $_GET['pageno'] ; $i <= $_GET['pageno']+2 ; $i++)
{
   echo "<li><a href = 'view_users.php?pageno=". $i." '> ". $i ."</a></li>";
}
}

?>
</div>

</div></div>
<?php
include("includes/footer.php");

${this.title}

Code Editor : view_users.php