One Hat Cyber Team

View File Name : mg_stupdate.php


<?php include('config.php'); 

 error_reporting(0); 
 $id =  $_GET['id'];
 $view = mysql_query("select * from newstatus where id = '".$id."'"); // for editing

$data = mysql_fetch_array($view);


if($_POST['submit']){
      

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

		      $reg_no = mysql_real_escape_string($_POST['reg_no']);
			  
			  $status = mysql_real_escape_string($_POST['status']); 
	
			  $for = mysql_real_escape_string($_POST['for']); 
			  
			  $forsub = mysql_real_escape_string($_POST['forsub']); 			  
			  
			  $package = mysql_real_escape_string($_POST['package']); 

			  $name = mysql_real_escape_string($_POST['name']); 
			  
			  $passportno = mysql_real_escape_string($_POST['passportno']); 
	 
			  $sex = mysql_real_escape_string($_POST['sex']); 
	 
			  $dob = mysql_real_escape_string($_POST['dob']); 
			  
			  $address = mysql_real_escape_string($_POST['address']); 			  
			  
	  		  $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['id']!=""){
		
				   

		   	 $upd =  mysql_query("update newstatus set app_id='$app_id',reg_no='$reg_no',status='$status',for1='$for',package='$forsub',surname='$package',name='$name',passportno='$passportno',sex='$sex',dob='$dob',address='$address',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 id ='".$id."'");

								

					if($upd){?>

			<script>alert("updated sucessfully");

			window.location ="mg_stupdate.php"

			</script>

			<?php }

			if(!$upd){?>

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

			window.location ="mg_stupdate.php"

			</script>

			<?php }		

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

 

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

if($del){?>

                       <script>

						alert("Status deleted sucessfully");

						window.location= "mg_stupdate.php";

						</script>

<?php }

if(!$del){?>

                       <script>

						alert("Status  not deleted sucessfully");

						window.location= "mg_stupdate.php";

						</script>

<?php }   



} ?>
 
<script>

function del(id){

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

  if(del){

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

  }

  else{

  window.location.href = "mg_stupdate.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]-->



</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>



<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">Status Update Details</li>

			</ol>

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

		
<section class="content" style="position: absolute;top: 250px;">
		<div class="row">

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

				<h2 class="page-header">Status Details</h2>

			</div>

		</div><!--/.row-->
		
		
	<form role="form" method="post" action="" enctype="multipart/form-data">
					<div class="form-group col-sm-11">

                      <label for="exampleInputEmail1">Application Form No:</label>

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

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

                      <label for="exampleInputEmail1">Online Registration No:</label>

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

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

                      <label for="exampleInputEmail1">Approved Status Details :</label>		
						<select name="status" class="form-control" id="status">
					<option selected="selected" value="<?php echo $data['status'];?>"><?php echo $data['status'];?></option>
						<option  value="On Process">On Process</option>

						<option value="Confirmed">Confirmed</option>

						<option value="Waiting List">Waiting List</option>

						<option value="Decline">Decline</option>

						</select>

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

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

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

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

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

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

                    </div>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

                    </div>	

					<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>	
<?
if($data['for1']!="Umarah")
{
	?>

					<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 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">Near Gait Number:</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 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>	
		
		</section>
		
		
		
		
		
	
		<div class="row" style="position: absolute;width:100%">

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

				<div class="panel panel-default">

					<div class="panel-heading">Updated Status Table List</div>
					

					

					<div class="container">
					
					
						<?php 
					$queryear=mysql_query("select *  from year ORDER BY Y_LIST DESC");
					while($rowyear=mysql_fetch_array($queryear)) {?>		
					
					<div class="box">
					<div class="top">
					<?php echo $yr=$rowyear['Y_LIST'];?>
					</div>
					<hr>
					<?php 
					$querypak=mysql_query("select *  from package");
					while($rowpak=mysql_fetch_array($querypak)) {?>	
			

			
					<div class="panel-body bottom">
<div class="box1">
<h4 style="color:red;" class="top1"><?php echo $pk=$rowpak['P_NAME'];?></h4>
<div class="panel-body bottom1">		
		
		
		


						<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="true">Item ID</th>

						        <th data-field="appid"  data-sortable="true">App ID</th>

								<th data-field="sname" data-sortable="true">Name</th>

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


						    </tr>

						    </thead>

							<tbody>

							<?php 

							

                            $table = mysql_query("select * from newstatus where date like '$yr-%-%' AND for1='$pk' ORDER BY app_id DESC");

							$id=1;

							while($row=mysql_fetch_array($table))

							{

							?>

							   <tr> <td></td>

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

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

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

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

							   </tr>

                                

								

                                

                            <?php

							  $id++;

							 }?>

							</tbody>

							

							

						</table>

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

		</div>


 	</div>

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

	</div>
	
	
	
	
	<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();
});
$('.top1').on('click', function() {
	$parent_box = $(this).closest('.box1');
	$parent_box.siblings().find('.bottom1').hide();
	$parent_box.find('.bottom1').toggle();
});
</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:250px;
}

.container .box1 {
width:100%;
max-width:250px;
}
}
</style>
</body>



</html>