Server : LiteSpeed System : Linux us-phx-web1202.main-hosting.eu 4.18.0-553.84.1.lve.el8.x86_64 #1 SMP Tue Nov 25 18:33:03 UTC 2025 x86_64 User : u615232177 ( 615232177) PHP Version : 8.1.33 Disable Function : NONE Directory :  /home/u615232177/public_html/admin5352/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php session_start();
$page_name = basename($_SERVER['PHP_SELF']); 
include("headerstrict.php"); ?>
<title><?php echo $company_name; ?>, Admin, Wallet Deposits</title>

<!-- ======= Breadcrumbs ======= -->
<section id="breadcrumbs" class="breadcrumbs">
  <div class="container"> </div>
</section>
<!-- End Breadcrumbs -->
<!-- ======= Contact Section ======= -->
<section id="contact" class="contact inner-page">
	<div class="container" data-aos="fade-up">

	<div class="section-title">
		<h2>Wallet Deposits</h2>
		<p><a style='color:cornflowerblue;' href="wallet.php">All</a></p>
		<p><a style='color:crimson;' href="wallet_pending.php">Pending</a></p>
		<p><a style='color:forestgreen;' href="wallet_completed.php">Approved</a></p>
	</div>
	<div class="row">
			<?php $count = 0;
	$sql = "SELECT COUNT(id) FROM wallet WHERE type='Credit' ORDER BY id DESC";
	$query = mysqli_query($con, $sql);
	$row = mysqli_fetch_row($query);
	//here we have the total row count
	$rows = $row[0];
	//number of results we want per page
	$page_rows = 400;
	//tells us the page number of our last page
	$last = ceil($rows/$page_rows);
	//this makes sure last cannot be less than 1
	if($last < 1){$last = 1;}
	//establish the page num variable
	$pagenum = 1;
	//Get pageum from $GET if it is present, else its 1
	if(isset($_GET['pn'])){
	$pagenum = preg_replace('#[^0-9]#', '', $_GET['pn']);
	}
	//below 1 or more than last page
	if($pagenum < 1){
	   $pagenum = 1;
	}else if ($pagenum > $last) {
		$pagenum = $last;
	}
	//this sets the range of rows to query for the chosen pagenum
	$limit = 'LIMIT ' .($pagenum - 1) * $page_rows .',' .$page_rows;
	//grabs one page worth of rows
	$sql = "SELECT * FROM wallet WHERE type='Credit' ORDER BY id DESC $limit ";
	$query = mysqli_query($con, $sql);
	//this shows the user what page they on and total number
	$textline1 = "Messages $rows";
	$textline2 = "Page $pagenum of $last";
	//establish the pagination controls
	$paginationCtrls = "";
	//if there is more than one page worth of results
	if($last != 1){
		if($pagenum > 1){
			$previous = $pagenum - 1;
			//$paginationCtrls .='<a href="'.$_SERVER['PHP_SELF'].'?pn='.$previous.'">Previous</a> &nbsp';
			$paginationCtrls .='<li><a href="'.$_SERVER['PHP_SELF'].'?pn='.$previous.'">Prev</a></li>';
			//render clickable links to the left of target page number
			for($i = $pagenum-4; $i < $pagenum; $i++){
				if($i > 0){
					//$paginationCtrls .= '<a href="'.$_SERVER['PHP_SELF'].'?pn='.$i.'"></a> &nbsp; ';
					$paginationCtrls .= '<li><a href="'.$_SERVER['PHP_SELF'].'?pn='.$i.'">'.$i.'</a></li>';
				}
			}
		}
		//render target number bt not link
		//$paginationCtrls .= ''.$pagenum.' &nbsp; ';
		$paginationCtrls .= '<span class="pagination"><ul><li class="active"><a href="#">'.$pagenum.'</a></li></ul></span>';
		//render clickable number links to the right of target number
		for($i = $pagenum+1; $i <= $last; $i++){
			//$paginationCtrls .= '<a href="'.$_SERVER['PHP_SELF'].'?pn='.$i.'">'.$i.'</a> &nbsp; ';
			$paginationCtrls .= '<li><a href="'.$_SERVER['PHP_SELF'].'?pn='.$i.'">'.$i.'</a></li>';
			if($i >= $pagenum+4){
				break;
			}
		}
		//this does the same as above, only checking if we are on the last page
		if($pagenum != $last) {
			$next = $pagenum + 1;
			$paginationCtrls .= '<li><a href="'.$_SERVER['PHP_SELF'].'?pn='.$next.'">Next</a></li>';
		}
	}
	if(mysqli_num_rows($query) > 0){
		while ($row_back_deals = mysqli_fetch_array($query, MYSQLI_ASSOC)) {
			$wallet_id = $row_back_deals['wallet_id'];
			$amount = $row_back_deals['amount'];
			$user_id = $row_back_deals['user_id'];	
			$status = $row_back_deals['status'];	

			$count++;
			
			$stmt = $con -> prepare('SELECT * FROM users WHERE user_id=?');
			$stmt -> bind_param('s',$user_id);
			$stmt -> execute(); 
			$stmt -> store_result(); 
			$stmt -> bind_result($id,$user_id,$first_name,$last_name,$email,$password,$phone,$address,$date_signed_up); 
			$numrows = $stmt -> num_rows();
			if($numrows > 0){
				while ($stmt -> fetch()) { }
			}
			
			if($status=="Pending"){$color_s="crimson";}
			if($status=="Success"){$color_s="forestgreen";}
			echo"		
				<div class='col-md-2'>
					<hr/>
						<a style='color:$color_s;' href='user_details.php?u=$user_id'>$count - $currency$amount<br> ($first_name $last_name)</a>
					<hr/>
				</div>
			";						
		}
	}
	else{echo"Nothing found";}				
						
					?>
        </div>
		
		<div class='double_line'></div>
			<div class="row">
				<div class="col-md-12">
					<ul class="pagination clearfix">
				 <?php 
						
						echo"$paginationCtrls<br/><br/>";
						echo "<div class='text_line'>$textline2</div>";
						
					?>
					</ul>
				</div>
			</div>
	
    </div>
</section><!-- End Contact Section -->
<?php include("footer.php"); ?>