1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / tapnaire.live / manager /
Filename : user-details.php
back
<?php
session_start();
error_reporting(0);
include('../../config/conn.php');
include('include/checklogin.php');
check_login();
include('include/header.php');
include('include/sidebar.php');
$title="Admins";

$currentTime = date( 'd-m-Y h:i:s A', time () );

//error_reporting(E_ALL);
//ini_set('display_errors', 1);

if(isset($_GET['del']))
		  {
		          mysqli_query($con,"DELETE FROM users WHERE id = '".$_GET['id']."'");
                  echo "<script>window.location.href='users.php';</script>";

		  }

if(isset($_GET) & !empty($_GET)){
	$uid=intval($_GET['uid']);// farmer's id
}else{
		echo "<script>window.location.href='users.php';</script>";
	}

$uid=intval($_GET['uid']);// farmer's id

if(isset($_POST) && !empty($_POST)){
  
$fullname = mysqli_real_escape_string($con, $_POST['fullname']);
$phone = mysqli_real_escape_string($con, $_POST['phone']);
$referred_by = mysqli_real_escape_string($con, $_POST['referred_by']);
$ref_bonus = mysqli_real_escape_string($con, $_POST['ref_bonus']);
$earnings = mysqli_real_escape_string($con, $_POST['earnings']);
$tapping = mysqli_real_escape_string($con, $_POST['tapping']);
$facebook = mysqli_real_escape_string($con, $_POST['facebook']);
$twitter = mysqli_real_escape_string($con, $_POST['twitter']);
$instagram = mysqli_real_escape_string($con, $_POST['instagram']);
$tiktok = mysqli_real_escape_string($con, $_POST['tiktok']);
$bank = mysqli_real_escape_string($con, $_POST['bank']);
$account_name = mysqli_real_escape_string($con, $_POST['account_name']);
$account_number = mysqli_real_escape_string($con, $_POST['account_number']);
$coupon_account_bal=mysqli_real_escape_string($con, $_POST['coupon_account_bal']);
$sql = "UPDATE `users` SET `fullname`='$fullname', `phone`='$phone', `ref_bonus`='$ref_bonus',`coupon_account_bal`='$coupon_account_bal',
         `earnings`='$earnings',`tapping`='$tapping',`facebook`='$facebook',
         `twitter`='$twitter', `instagram`='$instagram', `tiktok`='$tiktok', `bank_name`='$bank',
         `account_name`='$account_name', `account_number`='$account_number', `updated_at`='$currentTime'
         WHERE `id`='$uid' ";    
$res = mysqli_query($con, $sql);
if($res){
    $msg = "Profile Updated Successfully!";
    $type = "success";
} else {
    $msg = "Failed to Update Profile";
    $type = "warning";
}



    }
	?>

  <!-- Content wrapper -->
  <div class="content-wrapper">
            <!-- Content -->

<div class="container-xxl flex-grow-1 container-p-y">
<h4 class="fw-bold py-3 mb-4"><span class="text-muted fw-light">User/</span> Edit Profile</h4>

<?php 
          $query="SELECT * FROM users WHERE id='$uid' ";
          $result=mysqli_query($con,$query);
          while($row=mysqli_fetch_array($result))
{?>
 
 <div class="card mb-4">
                    <h5 class="card-header">Profile Details</h5>
                    <!-- Account -->
                    <div class="card-body">
                      <div class="d-flex align-items-start align-items-sm-center gap-4">
                        <img
                          src="profilepics/<?php echo $row['user_picture'] ?>"
                          alt="Profile Picture"
                          class="d-block rounded"
                          height="100"
                          width="100"
                        />
                       
                      </div>
                    </div>
                    <hr class="my-0" />
                    <div class="card-body">
                    <?php if(isset($msg)){ ?>
                    <div class="alert alert-<?php echo $type?>">
                          <h6 class="alert-heading fw-bold mb-1"><?php echo $type?></h6>
                          <p class="mb-0"><?php echo $msg?></p>
                        </div>
                        <?php }?>
                    <form  method="post" enctype="multipart/form-data">
                        <div class="row">
                        <div class="mb-3 col-md-6">
                        <label class="form-label" for="basic-default-fullname">Full Name</label>
                        <input type="text" class="form-control" name="fullname"  value="<?php echo $row['fullname']; ?>" />
                      </div>
                      <div class="mb-3 col-md-6">
                        <label class="form-label" for="basic-icon-default-email">Username</label>
                        <input type="text" class="form-control"
                         value="<?php echo $row['username']; ?>" disabled />
                      </div>
                      <div class="mb-3 col-md-6">
                        <label class="form-label" for="basic-icon-default-email">Email</label>
                        <input type="email" class="form-control"
                         value="<?php echo $row['email']; ?>" disabled />
                      </div>
                      <div class="mb-3 col-md-6">
                        <label class="form-label" for="basic-default-phone">Phone No</label>
                        <input
                          type="text" class="form-control phone-mask"
                          value="<?php echo $row['phone']; ?>"
                          name="phone"
                        />                  
                      </div>
                      <div class="mb-3 col-md-6">
                        <label class="form-label" for="basic-default-company">Referred By</label>
                         <input type="text" class="form-control" name="referred_by" value="<?php echo $row['referred_by']; ?>" disabled/>
                      </div>

                      <div class="mb-3 col-md-6">
                        <label class="form-label" for="basic-default-fullname">Affiliate Balance</label>        
                       <input type="text" class="form-control" name="ref_bonus"  value="<?php echo $row['ref_bonus']; ?>" />
                      </div> 
                      <div class="mb-3 col-md-6">
                        <label class="form-label" for="basic-default-fullname">Tap Balance</label>        
                       <input type="text" class="form-control" name="tapping"  value="<?php echo $row['tapping']; ?>" />
                      </div> 
                      <div class="mb-3 col-md-6">
                        <label class="form-label" for="basic-default-fullname">Activities Balance</label>        
                       <input type="text" class="form-control" name="earnings"  value="<?php echo $row['earnings']; ?>" />
                      </div> 
                                             
                      <div class="mb-3 col-md-6">
                        <label class="form-label" for="basic-default-fullname">Vendor Coupon Account Balance</label>        
                           <input type="text" class="form-control" name="coupon_account_bal"  value="<?php echo $row['coupon_account_bal']; ?>" />
                      </div>
                      <div class="mb-3 col-md-6">
                        <label class="form-label" for="basic-default-fullname">Facebook</label>        
                   <input type="text" class="form-control" name="facebook"  value="<?php echo $row['facebook']; ?>" />
                      </div>
                      <div class="mb-3 col-md-6">
                        <label class="form-label" for="basic-default-fullname">Twitter</label>        
                   <input type="text" class="form-control" name="twitter"  value="<?php echo $row['twitter']; ?>" />
                      </div>
                      <div class="mb-3 col-md-6">
                        <label class="form-label" for="basic-default-fullname">Instagram</label>        
                   <input type="text" class="form-control" name="instagram"  value="<?php echo $row['instagram']; ?>" />
                      </div>
                      <div class="mb-3 col-md-6">
                        <label class="form-label" for="basic-default-fullname">Tiktok</label>        
                   <input type="text" class="form-control" name="tiktok"  value="<?php echo $row['tiktok']; ?>" />
                      </div>
                      <div class="mb-3 col-md-6">
                        <label class="form-label" for="basic-default-fullname">Bank Name</label>        
                        <input type="text" class="form-control" name="bank"  value="<?php echo $row['bank_name']; ?>" />
                      </div>
                      <div class="mb-3 col-md-6">
                        <label class="form-label" for="basic-default-fullname">Account Holder Name</label>        
                        <input type="text" class="form-control" name="account_name"  value="<?php echo $row['account_name']; ?>" />
                      </div>
                      <div class="mb-3 col-md-6">
                        <label class="form-label" for="basic-default-fullname">Account Number</label>        
                        <input type="text" class="form-control" name="account_number"  value="<?php echo $row['account_number']; ?>" />
                      </div>
                        </div>
                        <div class="mt-2">
                          <button type="submit" class="btn btn-primary me-2" type="submit" name="submit" >Save changes</button>
                        </div>
                      </form>
                    </div>
                    <!-- /Account -->
                  </div>
                  <div class="card">
                    <h5 class="card-header">Delete Account</h5>
                    <div class="card-body">
                      <div class="mb-3 col-12 mb-0">
                        <div class="alert alert-warning">
                          <h6 class="alert-heading fw-bold mb-1">Are you sure you want to delete your account?</h6>
                          <p class="mb-0">Once you delete your account, there is no going back. Please be certain.</p>
                        </div>
                      </div>
                       
                        <a href="?id=<?php echo $row['id'];?>&del=delete" 
                        onClick="return confirm('Are you sure you want to delete this user account?')" class="btn btn-danger deactivate-account">
                        Delete Account</a>
                    </div>
                  </div>
                </div>

</div></div>

                <?php }?>
              </div>
            </div>
            <!-- / Content -->




<?php include('include/footer.php');?>