File "get-user-details.php"

Full path: /home/eshuaesb/public_html/www.mhawaterpark.com/admin/get-user-details.php
File size: 1.54 KB B
MIME-type: text/x-php
Charset: utf-8

Download   Open   Edit   Advanced Editor   Back

<?php
function getbalance($uid)
{
    include("conn.php");
    $qry="select balance from tbl_wallet where uid='$uid'";
    $stmt= mysqli_query($conn,$qry);
    $res=mysqli_fetch_assoc($stmt);
    if($res['balance']=="")
    return("0.00");
    else
    return($res['balance']);
}
function getcoupons($uid)
{
    include("conn.php");
    $qry="select count(*) as total from tbl_coupons where user='$uid' and status='Unused'";
    $stmt= mysqli_query($conn,$qry);
    $res=mysqli_fetch_assoc($stmt);
    return($res['total']);
}
function getcode($uid)
{
    include("conn.php");
    $qry="select code from tbl_coupons where user='$uid' limit 1";
    $stmt= mysqli_query($conn,$qry);
    $res=mysqli_fetch_assoc($stmt);
    return($res['code']);
}
    require "./conn.php";  
    if (isset($_POST['id']))
    {
           $id = $_POST['id'];
           $sql="select * from tbl_user where id='$id'";
           $smt= mysqli_query($conn,$sql);
          
           while ($row = mysqli_fetch_assoc($smt)) 
            { 
                $data["id"] = $row['id']; 
                $data["name"] = $row['uname']; 
                $data["mobile"] = $row['mobile']; 
                $data["email"] = $row['email'];
                $data["address"] = $row['address'].$row['city'].$row['pin_code']; 
                $data["balance"] = getbalance($row['mobile']);
                $data["coupon"] = getcoupons($row['mobile']);
                $data["code"] = getcode($row['mobile']);
            } 
            echo json_encode($data); 
    }
?>