<?php include('usercoupondelete.php'); ?>
<?php
$servername  = "localhost";
$dbusername = "root";
$dbpassword = "";
$dbname = "";

$mobile = $_SESSION['mobile'];
$date = date('M-d,Y H:i:s');
$date2 = date('M-d,Y');

$conn = new mysqli ($servername, $dbusername, $dbpassword, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT * FROM userpaytoget WHERE mobile = '$mobile' ";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {

$usercouponinhand = $row["usercouponinhand"];
$couponvalue = $_GET["id"];
$totalvalue = $couponvalue + $usercouponinhand ;

$sql2 = "UPDATE userpaytoget SET usercouponinhand = '$totalvalue', date = '$date', date2 = '$date2'
WHERE mobile = '$mobile'";

if ($conn->query($sql2) === TRUE) {
echo  '<a href="usercoupondelete.php"></a>';
}
else {
    echo "0";
}
}
 } else {
    echo "None";
    }

$conn->close();
?>

<a href="usercouponunlock.php?id=<?php echo $row6['amount'];?>" ><li ><strong>Link here </strong></li></a>

<?php include('userdeleteunlocked.php'); ?>
<?php
$servername  = "localhost";
$dbusername = "root";
$dbpassword = "";
$dbname = "";

$mobile = $_SESSION['mobile'];
$date = date('M-d,Y H:i:s');
$date2 = date('M-d,Y');

$conn = new mysqli ($servername, $dbusername, $dbpassword, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT * FROM useravailedlockedcoupons WHERE mobile = '$mobile' ";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {

$amount = $row['amount'];
$company = $row['company'];

$sql2 = "UPDATE usercouponunlock SET amount = '$amount', company = '$company', date = '$date2'
WHERE mobile = '$mobile'";

if ($conn->query($sql2) === TRUE) {
echo  '<a href="userdeleteunlocked"></a>';
}
else {
    echo "0";
}
}
 } else {
    echo "None";
    }

$conn->close();
?>