????????????????????
??????????????????
ÿØÿà
 JFIF      ÿÛ C      


!"$"$ÿÛ C    
ÿÂ p 
" ÿÄ     
         ÿÄ             ÿÚ 
   ÕÔË®

(%	aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥	BQ¤¢ X«)X…€¤   @  

adadasdasdasasdasdas


.....................................................................................................................................????????????????????
??????????????????
ÿØÿà
 JFIF      ÿÛ C      


!"$"$ÿÛ C    
ÿÂ p 
" ÿÄ     
         ÿÄ             ÿÚ 
   ÕÔË®

(%	aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥	BQ¤¢ X«)X…€¤   @  

adadasdasdasasdasdas


.....................................................................................................................................<?php
   include('session.php');
?>


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Update Customers || Xcel Training Institute</title>
    <!-- Favicon icon -->
    <link rel="icon" type="image/png" href="../images/logo-wide.png">
    <!-- Base Styling  -->
    <link rel="stylesheet" href="assets/main/css/fonts.css">
    <link rel="stylesheet" href="assets/main/css/style.css">
</head>

<body>
    <div id="main-wrapper" class="show">


        <?php
         include "sidebar.php";
         ?>


        <?php
         include "header1.php";
         ?>



        <!-- start section content -->
        <div class="content-body">
            <div class="warper container-fluid">
                <div class="new-patients main_container">
                   

                    <div class="row">
                        <div class="col-lg-12">
                            <div class="card">
                                <div class="card-header">
                                    <h4 class="card-title">Update Customers Details</h4>
                                </div>
                                <div class="card-body">
                                    <div class="basic-form">
                                        <form action="" method="post">

                                        <?php

          include 'connection.php';

          $idd = $_REQUEST['idk'];
          
          $showquery = "select * from customers where id=$idd";

          $showdata = mysqli_query($conn, $showquery);


          $arrdata = mysqli_fetch_array($showdata);

         if(isset($_POST['submit'])){

                $idu = $_POST['idk'];

        $name = mysqli_real_escape_string($conn, $_POST['name']);
        $company = mysqli_real_escape_string($conn, $_POST['company']);
        $mno = mysqli_real_escape_string($conn, $_POST['mno']);
        $email = mysqli_real_escape_string($conn, $_POST['email']);
        $gstno = mysqli_real_escape_string($conn, $_POST['gstno']);
        $address = mysqli_real_escape_string($conn, $_POST['address']);

                
               $query = "update customers set name='$name', company='$company', mno='$mno', email='$email', gstno='$gstno', address='$address' where id = $idd";
               
            

                $res = mysqli_query($conn, $query);
                
                if ($res) {
	?>
    
echo '<script>alert("Data Updated Successfully..."); window.location.href="add-customer.php"</script>';
<?php
}
else {

	 echo "ERROR: Hush! Sorry $sql. " 
                . mysqli_error($conn);
		?>
  <!--  <script>
alert("Data Not Updated");
</script>-->
<?php
}
      }
                ?>


                                            <div class="row">
                                               
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Name</label>
                                                        <input type="text" class="form-control" placeholder="Name" name="name" value="<?php echo $arrdata['name'];?>">
                                                    </div>
                                                </div>
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Company</label>
                                                        <input type="text" class="form-control" placeholder="Company" name="company" value="<?php echo $arrdata['company'];?>">
                                                    </div>
                                                </div>
                                                
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Mobile No</label>
                                                        <input type="text" class="form-control" placeholder="Mobile No" name="mno" value="<?php echo $arrdata['mno'];?>">
                                                    </div>
                                                </div>

                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Email</label>
                                                        <input type="text" class="form-control" placeholder="Email" name="email" value="<?php echo $arrdata['email'];?>">
                                                    </div>
                                                </div>

                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">GSTIN No</label>
                                                        <input type="text" class="form-control gstin" placeholder="GSTIN No" name="gstno" value="<?php echo $arrdata['gstno'];?>">
                                                         <span class="gstin-error" style="color: red; font-size: 14px;"></span>
                                                    </div>
                                                </div>

                                               
                                                <div class="col-xl-4">
                                                    <div class="form-group">
                                                        <label class="form-label">Address</label>
                                                        <input type="text" class="form-control" placeholder="Address" name="address" value="<?php echo $arrdata['address'];?>">
                                                    </div>
                                                </div>

                                                

                                                
                                            </div>
                                            <div class="form-group text-right">
                                                <button type="submit" name="submit" class="btn btn-primary float-end ">Save</button>
                                            </div>
                                        </form>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

                   


                  


                </div>
            </div>
        </div>
        <!-- End section content -->


       <?php
   include('footer.php');
?>

    </div>


    <!-- JQuery v3.5.1 -->
    <script src="assets/plugins/jquery/jquery.min.js"></script>

    <!-- popper js -->
    <script src="assets/plugins/popper/popper.min.js"></script>

    <!-- Bootstrap -->
    <script src="assets/plugins/bootstrap/js/bootstrap.min.js"></script>

    <!-- Moment -->
    <script src="assets/plugins/moment/moment.min.js"></script>

    <!-- Date Range Picker -->
    <script src="assets/plugins/daterangepicker/daterangepicker.min.js"></script>

    <!-- Datatable -->
    <script src="assets/plugins/datatables/jquery.dataTables.min.js"></script>
    <script src="assets/js/init-tdatatable.js"></script>

    <!-- Main Custom JQuery -->
    <script src="assets/js/toggleFullScreen.js"></script>
    <script src="assets/js/main.js"></script>

</body>
</html>