Viewing: profile.php
<?php
session_start();
if(strlen($_SESSION['login'])==0)
{
header('location:index.php');
}
$useremail= $_SESSION['login'];
//$useremail= 'rajesh.kamble7771@gmail.com';
include 'db.php';
if (isset($_POST['update'])) {
$address = $_POST['address'];
$dob = $_POST['dob'];
$pincode = $_POST['pincode'];
$sql_query_update ="UPDATE users SET address = '$address', pincode = '$pincode',dob = '$dob' where EmailId='$useremail'";
$result = mysqli_query($conn, $sql_query_update);
}
$sql_query = "select * from users where EmailId='$useremail'";
$result = mysqli_query($conn,$sql_query);
include 'header.php';
while($row = $result->fetch_assoc()) {
$pid = $row["plantype"];
$uidd = $row["id"];
$fullname = $row["FullName"];
$_SESSION['active'] = $row["Active"];
?>
<section id="team" class="team">
<div class="container">
<div class="section-title">
<span>Membership Profile</span>
<h2>Membership Profile</h2>
<!--<p>Welcome <b><?php echo $row["FullName"] ;?></b> </p>-->
</div>
<div class="row justify-content-center mb-5">
<!--<div class="col-md-4 aos-init aos-animate" data-aos="zoom-in">-->
<!-- <div class="member h-100">-->
<!-- <img src="assets/img/team/team-1.jpg" alt="">-->
<!-- <h4><?php echo $row["FullName"] ;?></h4>-->
<!-- <span><?php echo $row["EmailId"] ;?></span>-->
<!-- <div class="col-auto">-->
<!-- <span class="pb-3" style="color:#0d6efd"><b>Plan Start On</b></span>-->
<!-- <div> <i class="fa fa-calendar text-gray-300 me-2"> </i><?php echo $row["plansstarttime"] ;?></div>-->
<!-- </div>-->
<!-- <?php if($row["planfinnishtime"]): ?>-->
<!-- <div class="col-auto">-->
<!-- <br />-->
<!-- <span>Finish On</span>-->
<!-- <i class="fa fa-calendar text-gray-300"> <?php echo $row["planfinnishtime"] ;?></i>-->
<!-- </div>-->
<!-- <?php endif ;?>-->
<!-- </div>-->
<!--</div>-->
<?php
$sql_query_plan = "select * from plans where id ='$pid'";
$result_plan = mysqli_query($conn,$sql_query_plan);
while($row_plan = $result_plan->fetch_assoc()) { ?>
<div class="col-12 col-md-7">
<div class="card border-left-primary shadow h-100 py-2" style="
background: #c4e5cb;
">
<div class="card-body">
<div class="row">
<div class="col-4">
<div class="profile-pic"><img src="assets/img/team/team-1.jpg" alt=""></div>
</div>
<div class="col-8">
<h4><?php echo $row["FullName"] ;?></h4>
<span><?php echo $row["EmailId"] ;?></span>
<div class="pt-3 pb-1" style="color:#0d6efd"><b>Plan Start On</b></div>
<div> <i class="fa fa-calendar text-gray-300 me-2"> </i><?php echo $row["plansstarttime"] ;?></div>
</div>
</div>
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<div class="text-xs font-weight-bold text-primary mb-1">
<h5 class="mb-3"><?php echo $row_plan["pname"] ;?> </h5></div>
<div class="h5 mb-0 font-weight-bold text-gray-800">
<!--------profilerform--->
<form method = "POST" action="<?=$_SERVER['PHP_SELF'];?>">
<div class="row">
<div class="col-md-6">
<div class="form-floating mb-3">
<input type="text" class="form-control" name="mobileno" placeholder="Mobile Number" maxlength="10" required="required" value = "<?php echo $row['MobileNumber'] ;?>" readonly>
<label for="floatingInput">Mobile Number</label>
</div>
</div>
<div class="col-md-6">
<div class="form-floating mb-3">
<input type="email" class="form-control" id="floatingInput" placeholder="name@example.com" name = "email" value = "<?php echo $useremail;?>" >
<label for="floatingInput">Email address</label>
</div>
</div>
<div class="col-md-6">
<div class="form-floating mb-3">
<input type="text" class="form-control" id="floatingInput"name = "fullname" value = "<?php echo $row['FullName'] ;?>">
<label for="floatingInput">Full Name</label>
</div>
</div>
<div class="col-md-6">
<div class="form-floating mb-3">
<input type="textarea" class="form-control" name="address" placeholder="Mobile Number" maxlength="100" row = "3" required="required" value = "<?php echo $row['address'] ;?>">
<label for="floatingInput">Address</label>
</div>
</div>
<div class="col-md-6">
<div class="form-floating mb-3">
<input type="number" class="form-control" name="pincode" placeholder="Pincode" maxlength="6" required="required" value = "<?php echo $row['pincode'] ;?>">
<label for="floatingInput">Pincode</label>
</div>
</div>
<div class="col-md-6">
<div class="form-floating mb-3">
<input type="date" class="form-control" name="dob" maxlength="10" required="required" value = "<?php echo $row['dob'] ;?>">
<label for="floatingInput">DoB</label>
</div>
</div>
</div>
<div class="mb-3 ">
<input type="submit" class="form-control submit-btn" name="update" >
<!--<label for="floatingInput">update </label>-->
</div>
</div>
</form>
<!--------profilerform- includes-->
</div>
</div>
</div>
</div>
</div>
</div>
<?php } ?>
<div class="section-title">
<span>My Coupons</span>
<h2>My Coupons</h2>
</div>
<div class="row justify-content-center" data-aos="zoom-in">
<?php
$sql_query_plan = "select * from userplanuse where cuseuid ='$uidd'";
// echo $sql_query_plan;
$result_plan = mysqli_query($conn,$sql_query_plan);
//print_r( $result_plan);
if($result_plan->num_rows > 0){
while($row_plan = $result_plan->fetch_assoc()) {
?>
<div class="col-md-3 ">
<div class="card border-left-primary shadow py-2 membership-coupon">
<div class="card-body">
<div class="row no-gutters align-items-center">
<div class="col mr-2">
<h5><?php echo $row_plan["cuname"] ;?></h5>
<h4><?php echo $row_plan["quanity"] ;?> Active</h4>
</div>
<div class="col-auto">
</div>
</div>
</div>
</div>
</div>
<?php }
}
else{
?>
<div class="col-xl-8 col-md-6 mb-4">
<div class="card border-left-primary shadow h-100 py-2">
<div class="card-body text-center">
Please Confirm your Payment with US to activate plan
</div>
</div>
</div>
</div>
<?php
}?>
</div>
</div>
</div>
</div>
</section>
<?php
}
include 'footer.php';
?>Back to File Manager