One Hat Cyber Team

View File Name : mg_package.php

<?php include('config.php');
$avai = mysql_query("select * from packdet");
$row = mysql_fetch_array($avai);
 ?>

<?php

/*  $con = mysql_connect('localhost', 'root', ''); 

							mysql_select_db("ecomm", $con);   */

 error_reporting(0); 

?>

<?php 



$A_ID = $_GET['A_ID'];

$view = mysql_query("select * from packdet where A_ID = '".$A_ID."'"); // for editing

$data = mysql_fetch_array($view);



if($_GET['SAI']){

$STS = $_GET['A_STS'];

if($STS == 0){

 $upd_sts =  mysql_query("UPDATE packdet SET A_STS ='0' WHERE A_ID ='".$_GET['SAI']."'");  //for changing status

}

else{

$upd_sts =  mysql_query("UPDATE packdet SET A_STS ='1' WHERE A_ID ='".$_GET['SAI']."'");

}	

}



if($_GET['del_id']){ ?>

 

<?php $del = mysql_query("delete from packdet where A_ID='".$_GET['del_id']."'"); //for deleting status

if($del){?>

                       <script>

						alert("Register detail deleted sucessfully");

						window.location= "mg_package.php";

						</script>

<?php }

if(!$del){?>

                       <script>

						alert("Register detail  Not deleted sucessfully");

						window.location= "mg_package.php";

						</script>

<?php }   



} 



if($_POST['submit']){
      

			  
			  $apsel = mysql_real_escape_string($_POST['apsel']);

		      $subcat = mysql_real_escape_string($_POST['subcat']);
			  
			  $clas = mysql_real_escape_string($_POST['clas']); 
	
			  $secpar = mysql_real_escape_string($_POST['secpar']); 
			  
			  $thipar = mysql_real_escape_string($_POST['thipar']); 			  
			  
		  
			  
			  $apri = mysql_real_escape_string($_POST['apri']); 

			  $inddep = mysql_real_escape_string($_POST['inddep']); 
			  
			  $hidep = mysql_real_escape_string($_POST['hidep']); 
	 
			  $fidep = mysql_real_escape_string($_POST['fidep']); 
	 
			  $tinddep = mysql_real_escape_string($_POST['tinddep']); 
			  
			  $tsaudep = mysql_real_escape_string($_POST['tsaudep']); 			  
			  
			  $indarr = mysql_real_escape_string($_POST['indarr']); 

			  $hiarr = mysql_real_escape_string($_POST['hiarr']); 	

			  $fiarr = mysql_real_escape_string($_POST['fiarr']); 

			  $tindarr = mysql_real_escape_string($_POST['tindarr']); 	

			  $tsauarr = mysql_real_escape_string($_POST['tsauarr']); 	

			  $midfl = mysql_real_escape_string($_POST['midfl']); 

			  $middep = mysql_real_escape_string($_POST['middep']); 

			  $midarr = mysql_real_escape_string($_POST['midarr']); 			  
			  
	  		  $secpoi = mysql_real_escape_string($_POST['secpoi']);	

	  		  $maknam = mysql_real_escape_string($_POST['maknam']);	

	  		  $makadd = mysql_real_escape_string($_POST['makadd']);	
			  
	  		  $makmob = mysql_real_escape_string($_POST['makmob']);	
			  
	  		  $makpho = mysql_real_escape_string($_POST['makpho']);	

	  		  $makfax = mysql_real_escape_string($_POST['makfax']);	

	  		  $makweb = mysql_real_escape_string($_POST['makweb']);	

	  		  $makmail = mysql_real_escape_string($_POST['makmail']);	

	  		  $makgait = mysql_real_escape_string($_POST['makgait']);	

	  		  $makhar = mysql_real_escape_string($_POST['makhar']);	

	  		  $makstay = mysql_real_escape_string($_POST['makstay']);	

	  		  $makto = mysql_real_escape_string($_POST['makto']);	
			  
					
	  		  $madnam = mysql_real_escape_string($_POST['madnam']);	

	  		  $madadd = mysql_real_escape_string($_POST['madadd']);	
			  
	  		  $madmob = mysql_real_escape_string($_POST['madmob']);	
			  
	  		  $madpho = mysql_real_escape_string($_POST['madpho']);	

	  		  $madfax = mysql_real_escape_string($_POST['madfax']);	

	  		  $madweb = mysql_real_escape_string($_POST['madweb']);	

	  		  $madmail = mysql_real_escape_string($_POST['madmail']);	

	  		  $madgait = mysql_real_escape_string($_POST['madgait']);	

	  		  $madhar = mysql_real_escape_string($_POST['madhar']);	

	  		  $madstay = mysql_real_escape_string($_POST['madstay']);	

	  		  $madto = mysql_real_escape_string($_POST['madto']);	


	  		  $azinam = mysql_real_escape_string($_POST['azinam']);	

	  		  $aziadd = mysql_real_escape_string($_POST['aziadd']);	
			  
	  		  $azimob = mysql_real_escape_string($_POST['azimob']);	
			  
	  		  $azipho = mysql_real_escape_string($_POST['azipho']);	

	  		  $azifax = mysql_real_escape_string($_POST['azifax']);	

	  		  $aziweb = mysql_real_escape_string($_POST['aziweb']);	

	  		  $azimail = mysql_real_escape_string($_POST['azimail']);	

	  		  $azigait = mysql_real_escape_string($_POST['azigait']);	

	  		  $azihar = mysql_real_escape_string($_POST['azihar']);	

	  		  $azistay = mysql_real_escape_string($_POST['azistay']);	
			  
	  		  $azito = mysql_real_escape_string($_POST['azito']);			  

	  		  $munam = mysql_real_escape_string($_POST['munam']);

	  		  $muser = mysql_real_escape_string($_POST['muser']);			  

	  		  $muadd = mysql_real_escape_string($_POST['muadd']);	
			  
	  		  $mumob = mysql_real_escape_string($_POST['mumob']);	
			  
	  		  $mupho = mysql_real_escape_string($_POST['mupho']);	

	  		  $mufax = mysql_real_escape_string($_POST['mufax']);	

	  		  $muweb = mysql_real_escape_string($_POST['muweb']);	

	  		  $mumail = mysql_real_escape_string($_POST['mumail']);	

	  		  $mugait = mysql_real_escape_string($_POST['mugait']);		

	  		  $mustay = mysql_real_escape_string($_POST['mustay']);				  
			 
			if($_GET['A_ID']==""){

			
					$querytot=mysql_query("select *  from packdet where A_SPACK ='".$subcat."' and A_PACK ='".$apsel."' and A_CLS='".$clas."'");
					if($rowtot=mysql_fetch_array($querytot))
					{

			
?>
<script type="text/javascript">
alert("Package already have");
location.href = 'mg_package.php';</script>
<?				
					
					
					
					}
			
			else{




   $ins = mysql_query("insert into packdet (A_PACK,A_SPACK,A_CLS,SEC_PAR,THI_PAR,A_PRICE,IND_DEP,IND_ARR,HI_DEP,HI_ARR,FI_DEP,TIND_DEP,TSAU_DEP,FI_ARR,TIND_ARR,TSAU_ARR,SEC_POI,MAK_NAM,MAK_ADD,MAK_MOB,MAK_PHO,MAK_FAX,MAK_WEB,MAK_MAIL,MAK_GAIT,MAK_HAR,MAK_STAY,MAK_TO,MAD_NAM,MAD_ADD,MAD_MOB,MAD_PHO,MAD_FAX,MAD_WEB,MAD_MAIL,MAD_GAIT,MAD_HAR,MAD_STAY,MAD_TO,AZI_NAM,AZI_ADD,AZI_MOB,AZI_PHO,AZI_FAX,AZI_WEB,AZI_MAIL,AZI_GAIT,AZI_HAR,AZI_STAY,AZI_TO,MU_NAM,MU_SER,MU_ADD,MU_MOB,MU_PHO,MU_FAX,MU_WEB,MU_MAIL,MU_GAIT,MU_STAY) values ('$apsel','$subcat','$clas','$secpar','$thipar','$apri','$inddep','$indarr','$hidep','$hiarr','$fidep','$tinddep','$tsaudep','$fiarr','$tindarr','$tsauarr','$secpoi','$maknam','$makadd','$makmob','$makpho','$makfax','$makweb','$makmail','$makgait','$makhar','$makstay','$makto','$madnam','$madadd','$madmob','$madpho','$madfax','$madweb','$madmail','$madgait','$madhar','$madstay','$madto','$azinam','$aziadd','$azimob','$azipho','$azifax','$aziweb','$azimail','$azigait','$azihar','$azistay','$azito','$munam','$muser','$muadd','$mumob','$mupho','$mufax','$muweb','$mumail','$mugait','$mustay')");	
	
		  			?><script>alert("Inserted sucessfully");

			</script><?
			           
			}
                      }

			 if($_GET['A_ID']!=""){
		
				{     

		   	 $upd =  mysql_query("update packdet set A_PACK='$apsel',A_SPACK='$subcat',A_CLS='$clas',SEC_PAR='$secpar',THI_PAR='$thipar',A_PRICE='$apri',IND_DEP='$inddep',IND_ARR='$indarr',HI_DEP='$hidep',HI_ARR='$hiarr',FI_DEP='$fidep',TIND_DEP='$tinddep',TSAU_DEP='$tsaudep',FI_ARR='$fiarr',TIND_ARR='$tindarr',TSAU_ARR='$tsauarr',MID_FL='$midfl',MID_DEP='$middep',MID_ARR='$midarr',SEC_POI='$secpoi',MAK_NAM='$maknam',MAK_ADD='$makadd',MAK_MOB='$makmob',MAK_PHO='$makpho',MAK_FAX='$makfax',MAK_WEB='$makweb',MAK_MAIL='$makmail',MAK_GAIT='$makgait',MAK_HAR='$makhar',MAK_STAY='$makstay',MAK_TO='$makto',MAD_NAM='$madnam',MAD_ADD='$madadd',MAD_MOB='$madmob',MAD_PHO='$madpho',MAD_FAX='$madfax',MAD_WEB='$madweb',MAD_MAIL='$madmail',MAD_GAIT='$madgait',MAD_HAR='$madhar',MAD_STAY='$madstay',MAD_TO='$madto',AZI_NAM='$azinam',AZI_ADD='$aziadd',AZI_MOB='$azimob',AZI_PHO='$azipho',AZI_FAX='$azifax',AZI_WEB='$aziweb',AZI_MAIL='$azimail',AZI_GAIT='$azigait',AZI_HAR='$azihar',AZI_STAY='$azistay',AZI_TO='$azito',MU_NAM='$munam',MU_SER='$muser',MU_ADD='$muadd',MU_MOB='$mumob',MU_PHO='$mupho',MU_FAX='$mufax',MU_WEB='$muweb',MU_MAIL='$mumail',MU_GAIT='$mugait',MU_STAY='$mustay'			  

 WHERE A_ID ='".$A_ID."'");

					}			

					if($upd){?>

			<script>alert("updated sucessfully");

			window.location ="mg_package.php"

			</script>

			<?php }

			if(!$upd){?>

			<script>alert("Not updated sucessfully");

			window.location ="mg_package.php"

			</script>

			<?php }		

				   } 	  

                   }


?>



<script>

function del(id){

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

  if(del){

  window.location.href = "mg_package.php?del_id="+id+"&del=1";

  }

  else{

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

  }

}

  
</script>









<!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>
 $(document).ready(function() {
 $("#pyes").hide();
 });
</script>
<script>


function showUser(str)
{
 if(str!='Ziyarah'){
 $("#pyes").show(); 
 }

 else if(str=='Ziyarah'){
 $("#pyes").hide();
 } 
 if(str=='Haj'){
 $("#phaj").show();
 }
 else if(str!='Haj')
 {
 $("#phaj").hide();	 
 }
$.ajax({
  type: "GET",
  url: "getsub.php?q="+str,
    success: function(result){
     $("#subcat").html(result);
  }

});
	}		  

</script>

<style>
@media (min-width: 5px) and (max-width: 500px){
.pack
{
position: absolute;
top:950px;	
}
}
@media (min-width: 501px) and (max-width: 2000px){
.pack
{
position: absolute;
top:750px;	
}	
}
</style>
  
</head>

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

    <script type="text/javascript">

    tinymce.init({

        selector: "textarea",

        themes: "modern",   

        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"   

    });

    </script>

<script>
function getstate(cid){

 $.ajax({
  type: "GET",
  url: "../get_state.php?cid="+cid,
    success: function(result){
     $("#state").html(result);
  }

});
 

}
function getcity(sid){
alert
 $.ajax({
  type: "GET",
  url: "../get_city.php?sid="+sid,
    success: function(result){
     $("#city").html(result);
  }

});
}
</script>






<body>

	<nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">

		<div class="container-fluid">

			<div class="navbar-header">

				<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#sidebar-collapse">

<a href="#">
					<span class="sr-only">Toggle navigation</span>

					<span class="icon-bar"></span>

					<span class="icon-bar"></span>

					<span class="icon-bar"></span>
</a>

				</button>

				<a class="navbar-brand" href="#">Admin</a>

				<ul class="user-menu">

					<li class="dropdown pull-right">

						<a href="#" class="dropdown-toggle" data-toggle="dropdown"><span class="glyphicon glyphicon-user"></span> User <span class="caret"></span></a>

						<ul class="dropdown-menu" role="menu">

							<li><a href="#"><span class="glyphicon glyphicon-user"></span> Profile</a></li>

							<li><a href="#"><span class="glyphicon glyphicon-cog"></span> Settings</a></li>

							<li><a href="logou.php"><span class="glyphicon glyphicon-log-out"></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>
	 <? 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 Package</li>

			</ol>

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

		



	<section class="content pack" style="">
		<div class="row">

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

				<h2 class="page-header">Add/Edit Package Details</h2>

			</div>

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

            <!-- left column -->

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

              <!-- general form elements -->

              <div class="box box-primary">



                <!-- form start -->

				<div class="container">

		

	<form role="form" method="post" action="" enctype="multipart/form-data">
                    
					
					<div class="form-group col-sm-11">
					<label for="sel1">Select Package:</label>
					<?  if($A_ID) {?> 
					<select id="apsel" name="apsel" class="form-control" onchange="showUser(this.value)"> 
					<?php 
					$query1=mysql_query("select *  from packdet where A_ID = '".$A_ID."'");
					while($row1=mysql_fetch_array($query1)) {?>
					<option value="<?php echo $row1['A_PACK'];?>"><?php echo $row1['A_PACK'];?></option>
					<?php }?>
					</select>
					<?}else{?>
					<select class="form-control" id="apsel" name="apsel" onchange="showUser(this.value)"> 
					<?php 
					$query1=mysql_query("select *  from package");
					while($row1=mysql_fetch_array($query1)) {?>
					<option value="<?php echo $row1['P_NAME'];?>"><?php echo $row1['P_NAME'];?></option>
					<?php }?>
					</select>
					<? }?>
					</div>
					
					<div class="form-group col-sm-11">	
					<label for="sel1">Select Subpackage:</label>
					<?  if($A_ID) {?> 
					<select id="subcat" name="subcat" class="form-control"> 
					<?php 
					$query1=mysql_query("select *  from packdet where A_ID = '".$A_ID."'");
					while($row1=mysql_fetch_array($query1)) {?>
					<option value="<?php echo $row1['A_SPACK'];?>"><?php echo $row1['A_SPACK'];?></option>
					<?php }?>
					</select>
					<?}else{?>					
					
					<select id="subcat" name="subcat" class="form-control"> 
					<?php 
					$query1=mysql_query("select *  from subpackage");
					while($row1=mysql_fetch_array($query1)) {?>
					<option value="<?php echo $row1['SP_NAME'];?>"><?php echo $row1['SP_NAME'];?></option> 
					<?php }?>
					</select>
					<? }?>
					</div>
					
					<div class="form-group col-sm-11">	
					<label for="sel1">Select Class:</label>
					<?  if($A_ID && $data['A_CLS']!="") {?> 
					<select id="clas" name="clas" class="form-control"> 
					<?php 
					$queryc=mysql_query("select *  from class where C_NAME='".$data['A_CLS']."'");
					while($rowc=mysql_fetch_array($queryc)) {?>
					<option value="<?php echo $rowc['C_NAME'];?>"><?php echo $rowc['C_NAME'];?></option> 
					<?php }?>
					</select>
					<?}else{?>	
					<select id="clas" name="clas" class="form-control"> 
					<?php 
					$queryc=mysql_query("select *  from class");
					while($rowc=mysql_fetch_array($queryc)) {?>
					<option value="<?php echo $rowc['C_NAME'];?>"><?php echo $rowc['C_NAME'];?></option> 
					<?php }?>
					</select>
					<? }?>
					</div>
					

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

                      <label for="exampleInputEmail1">2nd  Title</label>

                      <input type="text" class="form-control" id="secpar" name="secpar" value="<?php echo $data['SEC_PAR']; ?>">

                    </div>
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">3rd  Title</label>

                      <input type="text" class="form-control" id="thipar" name="thipar" value="<?php echo $data['THI_PAR']; ?>">

                    </div>
					<div class="form-group col-sm-11">

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

                      <input type="text" class="form-control" id="apri" name="apri" value="<?php echo $data['A_PRICE']; ?>">

                    </div>
					<div class="form-group col-sm-11">	
					<label for="sel1">DEPARTURE</label>
					</div>
				
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Indian Departure Date:</label>

					   <input type="text" class="form-control" id="demo" name="inddep" value="<?php echo $data['IND_DEP']; ?>">

                    </div>
					
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hijri Departure Date:</label>

					   <input type="text" id="datepicker" class="form-control"  name="hidep" value="<?php echo $data['HI_DEP']; ?>">

                    </div>	

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

                      <label for="exampleInputEmail1">Departure Flight No:</label>

					   <input type="text" id="datepicker" class="form-control"  name="fidep" value="<?php echo $data['FI_DEP']; ?>">

                    </div>	


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

                      <label for="exampleInputEmail1">Departure Indian Time:</label>

					   <input type="text" id="datepicker" class="form-control"  name="tinddep" value="<?php echo $data['TIND_DEP']; ?>">

                    </div>	

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

                      <label for="exampleInputEmail1">Arrival Saudi Time:</label>

					   <input type="text" id="datepicker" class="form-control"  name="tsaudep" value="<?php echo $data['TSAU_DEP']; ?>">

                    </div>	

					<div class="form-group col-sm-11">	
					<label for="sel1">ARRIVAL</label>
					</div>					
					
					
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Indian Arrival Date:</label>

					   <input type="text" class="form-control" id="demo" name="indarr" value="<?php echo $data['IND_ARR']; ?>">

                    </div>					
					
					

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

                      <label for="exampleInputEmail1">Hijri Arrival Date:</label>

					   <input type="text" id="datepicker1" class="form-control" name="hiarr" value="<?php echo $data['HI_ARR']; ?>">

                    </div>	
					
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Arrival Flight No:</label>

					   <input type="text" id="datepicker" class="form-control"  name="fiarr" value="<?php echo $data['FI_ARR']; ?>">

                    </div>	


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

                      <label for="exampleInputEmail1">Departure Saudi Time:</label>

					   <input type="text" id="datepicker" class="form-control"  name="tindarr" value="<?php echo $data['TIND_ARR']; ?>">

                    </div>	

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

                      <label for="exampleInputEmail1">Arrival Indian Time:</label>

					   <input type="text" id="datepicker" class="form-control"  name="tsauarr" value="<?php echo $data['TSAU_ARR']; ?>">

                    </div>	
	
<?
if($_GET['A_ID']!="" && $data['A_SPACK']=="Haj 12")					
{ ?>
					
					<div class="form-group col-sm-11">	
					<label for="sel1">MIDDLE</label>
					</div>
					
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Middle Flight No:</label>

					   <input type="text" id="datepicker" class="form-control"  name="midfl" value="<?php echo $data['MID_FL']; ?>">

                    </div>	
					
				
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Middle Departure Saudi Time:</label>

					   <input type="text" id="datepicker" class="form-control"  name="middep" value="<?php echo $data['MID_DEP']; ?>">

                    </div>	

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

                      <label for="exampleInputEmail1">Middle Arrival Saudi Time:</label>

					   <input type="text" id="datepicker" class="form-control"  name="midarr" value="<?php echo $data['MID_ARR']; ?>">

                    </div>	
					
	
<? } ?>

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

                      <label for="exampleInputEmail1">PACKAGE INCLUDES <br>2nd Point:</label>

					   <input type="text" id="secpoi" class="form-control"  name="secpoi" value="<?php echo $data['SEC_POI']; ?>">

                    </div>	
					
					
					<?
if($data['A_PACK']!="Ziyarah")					
{ ?>
			<div id="pyes">		
					<div class="form-group col-sm-11">	
					<label for="sel1">MAKKAH DETAILS</label>
					</div>

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

                      <label for="exampleInputEmail1">Hotel Name:</label>

					   <input type="text" id="maknam" class="form-control"  name="maknam" value="<?php echo $data['MAK_NAM']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Address:</label>

					   <input type="text" id="makadd" class="form-control"  name="makadd" value="<?php echo $data['MAK_ADD']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Mobile Number:</label>

					   <input type="text" id="makmob" class="form-control"  name="makmob" value="<?php echo $data['MAK_MOB']; ?>">

                    </div>						
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Phone Number:</label>

					   <input type="text" id="makpho" class="form-control"  name="makpho" value="<?php echo $data['MAK_PHO']; ?>">

                    </div>						
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Fax Number:</label>

					   <input type="text" id="makfax" class="form-control"  name="makfax" value="<?php echo $data['MAK_FAX']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Website:</label>

					   <input type="text" id="makweb" class="form-control"  name="makweb" value="<?php echo $data['MAK_WEB']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Email:</label>

					   <input type="text" id="makmail" class="form-control"  name="makmail" value="<?php echo $data['MAK_MAIL']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Near Gait Number:</label>

					   <input type="text" id="makgait" class="form-control"  name="makgait" value="<?php echo $data['MAK_GAIT']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Haram Within:</label>

					   <input type="text" id="makhar" class="form-control"  name="makhar" value="<?php echo $data['MAK_HAR']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Stay at Makkah:</label>

					   <input type="text" id="makstay" class="form-control"  name="makstay" value="<?php echo $data['MAK_STAY']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">To And fro travel:</label>

					   <input type="text" id="makto" class="form-control"  name="makto" value="<?php echo $data['MAK_TO']; ?>">

                    </div>	


					
										
					<div class="form-group col-sm-11">	
					<label for="sel1">MADINAH DETAILS</label>
					</div>
									<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Name:</label>

					   <input type="text" id="madnam" class="form-control"  name="madnam" value="<?php echo $data['MAD_NAM']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Address:</label>

					   <input type="text" id="madadd" class="form-control"  name="madadd" value="<?php echo $data['MAD_ADD']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Mobile Number:</label>

					   <input type="text" id="madmob" class="form-control"  name="madmob" value="<?php echo $data['MAD_MOB']; ?>">

                    </div>						
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Phone Number:</label>

					   <input type="text" id="madpho" class="form-control"  name="madpho" value="<?php echo $data['MAD_PHO']; ?>">

                    </div>						
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Fax Number:</label>

					   <input type="text" id="madfax" class="form-control"  name="madfax" value="<?php echo $data['MAD_FAX']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Website:</label>

					   <input type="text" id="madweb" class="form-control"  name="madweb" value="<?php echo $data['MAD_WEB']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Email:</label>

					   <input type="text" id="madmail" class="form-control"  name="madmail" value="<?php echo $data['MAD_MAIL']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Near Gait Number:</label>

					   <input type="text" id="madgait" class="form-control"  name="madgait" value="<?php echo $data['MAD_GAIT']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Haram Within:</label>

					   <input type="text" id="madhar" class="form-control"  name="madhar" value="<?php echo $data['MAD_HAR']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Stay at Madinah:</label>

					   <input type="text" id="madstay" class="form-control"  name="madstay" value="<?php echo $data['MAD_STAY']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">To And fro travel:</label>

					   <input type="text" id="madto" class="form-control"  name="madto" value="<?php echo $data['MAD_TO']; ?>">

                    </div>	
</div>	
<? }?>					
<?
if($data['A_PACK']!="Umrah" && $data['A_PACK']!="Ramzan" && $data['A_PACK']!="Ziyarah Umrah" && $data['A_PACK']!="Ziyarah")					
{ ?>

	<div id="phaj">
					<div class="form-group col-sm-11">	
					<label for="sel1">AZIZIYAH DETAILS</label>
					</div>

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

                      <label for="exampleInputEmail1">Hotel Name:</label>

					   <input type="text" id="maknam" class="form-control"  name="azinam" value="<?php echo $data['AZI_NAM']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Address:</label>

					   <input type="text" id="makadd" class="form-control"  name="aziadd" value="<?php echo $data['AZI_ADD']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Mobile Number:</label>

					   <input type="text" id="makmob" class="form-control"  name="azimob" value="<?php echo $data['AZI_MOB']; ?>">

                    </div>						
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Phone Number:</label>

					   <input type="text" id="makpho" class="form-control"  name="azipho" value="<?php echo $data['AZI_PHO']; ?>">

                    </div>						
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Fax Number:</label>

					   <input type="text" id="makfax" class="form-control"  name="azifax" value="<?php echo $data['AZI_FAX']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Website:</label>

					   <input type="text" id="makweb" class="form-control"  name="aziweb" value="<?php echo $data['AZI_WEB']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Email:</label>

					   <input type="text" id="makmail" class="form-control"  name="azimail" value="<?php echo $data['AZI_MAIL']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Hotel Near Gait Number:</label>

					   <input type="text" id="makgait" class="form-control"  name="azigait" value="<?php echo $data['AZI_GAIT']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Haram Within:</label>

					   <input type="text" id="makhar" class="form-control"  name="azihar" value="<?php echo $data['AZI_HAR']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Stay at Azizyah:</label>

					   <input type="text" id="makstay" class="form-control"  name="azistay" value="<?php echo $data['AZI_STAY']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">To And fro travel:</label>

					   <input type="text" id="madto" class="form-control"  name="azito" value="<?php echo $data['AZI_TO']; ?>">

                    </div>	
									
					<div class="form-group col-sm-11">	
					<label for="sel1">MUALLIM/MUTTAWIFF DETAILS</label>
					</div>
					<div class="form-group col-sm-11">

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

					   <input type="text" id="madnam" class="form-control"  name="munam" value="<?php echo $data['MU_NAM']; ?>">

                    </div>
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Head Service Office No:</label>

					   <input type="text" id="madnam" class="form-control"  name="muser" value="<?php echo $data['MU_SER']; ?>">

                    </div>						
					<div class="form-group col-sm-11">

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

					   <input type="text" id="madadd" class="form-control"  name="muadd" value="<?php echo $data['MU_ADD']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Mobile Number:</label>

					   <input type="text" id="madmob" class="form-control"  name="mumob" value="<?php echo $data['MU_MOB']; ?>">

                    </div>						
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Phone Number:</label>

					   <input type="text" id="madpho" class="form-control"  name="mupho" value="<?php echo $data['MU_PHO']; ?>">

                    </div>						
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Fax Number:</label>

					   <input type="text" id="madfax" class="form-control"  name="mufax" value="<?php echo $data['MU_FAX']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

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

					   <input type="text" id="madweb" class="form-control"  name="muweb" value="<?php echo $data['MU_WEB']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

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

					   <input type="text" id="madmail" class="form-control"  name="mumail" value="<?php echo $data['MU_MAIL']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Mina to Jamarat within:</label>

					   <input type="text" id="madgait" class="form-control"  name="mugait" value="<?php echo $data['MU_GAIT']; ?>">

                    </div>	
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Stay at Mina:</label>

					   <input type="text" id="madstay" class="form-control"  name="mustay" value="<?php echo $data['MU_STAY']; ?>">

                    </div>	

				</div>		

<? }?>
   
<!-- <div class="form-group col-sm-11">
  <label for="sel1">No. of Seats Currently Avaiable</label>
   <button id="button12" type="button"  class ="button-click"><blink><?//echo $row['A_NOS']?></blink></button>
  </div>
  <div class="checkbox col-sm-11">
  <label><input type="checkbox" value="">I hereby accept to the Terms & Conditions.<a href="images/terms.pdf" target="_blank">click here</a></label>
  </div>-->
					
                  <div class="box-footer col-sm-11">

			        

                    <button type="submit" name="submit" value="submit" class="btn btn-primary">Submit</button>

					<button type="reset" class="btn btn-primary">Reset</button>

			

                  </div>


</form>

		</div>

</div>

</div>

</div>

</section>

<hr>


	<!--		 <section class="content" >

          <div class="row">

 

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


              <div class="box box-primary">


			<div class="container">

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

                      <label for="exampleInputEmail1">Total packdet Seats:</label>
					<?php 
				//	$query2=mysql_query("select SUM(A_SEAT) AS T_SEAT  from packdet");
				//	while($row2=mysql_fetch_assoc($query2)) {?>

					<button id="button12" type="button"  class ="button-click"><blink><?php// echo $row2['T_SEAT']; ?></blink></button>
					<?// } ?>
                    </div>


		</div>

</div>

</div>

</div>

</section>-->












		<div class="row" style="position: absolute;width:100%;">

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

				<div class="panel panel-default">

					<div class="panel-heading">Package Details Data Table</div>

					


				
					
					<div class="panel-body bottom">

						<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="id" data-sortable="false">Item ID</th>

						        <th data-field="sname"  data-sortable="true">Package</th>
								
						        <th data-field="spack"  data-sortable="true">SubPakage</th>

						        <th data-field="clas"  data-sortable="true">Class</th>								

								<th data-field="sstatus" data-sortable="true">Status</th>

								<th data-field="saction" data-sortable="true">Action</th>

						    </tr>

						    </thead>

							<tbody>

							<?php 

							

                            $table = mysql_query("select * from packdet");

							$A_ID=1;

							while($row=mysql_fetch_array($table))

							{

							?>

							   <tr> <td></td>

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

							   <td><?php echo $row['A_PACK'];?></td>
							   
							   <td><?php echo $row['A_SPACK'];?></td>
							   
							   <td><?php echo $row['A_CLS'];?></td>							   

							   <td><a href= "mg_package.php?A_ID=<?php echo $row['A_ID'];?>">Edit</a>/<a href="#" onclick="del(<?php echo $row['A_ID'];?>)">Delete</a></td>

							   <td><?php if($row['A_STS']==1) {?> <a href = "mg_package.php?A_STS=0&SAI=<?php echo $row['A_ID'];?>">Active</a> <?php } else {?> <a href = "mg_package.php?A_STS=1&SAI=<?php echo $row['A_ID'];?>">InActive </a> <?php } ?></td>

							   </tr>

                                

								

                                

                            <?php

							  $A_ID++;

							 }?>

							</tbody>

							

							

						</table>

					</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();

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

    });
});
	</script>
<script>
$('.top').on('click', function() {
	$parent_box = $(this).closest('.box');
	$parent_box.siblings().find('.bottom').hide();
	$parent_box.find('.bottom').toggle();
});
</script>
<style>
.container .box {
width:auto;
max-width:900px;
}

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

.container .box .bottom {

  display: none;
}
</style>
</body>



</html>