Gecko [ midwest-tb.com ]

Name	Size	Permission
assets	[ DIR ]	drwxr-xr-x
functions	[ DIR ]	drwxr-xr-x
img	[ DIR ]	drwxr-xr-x
includes	[ DIR ]	drwxr-xr-x
.htaccess	4.65 KB	-rw-r--r--
01admin.zip	112.24 KB	-rw-r--r--
add_user.php	11.21 KB	-rw-r--r--
banner.php	1.41 KB	-rw-r--r--
db.php	30 B	-rw-r--r--
delete.php	357 B	-rw-r--r--
delete_banner.php	736 B	-rw-r--r--
delete_post.php	960 B	-rw-r--r--
delete_user.php	991 B	-rw-r--r--
edit_banner.php	3.38 KB	-rw-r--r--
edit_post.php	11.55 KB	-rw-r--r--
edit_post2.php	5.62 KB	-rw-r--r--
edit_user.php	13.09 KB	-rw-r--r--
editsettings.php	2.61 KB	-rw-r--r--
error_log	54.03 KB	-rw-r--r--
function_users.php	6.8 KB	-rw-r--r--
functions.php	10.92 KB	-rw-r--r--
home.php	6.62 KB	-rw-r--r--
index.php	56 B	-rw-r--r--
insert_banners.php	3.07 KB	-rw-r--r--
insert_post.php	9.63 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	17.64 KB	-rw-r--r--
payment_setting.php	2.97 KB	-rw-r--r--
picupload.php	2.12 KB	-rw-r--r--
post.php	2.02 KB	-rw-r--r--
posts.php	2.94 KB	-rw-r--r--
print_shipment.php	1.91 KB	-rw-r--r--
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	5.02 KB	-rw-r--r--
testimony.php	3.15 KB	-rw-r--r--
upload_files.php	2.59 KB	-rw-r--r--
user_error.php	188 B	-rw-r--r--
user_withdrawal.php	4.99 KB	-rw-r--r--
view_admin.php	2.84 KB	-rw-r--r--
view_banners.php	2.4 KB	-rw-r--r--
view_posts.php	2.85 KB	-rw-r--r--
view_referrals_bonus.php	2.83 KB	-rw-r--r--
view_users.php	4.78 KB	-rw-r--r--
viewconversation.php	5.37 KB	-rw-r--r--
viewmessage.php	2.4 KB	-rw-r--r--
viewmessages.php	4.24 KB	-rw-r--r--
website_setting.php	3.09 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="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h4 class="card-title">All Users </h4>
                 
<br/>
                  <a href="add_user"><button class="btn btn-primary">Add User</button></a>
                   </div>  
<?php

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

<div class="table-responsive">
                    <table class="table table-bordered table-striped">
<thead>
<tr>
<th>ID</th>
<th>Username</th>
<th>Email</th>
<th>Password</th>
<th>Ip address</th>
<th>Country</th>
<th>City</th>
<th>Balance</th>
<th>Action</th>
<th>Delete User</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);
?>
<?php
while($row= mysqli_fetch_array($run)){

$id = $row ['id'];
  $username = $row ['username'];
    $fullname = $row ['fullname'];
    $phone_number = $row ['phone_number'];
    $secret_question = $row ['secret_question'];
    $ethereum = $row ['ethereum'];
    $active = $row ['active'];
    $bitcoin = $row ['bitcoin'];
    $litecoin = $row ['litecoin'];
    $email = $row ['email'];
    $balance = $row ['balance'];
    $pwd = $row ['pwd'];
    $city = $row ['city'];
    $ip_address = $row ['ip_address'];
    $location = $row ['location'];
    $city = $row ['city'];
  $email = $row['email'];
  if($active==""){
    $active ="No";
  }
	?>

<tr class="div<?php echo $id?>">
  <td><?php echo $id?></td>
<td><a href="<?php echo $username?>"> <?php echo $username?></a></td>
<td><?php echo $email?></a></td>
<td><?php echo $pwd?></a></td>
<td><?php echo $ip_address?></a></td>
<td><?php echo $location?></td>
<td><?php echo $city?></td>
<td><?php echo Currency($balance)?></td>
<td>
   <div class="btn-group mr-1 mb-1">
                                        <button type="button" class="btn btn-icon btn-dark dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Action</button>
                                        <div class="dropdown-menu">
                                            <a class="dropdown-item" href="../login_admin?user=<?php echo $username?>">Login as</a>
                                            <a class="dropdown-item" href="edit_user.php?user=<?php echo $username?>">Edit user</a>
                                        </div>
                                    </div>
</td>
<td><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