<?php session_start();
include("includes/db_config.php"); ?>
<!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="#">Manage 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="row">
                            <div class="col-md-9">
                                <div class="page-heading">
                                    <h3>Manage Address</h3>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div style="text-align: right; margin-bottom:10px;">
                                   <!--  <a href="new-address.php" class="btn btn-primary"><i class="mdi mdi-plus"></i> Add Address</a> -->
                                </div>
                            </div>
                        </div>

                        <div class="table-responsive">
                            <table class="table cart_summary table-striped text-black">
                                <thead>
                                    <tr>
                                        <th class="product-thumbnail">Name</th>
                                        <th class="product-price">Address</th>
                                        <th class="product-price">Phone</th>
                                        <th class="product-subtotal">Action</th>
                                    </tr>
                                </thead>
                                <tbody>
                                      <?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);
                             ?> 
                                    <tr>
                                        <td class="product-name">
                                            <?php echo $res_user['fname']; ?>
                                        </td>
                                         <td class="product-name">
                                             <?php echo $res_user['landmark']; ?>, <?php echo $res_user['addr']; ?>, <?php echo $row_city['name']; ?>,  <?php echo $row_state['name']; ?>,<?php echo $row_country['name']; ?> - <?php echo $res_user['pincode']; ?> 
                                        </td>
                                        <td class="product-name">
                                           <?php echo $res_user['mob_no']; ?>
                                        </td>
                                        <td><a style="color: blue;" class="edit-add" href="edit-address.php">Edit</a></td>
                                    </tr>
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </section>
    <?php include("includes/footer.php");?>
    <?php include("includes/js.php");?>
</body>

</html>