<?php session_start();
include("includes/db_config.php"); ?>
<?php if(isset($_POST['edit']))
{
extract($_POST);
$id=$_SESSION['id'];
$sql1 ="UPDATE  user_profile  SET fname='$name',email='$email',mob_no='$phone' WHERE id='".$id."'"; 
$res=mysqli_query($conn,$sql1) or die(mysqli_error());
if($res){
$sqlg = "SELECT * from user_profile where id = $id";
$resultg = mysqli_query($conn,$sqlg) or die(mysqli_error());
$resg = mysqli_fetch_object($resultg);

if($_FILES["prof_img"]["name"] != ""){
$oname=$_FILES["prof_img"]["name"];
$pos = strrpos($oname, ".");
$extension=substr($oname,$pos+1);
$tn = $_FILES["prof_img"]["tmp_name"];
$path = "admin/img/profile/".$resg->id.'32'.'.'.$extension;
$upath = "admin/img/profile/".$resg->prof_img;
unlink($upath);
move_uploaded_file($tn,$path);
$image = $resg->id.'32'.'.'.$extension;
} else {
$image = $resg->prof_img;
}

$sqlup = "UPDATE user_profile SET  prof_img =  '$image' WHERE  id = $resg->id";
$resultup = mysqli_query($conn,$sqlup) or die(mysqli_error());
                
echo "<script>window.location.href='my-profile.php'</script>";
}
} ?>
<!DOCTYPE html>
<html lang="en">
<meta http-equiv="content-type" content="text/html;charset=UTF-8" />

<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta name="description" content=" ">
    <meta name="author" content="">
    <title>Orange Groceries</title>
    <?php include("includes/css.php");?>
</head>

<body>
    <?php include("includes/header.php");?>
  <section class="page-info section-padding border-bottom topthumb">
        <div class="container-fluid">
            <div class="row">
                <div class="col-md-12">
                    <a href="index.php"> <span class="mdi mdi-home"></span> &nbsp; Home</a> <span class="mdi mdi-chevron-right"></span> <a href="#">Edit Profile</a>
                </div> 
                </div> 
        </div>
    </section>
    <section class="checkout-page section-padding">
        <div class="container-fluid">
            <div class="row">
                <div class="col-md-3">
                    <div class="card account-left">
                         <div class="list-group">
                            <a href="my-profile.php" class="list-group-item list-group-item-action"><i aria-hidden="true" class="mdi mdi-account-settings"></i> My Profile</a>
                            <a href="edit-profile.php" class="list-group-item list-group-item-action active"><i aria-hidden="true" class="mdi mdi-table-edit"></i> Edit Profile</a>
                            <a href="my-order.php" class="list-group-item list-group-item-action"><i aria-hidden="true" class="mdi mdi-format-list-bulleted"></i> My Order</a>
                             <a href="wishlist.php" class="list-group-item list-group-item-action"><i aria-hidden="true" class="mdi mdi-file-find"></i> My Wish List</a>
                            <a href="manage-address.php" class="list-group-item list-group-item-action"><i aria-hidden="true" class="mdi mdi-map-marker-circle"></i> Manage Address </a>
                            <!-- <a href="referral-code.php" class="list-group-item list-group-item-action"><i aria-hidden="true" class="mdi mdi-heart-outline"></i> Referral Code </a>
                            <a href="change-password.php" class="list-group-item list-group-item-action"><i aria-hidden="true" class="mdi mdi-heart-outline"></i> Change Password </a> -->
                            <a href="logout.php" class="list-group-item list-group-item-action"><i aria-hidden="true" class="mdi mdi-lock"></i> Logout</a>
                        </div>
                    </div>
                </div>
                <div class="col-md-9">
                    <div class="card card-body account-right my-address-page ">
                        <div class="page-heading">
                            <h3>Edit Profile</h3>
                        </div>
                         <?php  $id=$_SESSION['id'];
                            $sql_user="select * from user_profile where id='".$id."'";
                            $result_user = mysqli_query($conn, $sql_user);
                            $res_user= mysqli_fetch_array($result_user);
                            $country=$res_user['country'];
                            $state=$res_user['state'];
                            $city=$res_user['city'];
                            $sql_country = mysqli_query($conn,"select * from countries where id = '$country'");
                            $row_country = mysqli_fetch_array($sql_country);
                            $sql_state = mysqli_query($conn,"select * from states where id = '$state'");
                            $row_state = mysqli_fetch_array($sql_state);
                            $sql_city = mysqli_query($conn,"select * from cities where id = '$city'");
                            $row_city = mysqli_fetch_array($sql_city);
                            $shp_country=$res_user['shp_country'];
                            $shp_state=$res_user['shp_state'];
                            $shp_city=$res_user['shp_city'];
                            $sql_shcountry = mysqli_query($conn,"select * from countries where id = '$shp_country'");
                            $row_shcountry = mysqli_fetch_array($sql_shcountry);
                            $sql_shstate = mysqli_query($conn,"select * from states where id = '$shp_state'");
                            $row_shstate = mysqli_fetch_array($sql_shstate);
                            $sql_shcity = mysqli_query($conn,"select * from cities where id = '$shp_city'");
                            $row_shcity = mysqli_fetch_array($sql_shcity);
                             ?>   
                        <div class="table-responsive">
                            <form name="checkout_address" action="" method="post" enctype="multipart/form-data">
                            <div class="row">
                                <div class="col-lg-6">
                                    <label>Name</label>
                                    <input type="text" name="name" placeholder="Enter Name"  value="<?php echo $res_user['fname']; ?>" class="form-control" size="50">
                                </div>

                                <div class="col-lg-6">
                                    <label>Email-Id</label>
                                    <input type="email" name="email" id="email" value="<?php echo $res_user['email']; ?>" class="form-control" size="30" readonly>
                                </div> 

                                <div class="col-lg-6">
                                    <label>Contact No.</label>
                                    <input type="text" name="phone" id="phone" placeholder="Contact Number" value="<?php echo $res_user['mob_no']; ?>" class="form-control" size="10">
                                </div>  
                                <div class="col-lg-6">
                                    <label>Profile Pic</label>
                                    <?php $extension2 = end(explode(".", $res_user['prof_img']));
                                    if(!empty($extension2)){ ?>
                                    <img src="admin/img/profile/<?php echo $res_user['prof_img']; ?>" style="height:120px;" alt="your image" class="img-responsive" /><?php }else{ ?><img src="img/user.png" style="height:75px;" alt="your image" class="img-responsive" /><?php } ?></br>
                                    <input type="file" name="prof_img"  placeholder="Contact Number"  class="form-control">
                                </div> 

                               
                                 <div class="col-lg-12">
                                    <button class="btn btn-secondary mb-2 btn-lg" style="margin-top:15px;" name="edit" type="submit">Update Profile</button>
                                </div>
                            </div>
                        </form>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
    
    <?php include("includes/footer.php");?>
    <?php include("includes/js.php");?>
</body>
</html>