<?php





if (isset($_POST['update4'])) {
    $currant_address = $_POST['currant_address'];
    $permanant_address = $_POST['permanant_address'];
    $state = $_POST['state'];
    $district = $_POST['district'];


    if (isset($_SESSION['member_profile_id']) && $_SESSION['member_profile_id'] != '') {

        $sql1 = "UPDATE member_profile SET currant_address='$currant_address',
        permanant_address='$permanant_address',
        state='$state',
        district='$district'
         WHERE member_profile_id='" . $_SESSION['member_profile_id'] . "'";


        if (mysqli_query($con, $sql1)) {

            //echo "Records inserted successfully.";
            {
                echo "<script>
                      alert('Profile Updated Successfully..!!!');
                                         
                  </script>";
            }
        } else {


            $ermsg = "Either Email ID or Password is Incorrect..!";
        }
    }
}







?>









<p> <?php echo htmlentities($ermsg); ?></p>


<table class="table table-bordered">
    <tbody>

        <tr>

            <td>YOUR CURRENT ADDRESS :-

            </td>

            <td> 
            
            <textarea class="form-control" rows = "5" cols = "50"  name="currant_address">
           <?php echo htmlentities($row['currant_address']); ?>
         </textarea>
            
            
            </td>


        </tr>
        <tr>

            <td>YOUR PERMANENT ADDRESS :-

            </td>

            <td>
            <textarea class="form-control" rows = "5" cols = "50"  name="permanant_address">
          <?php echo htmlentities($row['permanant_address']); ?>
         </textarea>
            </td>


        </tr>
        <tr>

            <td>SELECT STATE :-

            </td>

            <td><input class="form-control" name="state" type="text" value="<?php echo htmlentities($row['state']); ?>"></input>

                <select class="btn btn-warning form-control" name="state" id="state" class="form-control">
                    <option value="">--Select Your State--</option>

                    <?php
                    // Feching active categories
                    $ret = mysqli_query($con, "select id,state_name from state where status=1");
                    while ($result = mysqli_fetch_array($ret)) {
                    ?>

                        <option  value="<?php echo htmlentities($result['state_name']); ?>"><?php echo htmlentities($result['state_name']); ?></option>


                    <?php } ?>
                </select>





            </td>


        </tr>

        <tr>

            <td>YOUR DISTRICT:-

            </td>
            <td><input class="form-control" name="district" type="text" value="<?php echo htmlentities($row['district']); ?>"></input></td>



        </tr>






    </tbody>
</table>














<div class="save-stngs pd2">
    <ul>

        <button class="btn btn-primary" name="update4" type="submit"><b>Update Address Information</b></button>
    </ul>
</div>