One Hat Cyber Team

View File Name : mg_bill.php

<?php error_reporting(0);
session_start();
include 'config.php';


$_POST['username']=$_SESSION['username'];	
$_POST['password']=$_SESSION['password'];

	$sql=mysqli_query($con,"select * from tadmin where USERNAME='".$_POST['username']."' and PASSWORD='".$_POST['password']."'");	
	if(mysqli_num_rows($sql)==1)
	{





$NI_ID = $_GET['NI_ID'];

$view = mysqli_query($con,"select * from noniatabill where NI_ID = '".$NI_ID."'"); // for editing

$datab = mysqli_fetch_array($view);



date_default_timezone_set("Asia/Kolkata");

if($_GET['SAI1']){
$AP_CAN = $_GET['NI_CANCEL'];

if($AP_CAN == 0){

 $upd_cancel =  mysqli_query($con,"UPDATE noniatabill SET NI_CANCEL ='1' WHERE NI_ID ='".$_GET['SAI1']."'");  //for cancel registered account
?>
                       <script>

						alert("Bill cancelled sucessfully");

						window.location= "mg_bill.php";

						</script>
<?php }
}
?>











<!DOCTYPE html>

<html>

<head>

<meta charset="utf-8">

<meta name="viewport" content="width=device-width, initial-scale=1">

<title>Admin Panel</title>



<link href="css/bootstrap.min.css" rel="stylesheet">

<link href="css/datepicker3.css" rel="stylesheet">

<link href="css/styles.css" rel="stylesheet">


<link href="css/bootstrap-table.css" rel="stylesheet">

<!--[if lt IE 9]>

<script src="js/html5shiv.js"></script>

<script src="js/respond.min.js"></script>

<![endif]-->
<script>
function cust2(cid){
var cid1 = (escape(cid));
 $.ajax({
  type: "GET",
  url: "get_cust2.php?cid="+cid1,
    success: function(result){
     $("#custid").html(result);
  }

});
 

}
</script>


</head>

    <script type="text/javascript" src="js/tinymce/tinymce.min.js"></script>

    <script type="text/javascript">

    tinymce.init({

        selector: "textarea",

        themes: "modern",   

		forced_root_block : 'p'
		
        plugins: [

            "advlist autolink lists link image charmap print preview anchor",

            "searchreplace visualblocks code fullscreen",

            "insertdatetime media table contextmenu paste"

        ],

        toolbar: "insertfile undo redo | styleselect | bold italic | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | link image"   
 
    });
	
function cal(str,st1)
{

$.ajax({
  type: "GET",
  url: "csgst.php?q="+str+"&state="+str1,
    success: function(result){
     $("#taxvalue").html(result);
  }

});
	}
	
function cal1(str)
{
	document.getElementById("am1").enabled = true;
	document.getElementById("am2").disabled = true;

$.ajax({
  type: "GET",
  url: "igst.php?q="+str,
    success: function(result){
     $("#taxvalue1").html(result);
  }

});
	}	
    </script>

<script>											// for cancelling confirm

function cancel(id){

 var cancel = confirm("Are you sure Want to cancel");

  if(cancel){
	  
  window.location.href = "mg_bill.php?SAI1="+id+"&NI_CANCEL=0";

  }

  else{

  window.location.href = "mg_bill.php";

  }

}

</script>
<body>

		<nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">
		<div class="container-fluid">
			<div class="navbar-header">
				<a href="#"><button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#sidebar-collapse">
					<span class="sr-only">Toggle navigation</span>
					<span class="icon-bar"></span>
					<span class="icon-bar"></span>
					<span class="icon-bar"></span>
				</button>
				</a>
				<a class="navbar-brand" href="#"><img src="../images/logo/thoa.png" style="width:50px;height:50px;margin-top:-10px;">&nbsp;&nbsp;&nbsp;<b>THOA Menu</b></a>
				<ul class="user-menu">
					<li class="dropdown pull-right">
						<a href="#" class="dropdown-toggle" data-toggle="dropdown"><img src="../images/team/6.jpg" style="border-radius:40%;width:35px;height:35px;"> MR. N.AHAMED THAMBI<span class="caret"></span></a>
						<ul class="dropdown-menu" role="menu">
							<li><a href="logou.php" style="color:red;"><span class="glyphicon glyphicon-off"></span>  Logout</a></li>
						</ul>
					</li>
				</ul>
			</div>
		</div><!-- /.container-fluid -->
	</nav>

		

	<div id="sidebar-collapse" class="col-sm-3 col-lg-2 sidebar">
		<form role="search">
			<div class="form-group">
				<input type="text" class="form-control" placeholder="Search">
			</div>
		</form>
	 <?php include('header.php');?>  


	</div><!--/.sidebar-->
		
	<div class="col-sm-9 col-sm-offset-3 col-lg-10 col-lg-offset-2 main">			
		<div class="row">
			<ol class="breadcrumb">
				<li><a href="dash.php"><span class="glyphicon glyphicon-home"></span></a></li>

				<li class="active">Manage Bill</li>

			</ol>

		</div><!--/.row-->

		



		<section class="content" style="position: absolute;top: 500px;">

		<div class="row">

			<div class="col-lg-12">

				<h2 class="page-header view1">To bill generate</h2>

			</div>

		</div><!--/.row-->
          <div class="row">

            <!-- left column -->

            <div class="col-lg-12">

              <!-- general form elements -->

              <div class="box box-primary">



                <!-- form start -->

				<div class="container">
				
					 <?php if($NI_ID)
						 
					 {?>	
<div class="form-group col-sm-10">
                      <label for="exampleInputFile" style="float:right;"><a href="mg_bill.php"><img src="back.png" width="40px" > Back to Bill Menu</a></label>		
</div>					  
					<div class="form-group col-sm-10">

                      <label for="exampleInputFile">Bill Image</label>



					 <iframe src="../fpdf/<?php echo $datab['NI_BILL'];?>" width="100%" style="height:800px;"></iframe>
					 <?php //$str = ltrim($data['AP_BILL'], 'New'); if($str){?>
					 
		<!--			 <iframe src="../../fpdf/<?php// echo $str;?>" width="100%" style="height:100%"></iframe>		 
					php} -->
					 

					</div>
<?php }?>
<form role="form" method="post" action="../fpdf/noniata.php" enctype="multipart/form-data" >
<div class="form-group col-sm-10">	
					<div class="form-group col-sm-6">

                   <label for="exampleInputEmail1">Year:</label>

				<select class="form-control" id="year" name="year">
<?php if($NI_ID) {?>
					<option value="<?php echo $datab['NI_YR'];?>"><?php echo $datab['NI_YR'];?></option>	
					<?php 
				$queryear=mysqli_query($con,"select *  from year ORDER BY Y_LIST DESC");
				while($rowyear=mysqli_fetch_array($queryear)) {?>
					<option value="<?php echo $rowyear['Y_LIST'];?>"><?php echo $rowyear['Y_LIST'];?></option>

 				
<?php } } else {?>					
				
					<?php 
				$queryear=mysqli_query($con,"select *  from year ORDER BY Y_LIST DESC");
				while($rowyear=mysqli_fetch_array($queryear)) {?>
					<option value='<?php echo $rowyear['Y_LIST'];?>'<?php if($rowyear['Y_LIST']=='2018') echo ' selected'; ?>><?php echo $rowyear['Y_LIST'];?></option>
				<?php }}?> 
				</select>		

                    </div>
	                <input type="hidden" class="form-control" id="niid" name="niid" value="<?php echo $NI_ID;?>" readonly>
	                <input type="hidden" class="form-control" id="nibl" name="nibl" value="<?php echo $datab['NI_BILL']; ?>" readonly>					
					<div class="form-group col-sm-6">

                   <label for="exampleInputEmail1">Invoice Date:</label>
<?php if($datab['NI_ID']) {?>
	                <input type="date" class="form-control" id="demo" name="appdate" value="<?php echo $datab['NI_DATE']; ?>" >
	<?php } else { ?>
	                <input type="date" class="form-control" id="demo" name="appdate" value="<?php echo date('Y-m-d') ?>" >
	<?php } ?>
                    </div>
</div>



<div class="form-group col-sm-10">
	
					<div class="form-group col-sm-6">

                    <label for="exampleInputEmail1">Select Company / Individual:</label>
	
					<select class="form-control" onchange="coming(this.value);"  id="comin" name="comin" required> 	
					<option value="">Select</option>
<option value="company">Company</option>	
<option value="individual">Individual</option>
					</select>
					
					</div>
</div>


<div id="comp">

<div class="form-group col-sm-10">
	
					<div class="form-group col-sm-6">

                    <label for="exampleInputEmail1">Company:</label>
					
				<!--    <textarea class="form-control" rows="1"   onclick="cust2(this.value);"  ><?php// echo $datab['NI_NAME']; ?></textarea>-->

                   
					<select class="form-control" onclick="cust2(this.value);"  id="apname" name="apname" required> 	
					<option value="">Select</option>
				<?php 	$querys=mysqli_query($con,"select *  from certificate GROUP BY MEM_NAME ORDER BY MEM_NAME ASC");
					while($rows=mysqli_fetch_array($querys)) {?>							
				<option value="<?php  echo $rows['MEM_NAME'];?>"><?php  echo $rows['MEM_NAME'];?></option>    
						 <?php  }?>					
					</select>	



				   </div>
					<div  id="custid">
					</div>

</div>
</div>

<div id="indi">
<div class="form-group col-sm-10">
					<div class="form-group col-sm-6">

                    <label for="exampleInputEmail1">Individual:</label>
					
				   <textarea class="form-control" rows="1"   id="apname1" name="apname1" ><?php echo $datab['NI_NAME']; ?></textarea>

                   




				   </div>
</div>


<div class="form-group col-sm-10">

					<div class="form-group col-sm-6">

                     <label for="exampleInputEmail1">Address : </label>
				     <textarea class="form-control" rows="1" id="apadd1" name="apadd1"><?php echo $datab['NI_ADD']; ?></textarea>

                    </div>

					<div class="form-group col-sm-6">

                    <label for="exampleInputEmail1">City </label>
				    <textarea class="form-control" rows="1" id="apcity1" name="apcity1"><?php echo $datab['NI_CITY']; ?></textarea>

                    </div>							

					
					

</div>








<div class="form-group col-sm-10">
					<div class="form-group col-sm-6">	
					<label for="exampleInputEmail1">State:  </label>
					<select class="form-control" id="sel1" name="apstate1" onChange="cal(tax.value,this.value)">
<?php if($datab['NI_STATE']) {?>
					<option value="<?php echo $datab['NI_STATE'];?>"><?php echo $datab['NI_STATE'];?></option>	
			<?php $sql = mysqli_query($con,"select * from state1");?>
					<?php while($drop2 = mysqli_fetch_array($sql)){?>
					<option value="<?php echo $drop2['ST_NAME'];?>"><?php echo $drop2['ST_NAME'];?></option>
 				
<?php } } else {?>					
					<?php $sql = mysqli_query($con,"select * from state1");?>
					<option value="Select">Select</option>
					<?php while($drop2 = mysqli_fetch_array($sql)){?>
					<option  <?php if($drop2['ST_NAME'] == "TamilNadu"){ echo "selected"; } ?> value="<?php echo $drop2['ST_NAME'];?>"><?php echo $drop2['ST_NAME'];?></option>
<?php }}?>
					
    				</select>
					</div>		
					<div class="form-group col-sm-6">

                     <label for="exampleInputEmail1">Email Id:  </label>
				     <textarea class="form-control" rows="1" id="apmail1" name="apmail1"><?php echo $datab['NI_MAIL']; ?></textarea>

                    </div>	

</div>

<div class="form-group col-sm-10">
					<div class="form-group col-sm-6">

                     <label for="exampleInputEmail1" >Phone Number :   </label> 
				     <textarea class="form-control" rows="1" id="apmob1" name="apmob1"><?php echo $datab['NI_MOB']; ?></textarea>

					 </div>	
					 </div>
					 
					 
					 </div>
 				
					<div class="form-group col-sm-10">
					 	<label for="sel1">Details 1:</label>	
					</div>
					<div class="form-group col-sm-10">					
					<div class="form-group col-sm-3">	
				 	<label for="sel1">Quantity1:</label>
	                <input type="text" class="form-control" id="qua1" name="qua1" value="<?php if($datab['NI_QUA1']) { echo $datab['NI_QUA1']; } else { echo "1"; } ?>" >
					</div>	
					<div class="form-group col-sm-6">	
				 	<label for="sel1">Item Name1:</label>
	                <input type="text" class="form-control" id="item1" name="item1" value="<?php if($datab['NI_ITEM1']) { echo $datab['NI_ITEM1']; } else { echo "ANNUAL MEMBERSHIP FEES 01-APRIL-2021 TO 31-MARCH-2023"; } ?>" >
					</div>
					<div class="form-group col-sm-3">	
				 	<label for="sel1">Cost1:</label>
	                <input type="text" class="form-control" id="cost1" name="cost1" value="<?php if($datab['NI_COST1']) { echo $datab['NI_COST1']; } else { echo "20000"; } ?>" onkeyup="cal(this.value,cost2.value,cost3.value)">
					</div>
					</div>

					<div class="form-group col-sm-10">
					 	<label for="sel1">Details 2:</label>	
					</div>
					<div class="form-group col-sm-10">					
					<div class="form-group col-sm-3">	
				 	<label for="sel1">Quantity2:</label>
	                <input type="text" class="form-control" id="qua2" name="qua2" value="<?php echo $datab['NI_QUA2']; ?>" >
					</div>	
					<div class="form-group col-sm-6">	
				 	<label for="sel1">Item Name2:</label>
	                <input type="text" class="form-control" id="item2" name="item2" value="<?php echo $datab['NI_ITEM2']; ?>" >
					</div>
					<div class="form-group col-sm-3">	
				 	<label for="sel1">Cost2:</label>
	                <input type="text" class="form-control" id="cost2" name="cost2" value="<?php echo $datab['NI_COST2']; ?>" onkeyup="cal(cost1.value,this.value,cost3.value)">
					</div>
					</div>

					<div class="form-group col-sm-10">
					 	<label for="sel1">Details 3:</label>	
					</div>
					<div class="form-group col-sm-10">					
					<div class="form-group col-sm-3">	
				 	<label for="sel1">Quantity3:</label>
	                <input type="text" class="form-control" id="qua3" name="qua3" value="<?php echo $datab['NI_QUA3']; ?>" >
					</div>	
					<div class="form-group col-sm-6">	
				 	<label for="sel1">Item Name3:</label>
	                <input type="text" class="form-control" id="item3" name="item3" value="<?php echo $datab['NI_ITEM3']; ?>" >
					</div>
					<div class="form-group col-sm-3">	
				 	<label for="sel1">Cost3:</label>
	                <input type="text" class="form-control" id="cost3" name="cost3" value="<?php echo $datab['NI_COST3']; ?>" onkeyup="cal(cost1.value,cost2.value,this.value)">
					</div>
					</div>					
	



<!-- <div class="form-group col-sm-10">	
			
					<div class="form-group col-sm-3">

                      <label for="exampleInputEmail1">Enter Taxable Amount:    </label>					
					
					  <input type="text" class="form-control" id="tax" name="tax" onkeyup="cal(cost1.value,cost2.value,cost3.value,this.value)">			  
					</div>

								
</div> -->
					
<div id="taxvalue">	
</div>
			
					<div class="form-group col-sm-10">
<div class="form-group col-sm-6">	
				                <label for="exampleInputEmail1">Payment Method: </label>
<select class="form-control" id="method" name="method">								
<?php if($datab['NI_METHOD']) {?>
  <option value="<?php echo $datab['NI_METHOD'];?>"><?php echo $datab['NI_METHOD'];?></option>	
  <option value="-">None</option>
  <option value="Credit/Debit Card">Credit/Debit Card</option>
  <option value="RTGS">RTGS</option>
  <option value="Online Payment">Online Payment</option>
  <option value="Cash">Cash</option>  
  <option value="Cheque">Cheque</option>    
  <option value="DD">DD</option> 					
<?php } else {?>								
  <option value="-">None</option>
  <option value="Credit/Debit Card">Credit/Debit Card</option>
  <option value="RTGS">RTGS</option>
  <option value="Online Payment">Online Payment</option>
  <option value="Cash">Cash</option>  
  <option value="Cheque">Cheque</option>    
  <option value="DD">DD</option>  
<?php } ?> 
</select>						
</div>	

<div class="form-group col-sm-6">
				                <label for="exampleInputEmail1">Bank Name: </label>			
								<input type="text" class="form-control" name="bankname"  value="<?php echo $datab['NI_BANK'];?>" placeholder="Enter name of bank cheque drawn">		 
</div>	
</div>
<div class="form-group col-sm-10">		
<div class="form-group col-sm-3">
				                <label for="exampleInputEmail1">DD/Cheque No./RTGS: </label>			
								<input type="text" class="form-control" name="chequeno"  value="<?php echo $datab['NI_DDCH'];?>" placeholder="Cheque Number">		 
</div>	
<div class="form-group col-sm-3">
								<label for="exampleInputEmail1">Date: </label>	
<?php if($NI_ID) {?>
	                <input type="date" class="form-control" id="chequedate" name="chequedate" value="<?php echo $datab['NI_CHQDT']; ?>" >	
<?php } else { ?>
				                	
	                <input type="date" class="form-control" id="chequedate" name="chequedate" value="<?php echo date('Y-m-d') ?>" >								
<?php } ?>	 
</div>	
<div class="form-group col-sm-3">
				                <label for="exampleInputEmail1">DD/Cheque Amount: </label>			
								<input type="text" class="form-control" name="chequeamt"  value="<?php echo $datab['NI_DDAMT'];?>" placeholder="Amount of cheque">		 
</div>	
</div>				
					
					
					
					<div class="box-footer col-sm-10">

                    <button type="submit" name="submit" value="submit" class="btn btn-primary">Click here to generate</button>
<hr>
<br>
                    </div>
				

	</form>

		</div>

</div>

</div>

</div>

</section>

<hr>

		<div class="row" style="position: absolute;float:top;">

			<div class="col-lg-12">

				<div class="panel panel-default">

					<div class="panel-heading view1">Bill generate/View Table</div>

					


		<div class="container">			
						<?php 
					$queryear=mysqli_query($con,"select *  from year ORDER BY Y_LIST DESC");
					while($rowyear=mysqli_fetch_array($queryear)) {?>		
					
					<div class="box">
					 <div class="top">
					<?php echo $yr=$rowyear['Y_LIST'];?>
					</div>
					<hr>


			
<div class="panel-body bottom">

			<form role="form" method="post" action="excel/noniataexport.php" enctype="multipart/form-data">

                  <div class="box-body">

                    <div class="form-group col-sm-3">
<label>Choose Month</label>					
						<select class="form-control" id="month" name="month">

					<option value="01">Jan</option> 				
					<option value="02">Feb</option>
					<option value="03">March</option>

					<option value="04">Apr</option> 				
					<option value="05">May</option>
					<option value="06">June</option>
					<option value="07">July</option>
					<option value="08">Aug</option>
					<option value="09">Sep</option>
					<option value="10">OCt</option>
					<option value="11">Nov</option>
					<option value="12">Dec</option>					
					
					</select>				

<input type="hidden" name="year" value="<?php echo $rowyear['Y_LIST'];?>">
                    </div>
					
					<div class="box-footer col-sm-11">

                    <button type="submit" name="submit" value="submit" class="btn btn-primary">Export by month</button>


			

                  </div>

				  </div>


            </form>	

				
 	
						<table data-toggle="table"  data-show-refresh="true" data-show-toggle="true" data-show-columns="true" data-search="true" data-select-item-name="toolbar1" data-pagination="true" data-sort-name="name" data-sort-order="desc"> <thead>

						    <tr>

						        <th data-field="state" data-checkbox="true" >Item ID</th>

						        <th data-field="itid" data-sortable="false">Item ID</th>

						        <th data-field="ano"  data-sortable="true">App No</th>

								<th data-field="aname"  data-sortable="true">Name</th>
								
								
								<th data-field="astatus" data-sortable="true">Action</th>
							

						    </tr>

						    </thead>

							<tbody>

							<?php 

							

                            $table = mysqli_query($con,"select * from noniatabill where NI_YR='$yr' ORDER BY NI_ID DESC");

							$NI_ID=1;

							while($row=mysqli_fetch_array($table))

							{

							?>

							   <tr> <td></td>

							   <td><?php echo $NI_ID;?></td>

							   <td><?php echo $row['NI_NO'];?></td>

							   <td><?php echo $row['NI_NAME'];?></td>	

							   <td><a href= "mg_bill.php?NI_ID=<?php echo $row['NI_ID'];?>">Edit</a>/<?php if($row['NI_CANCEL']==0) {?><a href = "#"  onclick="cancel('<?php echo $row['NI_ID'];?>')">Cancel</a><?php } else{?>Already Cancelled<?php } ?></td>
						
							   </tr>


                            <?php

							  $NI_ID++;

							 }?>

							</tbody>

							

							

						</table>

					</div>
					
					
					</div>
					<?php } ?>
					
					



					

					
					
					
					
					
					
					
					</div>
					
					
					
					
					
					

				</div>

			</div>

		</div>

		

 	

	</div>	<!--/.main-->



	<script src="js/jquery-1.11.1.min.js"></script>

	<script src="js/bootstrap.min.js"></script>

	<script src="js/chart.min.js"></script>

	<script src="js/chart-data.js"></script>

	<script src="js/easypiechart.js"></script>

	<script src="js/easypiechart-data.js"></script>

	<script src="js/bootstrap-datepicker.js"></script>

	<script src="js/bootstrap-table.js"></script>

	<script>
	
	$(document).ready(function() {
    $('ul.subcat').hide();
	$('#comp').hide();
	$('#indi').hide();
	
	
	

    $('li').click(function(event) {
        event.stopPropagation();
        $('> ul', this).toggle();

    });
});

function cal(str,str1,str2)
{
	 str=document.getElementById("cost1").value;
$.ajax({
  type: "GET",
  url: "taxvalue.php?a1="+str+"&a2="+str1+"&a3="+str2,
    success: function(result){
     $("#taxvalue").html(result);
  }

});
}
	
function cal1(str,str1)
{
	document.getElementById("am1").enabled = true;
	document.getElementById("am2").disabled = true;

$.ajax({
  type: "GET",
  url: "igst.php?q="+str+"&state="+str1,
    success: function(result){
     $("#taxvalue1").html(result);
  }

});
	}	
	
	</script>
	<script>
$('.top').on('click', function() {
	$parent_box = $(this).closest('.box');
	$parent_box.siblings().find('.bottom').hide();
	$parent_box.find('.bottom').toggle();
});
$('.top1').on('click', function() {
	$parent_box = $(this).closest('.box1');
	$parent_box.siblings().find('.bottom1').hide();
	$parent_box.find('.bottom1').toggle();
});

 $("#cyes").hide();

 function extra(val){
 
 if(val == 'DD')
 {
  $("#cyes").show(); 
 }
 else if(val == 'Cheque')
 {
  $("#cyes").show(); 	 
 }
  else if(val == 'RTGS')
 {
  $("#cyes").show(); 	 
 }
 else if(val != 'no'){
 $("#cyes").hide();
 } 
 }
 
 
 $(function () {
    cal(); 

});

 
 
 
 function coming(val){

 if(val == 'individual')
 {
	$('#comp').hide();
	$('#indi').show();
 }
 else if(val == 'company')
 {
	$('#comp').show();
	$('#indi').hide();  
 }	 
	 
 }
 
  function extra1(val){
 
 if(val == 'yes'){
 
 $("#pno").hide();
 $("#pyes").show(); 
   document.getElementById("am2").disabled = true;
  document.getElementById("am1").disabled = false;
 }
 else if(val == 'no'){
 $("#pyes").hide();
 $("#pno").show();
  document.getElementById("am2").disabled = false;
  document.getElementById("am1").disabled = true;
 } 
 }
 $("#pno").hide();
  $("#pyes").hide();


</script>
<style>
.container .box1 .top1 {
  padding: 12px;
  background-color: blue;
  color: white;
  cursor: pointer;
}

.container .box1 .bottom1 {

  display: none;
}
.container .box .top {
  padding: 12px;
  background-color: blue;
  color: white;
  cursor: pointer;
}

.container .box .bottom {

  display: none;
}

@media (min-width: 501px) and (max-width: 2000px){
.container .box {
width:auto;
max-width:900px;
}
.container .box1 {
width:auto;
max-width:900px;
}

}

@media (min-width: 5px) and (max-width: 500px){
.container .box {
width:100%;
max-width:350px;
}

.container .box1 {
width:100%;
max-width:350px;
}

.view1
{
font-size:14px;	
font-weight: bold;
text-decoration: underline;
}
}

</style>
</body>



</html>

	<?php } else
	{

$queryu=mysqli_query($con,"select * from tadmin where ID='1'");
$rowu=mysqli_fetch_array($queryu); 		
		
if($rowu)
{
$rowu['A_LOG'];	
$log = $rowu['A_LOG'] - 1;
$upd_sts =  mysqli_query($con,"UPDATE tadmin SET A_LOG ='$log' where ID='1'"); 
}		
		
header("Location: home.php");
	}
?>