<?php 
session_start();
include("includes/db_config.php"); ?>
<?php if(isset($_POST['edit_address']))
{
extract($_POST);
$id=$_SESSION['id'];
$sql1 ="UPDATE  user_profile  SET country='$country',state='$state',city='$city',addr='$address',pincode='$pincode',mob_no='$phone',landmark='$landmark' WHERE id='".$id."'"; 
$res=mysqli_query($conn,$sql1) or die(mysqli_error());
if($res){
echo "<script>window.location.href='manage-address.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 Address</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"><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 active"><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 Address</h3>
                        </div>

                        <div class="table-responsive">
                              <?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);
                             ?>
                             <form name="checkout_address" action="" method="post">
                            <div class="row">
                                <div class="col-lg-6">
                                    <label>Name</label>
                                    <input type="text" name="person_name" id="person_name" value="<?php echo $res_user['fname']; ?>" onkeyup="detect_deliverykey_profile(event);" class="form-control" size="30">
                                </div>

                                <div class="col-lg-6">
                                    <label>Phone</label>
                                    <input type="text" name="phone" id="phone" placeholder="phone" value="<?php echo $res_user['mob_no']; ?>" class="form-control" size="10" required="true">
                                </div>

                                <div class="col-lg-12">
                                    <label>Address</label>
                                    <input type="text" name="address" id="address" placeholder="House No.,Flat" value="<?php echo $res_user['addr']; ?>" class="form-control" size="30">
                                </div>
                                <div class="col-lg-12">
                                    <label>Landmark</label>
                                    <input type="text" name="landmark" id="landmark" placeholder="House No.,Flat,Landmark" value="<?php echo $res_user['landmark']; ?>" class="form-control" size="30">
                                </div>
                                 <div class="col-lg-6">
                                    <label>Country</label>
                                     <select class="form-control select" id="country_id" name="country"  required="">
                                          <option value="<?php echo $row_country['id']; ?>"><?php echo $row_country['name']; ?></option>
                                          <?php  $sql_country = mysqli_query($conn,"select * from countries where id='101'")or die(mysqli_error($con));
                                             while($row_country = mysqli_fetch_array($sql_country)){ ?>
                                          <option value="<?php echo $row_country["id"];?>"><?php echo $row_country["name"];?></option>
                                               <?php } ?>
                                     </select>
                                </div>
                                <div class="col-lg-5">
                                    <label>State</label>
                                    <select class="form-control select" name="state" id="state_id">
                                       <option value="<?php echo $row_state['id']; ?>"><?php echo $row_state['name']; ?></option>
                                    </select>
                                </div>

                                <div class="col-lg-4">
                                    <label>City</label>
                                   <select class="form-control select" name="city" id="city_id">
                                         <option value="<?php echo $row_city['id']; ?>"><?php echo $row_city['name']; ?></option>
                                    </select>
                                </div>
                                

                                <div class="col-lg-3">
                                    <label>Pincode</label>
                                    <input type="text" name="pincode" placeholder="Enter Pin Code" value="<?php echo $res_user['pincode']; ?>" class="form-control" size="6">
                                </div>
                                 <div class="col-lg-12">
                                    <button class="btn btn-secondary mb-2 btn-lg" style="margin-top:15px;" name="edit_address" type="submit">Update Address</button>
                                </div>
                            </div>
                        </form>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
    <?php include("includes/footer.php");?>
    <?php include("includes/js.php");?>
</body>
<script type="text/javascript">
     $(document).ready(function(){
            $('#country_id').on('change', function(){
                var cat_id = $(this).val();
               //alert(cat_id);
                if(cat_id){
                    $.ajax({
                        type:'POST',
                        url:'ajax_city.php',
                        data:'cat_id='+cat_id,
                        success:function(html){
                            $('#state_id').html(html);
                            console.log(html);
                        }
                    }); 
                }
            });

                $('#state_id').on('change', function(){
                var scat_id = $(this).val();
                if(scat_id){
                    $.ajax({
                        type:'POST',
                        url:'ajax_city.php',
                        data:'scat_id='+scat_id,
                        success:function(html){
                            $('#city_id').html(html);
                        }
                    }); 
                }
            });
        });
</script>
</html>