One Hat Cyber Team
Your IP :
216.73.216.240
Server IP :
162.240.106.28
Server :
Linux server.ganesand.com 3.10.0-1160.80.1.el7.x86_64 #1 SMP Tue Nov 8 15:48:59 UTC 2022 x86_64
Server Software :
Apache
PHP Version :
7.1.33
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
home
/
thoa
/
www
/
admin
/
Edit File:
mg_avaiable.php
<?php include('config.php'); $avai = mysql_query("select * from available"); $row = mysql_fetch_array($avai); ?> <?php /* $con = mysql_connect('localhost', 'root', ''); mysql_select_db("ecomm", $con); */ error_reporting(0); ?> <?php $AP_ID = $_GET['AP_ID']; $view = mysql_query("select * from newapplication where AP_ID = '".$AP_ID."'"); // for editing $data = mysql_fetch_array($view); if($_GET['SAI']){ $STS = $_GET['AP_STS']; if($STS == 0){ $upd_sts = mysql_query("UPDATE newapplication SET AP_STS ='0' WHERE AP_ID ='".$_GET['SAI']."'"); //for changing status } else{ $upd_sts = mysql_query("UPDATE newapplication SET AP_STS ='1' WHERE AP_ID ='".$_GET['SAI']."'"); } } if($_GET['del_id']){ ?> <?php $del = mysql_query("delete from newapplication where AP_ID='".$_GET['del_id']."'"); //for deleting status if($del){?> <script> alert("Register detail deleted sucessfully"); window.location= "mg_reg.php"; </script> <?php } if(!$del){?> <script> alert("Register detail Not deleted sucessfully"); window.location= "mg_reg.php"; </script> <?php } } if($_POST['submit']){ $apno = mysql_real_escape_string($_POST['apno']); $regno = mysql_real_escape_string($_POST['regno']); $appdate = mysql_real_escape_string($_POST['appdate']); $apimg = ($_FILES['apimg']['name']); $tmp_img = $_FILES['apimg']['tmp_name']; move_uploaded_file($tmp_img, "images/".$apimg); $apsel = mysql_real_escape_string($_POST['apsel']); $subcat = mysql_real_escape_string($_POST['subcat']); $clas = mysql_real_escape_string($_POST['clas']); $apname = mysql_real_escape_string($_POST['apname']); $apgen = mysql_real_escape_string($_POST['apgen']); $apms = mysql_real_escape_string($_POST['apms']); $apdob = mysql_real_escape_string($_POST['apdob']); $apage = mysql_real_escape_string($_POST['apage']); $apfat = mysql_real_escape_string($_POST['apfat']); $apmot = mysql_real_escape_string($_POST['apmot']); $aphw = mysql_real_escape_string($_POST['aphw']); $apheg = mysql_real_escape_string($_POST['apheg']); $apweg = mysql_real_escape_string($_POST['apweg']); $apblood = mysql_real_escape_string($_POST['apblood']); $apvis = mysql_real_escape_string($_POST['apvis']); $apprs = mysql_real_escape_string($_POST['apprs']); $apprv = mysql_real_escape_string($_POST['apprv']); $apadd = mysql_real_escape_string($_POST['apadd']); $apland = mysql_real_escape_string($_POST['apland']); $apcity = mysql_real_escape_string($_POST['apcity']); $aptal = mysql_real_escape_string($_POST['aptal']); $apdis = mysql_real_escape_string($_POST['apdis']); $apstate = mysql_real_escape_string($_POST['apstate']); $apcou = mysql_real_escape_string($_POST['apcou']); $appcod = mysql_real_escape_string($_POST['appcod']); $aptel = mysql_real_escape_string($_POST['aptel']); $apmail = mysql_real_escape_string($_POST['apmail']); $apmname = mysql_real_escape_string($_POST['apmname']); $apmrel = mysql_real_escape_string($_POST['apmrel']); $imgpass = ($_FILES['imgpass']['name']); $tmp_img = $_FILES['imgpass']['tmp_name']; move_uploaded_file($tmp_img, "images/".$imgpass); $imgvisa = ($_FILES['imgvisa']['name']); $tmp_img = $_FILES['imgvisa']['tmp_name']; move_uploaded_file($tmp_img, "images/".$imgvisa); $imgair = ($_FILES['imgair']['name']); $tmp_img = $_FILES['imgair']['tmp_name']; move_uploaded_file($tmp_img, "images/".$imgair); $pahav = mysql_real_escape_string($_POST['pahav']); $pastatus = mysql_real_escape_string($_POST['pastatus']); $pano = mysql_real_escape_string($_POST['pano']); $pasur = mysql_real_escape_string($_POST['pasur']); $pagname = mysql_real_escape_string($_POST['pagname']); $panat = mysql_real_escape_string($_POST['panat']); $pasex = mysql_real_escape_string($_POST['pasex']); $padob = mysql_real_escape_string($_POST['padob']); $papob = mysql_real_escape_string($_POST['papob']); $papoi = mysql_real_escape_string($_POST['papoi']); $padoi = mysql_real_escape_string($_POST['padoi']); $padoe = mysql_real_escape_string($_POST['padoe']); $pafat = mysql_real_escape_string($_POST['pafat']); $pamot = mysql_real_escape_string($_POST['pamot']); $paspo = mysql_real_escape_string($_POST['paspo']); $paadd = mysql_real_escape_string($_POST['paadd']); $papcode = mysql_real_escape_string($_POST['papcode']); $othav = mysql_real_escape_string($_POST['othav']); $otsta = mysql_real_escape_string($_POST['otsta']); $otadat = mysql_real_escape_string($_POST['otadat']); $otfile = mysql_real_escape_string($_POST['otfile']); $otsel = mysql_real_escape_string($_POST['otsel']); $otsur = mysql_real_escape_string($_POST['otsur']); $otgnam = mysql_real_escape_string($_POST['otgnam']); $otnat = mysql_real_escape_string($_POST['otnat']); $otsex = mysql_real_escape_string($_POST['otsex']); $otdob = mysql_real_escape_string($_POST['otdob']); $otocc = mysql_real_escape_string($_POST['otocc']); $otpob = mysql_real_escape_string($_POST['otpob']); $otpoi = mysql_real_escape_string($_POST['otpoi']); $otdoi = mysql_real_escape_string($_POST['otdoi']); $otdoe = mysql_real_escape_string($_POST['otdoe']); $otfat = mysql_real_escape_string($_POST['otfat']); $otmot = mysql_real_escape_string($_POST['otmot']); $otadd = mysql_real_escape_string($_POST['otadd']); $otas = mysql_real_escape_string($_POST['otas']); $noname = mysql_real_escape_string($_POST['noname']); $noadd = mysql_real_escape_string($_POST['noadd']); $noland = mysql_real_escape_string($_POST['noland']); $nocity = mysql_real_escape_string($_POST['nocity']); $notal = mysql_real_escape_string($_POST['notal']); $nodis = mysql_real_escape_string($_POST['nodis']); $nostate = mysql_real_escape_string($_POST['nostate']); $nocou = mysql_real_escape_string($_POST['nocou']); $nopcod = mysql_real_escape_string($_POST['nopcod']); $nomob = mysql_real_escape_string($_POST['nomob']); $notel = mysql_real_escape_string($_POST['notel']); $nomail = mysql_real_escape_string($_POST['nomail']); $nocper = mysql_real_escape_string($_POST['nocper']); $nonrel = mysql_real_escape_string($_POST['nonrel']); if($_GET['AP_ID']==""){ $ins = mysql_query("insert into newapplication (AP_NO,REG_NO,APP_DATE,AP_IMG,AP_SEL,AP_SUBSEL,AP_NAME,AP_GEN,AP_DOB,AP_AGE,AP_FAT,AP_MOT,AP_HW,AP_MS,AP_HEG,AP_WEG,AP_BLOOD,AP_VIS,AP_PRS,AP_PRV,AP_ADD,AP_LAND,AP_CITY,AP_TAL,AP_DIS,AP_STATE,AP_COU,AP_PCOD,AP_TEL,AP_MAIL,AP_MNAME,AP_MREL,IMG_PASS,IMG_VISA,IMG_AIR,PA_HAV,PA_STATUS,PA_NO,PA_SUR,PA_GNAME,PA_NAT,PA_SEX,PA_DOB,PA_POB,PA_POI,PA_DOI,PA_DOE,PA_FAT,PA_MOT,PA_SPO,PA_ADD,PA_PCODE,NO_NAME,NO_ADD,NO_LAND,NO_CITY,NO_TAL,NO_DIS,NO_STATE,NO_COU,NO_PCOD,NO_MOB,NO_TEL,NO_MAIL,NO_CPER,NO_NREL,OT_HAV,OT_STA,OT_ADAT,OT_FILE,OT_SEL,OT_SUR,OT_GNAM,OT_NAT,OT_SEX,OT_DOB,OT_OCC,OT_POB,OT_POI,OT_DOI,OT_DOE,OT_FAT,OT_MOT,OT_ADD,OT_AS,U_ID) values ('$apno','$regno','$appdate','$apimg','$apsel','$subcat','$apname','$apgen','$apdob','$apage','$apfat','$apmot','$aphw','$apms','$apheg','$apweg','$apblood','$apvis','$apprs','$apprv','$apadd','$apland','$apcity','$aptal','$apdis','$apstate','$apcou','$appcod','$aptel','$apmail','$apmname','$apmrel','$imgpass','$imgvisa','$imgair','$pahav','$pastatus','$pano','$pasur','$pagname','$panat','$pasex','$padob','$papob','$papoi','$padoi','$padoe','$pafat','$pamot','$paspo','$paadd','$papcode','$noname','$noadd','$noland','$nocity','$notal','$nodis','$nostate','$nocou','$nopcod','$nomob','$notel','$nomail','$nocper','$nonrel','$othav','$otsta','$otadat','$otfile','$otsel','$otsur','$otgnam','$otnat','$otsex','$otdob','$otocc','$otpob','$otpoi','$otdoi','$otdoe','$otfat','$otmot','$otadd','$otas','$uid')"); ?><script>alert("Inserted sucessfully"); </script><? } if($_GET['AP_ID']!=""){ { if($_FILES['imgpass']['name']!="" && $_FILES['apimg']['name']!="") { $upd = mysql_query("update newapplication set AP_NO='$apno',REG_NO='$regno',APP_DATE='$appdate',AP_IMG='$apimg',AP_SEL='$apsel',AP_SUBSEL='$subcat',AP_NAME='$apname',AP_GEN='$apgen',AP_DOB='$apdob',AP_AGE='$apage',AP_FAT='$apfat',AP_MOT='$apmot',AP_HW='$aphw',AP_MS='$apms',AP_HEG='$apheg',AP_WEG='$apweg',AP_BLOOD='$apblood',AP_VIS='$apvis',AP_PRS='$apprs',AP_PRV='$apprv',AP_ADD='$apadd',AP_LAND='$apland',AP_CITY='$apcity',AP_TAL='$aptal',AP_DIS='$apdis',AP_STATE='$apstate',AP_COU='$apcou',AP_PCOD='$appcod',AP_TEL='$aptel',AP_MAIL='$apmail',AP_MNAME='$apmname',AP_MREL='$apmrel',IMG_PASS='$imgpass',PA_HAV='$pahav',PA_STATUS='$pastatus',PA_NO='$pano',PA_SUR='$pasur',PA_GNAME='$pagname',PA_NAT='$panat',PA_SEX='$pasex',PA_DOB='$padob',PA_POB='$papob',PA_POI='$papoi',PA_DOI='$padoi',PA_DOE='$padoe',PA_FAT='$pafat',PA_MOT='$pamot',PA_SPO='$paspo',PA_ADD='$paadd',PA_PCODE='$papcode',NO_NAME='$noname',NO_ADD='$noadd',NO_LAND='$noland',NO_CITY='$nocity',NO_TAL='$notal',NO_DIS='$nodis',NO_STATE='$nostate',NO_COU='$nocou',NO_PCOD='$nopcod',NO_MOB='$nomob',NO_TEL='$notel',NO_MAIL='$nomail',NO_CPER='$nocper',NO_NREL='$nonrel',OT_HAV='$othav',OT_STA='$otsta',OT_ADAT='$otadat',OT_FILE='$otfile',OT_SEL='$otsel',OT_SUR='$otsur',OT_GNAM='$otgnam',OT_NAT='$otnat',OT_SEX='$otsex',OT_DOB='$otdob',OT_OCC='$otocc',OT_POB='$otpob',OT_POI='$otpoi',OT_DOI='$otdoi',OT_DOE='$otdoe',OT_FAT='$otfat',OT_MOT='$otmot',OT_ADD='$otadd',OT_AS='$otas',U_ID='$uid' WHERE AP_ID ='".$AP_ID."'"); } elseif($_FILES['imgpass']['name']!="") { $upd = mysql_query("update newapplication set AP_NO='$apno',REG_NO='$regno',APP_DATE='$appdate',AP_SEL='$apsel',AP_SUBSEL='$subcat',AP_NAME='$apname',AP_GEN='$apgen',AP_DOB='$apdob',AP_AGE='$apage',AP_FAT='$apfat',AP_MOT='$apmot',AP_HW='$aphw',AP_MS='$apms',AP_HEG='$apheg',AP_WEG='$apweg',AP_BLOOD='$apblood',AP_VIS='$apvis',AP_PRS='$apprs',AP_PRV='$apprv',AP_ADD='$apadd',AP_LAND='$apland',AP_CITY='$apcity',AP_TAL='$aptal',AP_DIS='$apdis',AP_STATE='$apstate',AP_COU='$apcou',AP_PCOD='$appcod',AP_TEL='$aptel',AP_MAIL='$apmail',AP_MNAME='$apmname',AP_MREL='$apmrel',IMG_PASS='$imgpass',PA_HAV='$pahav',PA_STATUS='$pastatus',PA_NO='$pano',PA_SUR='$pasur',PA_GNAME='$pagname',PA_NAT='$panat',PA_SEX='$pasex',PA_DOB='$padob',PA_POB='$papob',PA_POI='$papoi',PA_DOI='$padoi',PA_DOE='$padoe',PA_FAT='$pafat',PA_MOT='$pamot',PA_SPO='$paspo',PA_ADD='$paadd',PA_PCODE='$papcode',NO_NAME='$noname',NO_ADD='$noadd',NO_LAND='$noland',NO_CITY='$nocity',NO_TAL='$notal',NO_DIS='$nodis',NO_STATE='$nostate',NO_COU='$nocou',NO_PCOD='$nopcod',NO_MOB='$nomob',NO_TEL='$notel',NO_MAIL='$nomail',NO_CPER='$nocper',NO_NREL='$nonrel',OT_HAV='$othav',OT_STA='$otsta',OT_ADAT='$otadat',OT_FILE='$otfile',OT_SEL='$otsel',OT_SUR='$otsur',OT_GNAM='$otgnam',OT_NAT='$otnat',OT_SEX='$otsex',OT_DOB='$otdob',OT_OCC='$otocc',OT_POB='$otpob',OT_POI='$otpoi',OT_DOI='$otdoi',OT_DOE='$otdoe',OT_FAT='$otfat',OT_MOT='$otmot',OT_ADD='$otadd',OT_AS='$otas',U_ID='$uid' WHERE AP_ID ='".$AP_ID."'"); } elseif($_FILES['apimg']['name']!="") { $upd = mysql_query("update newapplication set AP_NO='$apno',REG_NO='$regno',APP_DATE='$appdate',AP_IMG='$apimg',AP_SEL='$apsel',AP_SUBSEL='$subcat',AP_NAME='$apname',AP_GEN='$apgen',AP_DOB='$apdob',AP_AGE='$apage',AP_FAT='$apfat',AP_MOT='$apmot',AP_HW='$aphw',AP_MS='$apms',AP_HEG='$apheg',AP_WEG='$apweg',AP_BLOOD='$apblood',AP_VIS='$apvis',AP_PRS='$apprs',AP_PRV='$apprv',AP_ADD='$apadd',AP_LAND='$apland',AP_CITY='$apcity',AP_TAL='$aptal',AP_DIS='$apdis',AP_STATE='$apstate',AP_COU='$apcou',AP_PCOD='$appcod',AP_TEL='$aptel',AP_MAIL='$apmail',AP_MNAME='$apmname',AP_MREL='$apmrel',PA_HAV='$pahav',PA_STATUS='$pastatus',PA_NO='$pano',PA_SUR='$pasur',PA_GNAME='$pagname',PA_NAT='$panat',PA_SEX='$pasex',PA_DOB='$padob',PA_POB='$papob',PA_POI='$papoi',PA_DOI='$padoi',PA_DOE='$padoe',PA_FAT='$pafat',PA_MOT='$pamot',PA_SPO='$paspo',PA_ADD='$paadd',PA_PCODE='$papcode',NO_NAME='$noname',NO_ADD='$noadd',NO_LAND='$noland',NO_CITY='$nocity',NO_TAL='$notal',NO_DIS='$nodis',NO_STATE='$nostate',NO_COU='$nocou',NO_PCOD='$nopcod',NO_MOB='$nomob',NO_TEL='$notel',NO_MAIL='$nomail',NO_CPER='$nocper',NO_NREL='$nonrel',OT_HAV='$othav',OT_STA='$otsta',OT_ADAT='$otadat',OT_FILE='$otfile',OT_SEL='$otsel',OT_SUR='$otsur',OT_GNAM='$otgnam',OT_NAT='$otnat',OT_SEX='$otsex',OT_DOB='$otdob',OT_OCC='$otocc',OT_POB='$otpob',OT_POI='$otpoi',OT_DOI='$otdoi',OT_DOE='$otdoe',OT_FAT='$otfat',OT_MOT='$otmot',OT_ADD='$otadd',OT_AS='$otas',U_ID='$uid' WHERE AP_ID ='".$AP_ID."'"); } else { $upd = mysql_query("update newapplication set AP_NO='$apno',REG_NO='$regno',APP_DATE='$appdate',AP_SEL='$apsel',AP_SUBSEL='$subcat',AP_NAME='$apname',AP_GEN='$apgen',AP_DOB='$apdob',AP_AGE='$apage',AP_FAT='$apfat',AP_MOT='$apmot',AP_HW='$aphw',AP_MS='$apms',AP_HEG='$apheg',AP_WEG='$apweg',AP_BLOOD='$apblood',AP_VIS='$apvis',AP_PRS='$apprs',AP_PRV='$apprv',AP_ADD='$apadd',AP_LAND='$apland',AP_CITY='$apcity',AP_TAL='$aptal',AP_DIS='$apdis',AP_STATE='$apstate',AP_COU='$apcou',AP_PCOD='$appcod',AP_TEL='$aptel',AP_MAIL='$apmail',AP_MNAME='$apmname',AP_MREL='$apmrel',PA_HAV='$pahav',PA_STATUS='$pastatus',PA_NO='$pano',PA_SUR='$pasur',PA_GNAME='$pagname',PA_NAT='$panat',PA_SEX='$pasex',PA_DOB='$padob',PA_POB='$papob',PA_POI='$papoi',PA_DOI='$padoi',PA_DOE='$padoe',PA_FAT='$pafat',PA_MOT='$pamot',PA_SPO='$paspo',PA_ADD='$paadd',PA_PCODE='$papcode',NO_NAME='$noname',NO_ADD='$noadd',NO_LAND='$noland',NO_CITY='$nocity',NO_TAL='$notal',NO_DIS='$nodis',NO_STATE='$nostate',NO_COU='$nocou',NO_PCOD='$nopcod',NO_MOB='$nomob',NO_TEL='$notel',NO_MAIL='$nomail',NO_CPER='$nocper',NO_NREL='$nonrel',OT_HAV='$othav',OT_STA='$otsta',OT_ADAT='$otadat',OT_FILE='$otfile',OT_SEL='$otsel',OT_SUR='$otsur',OT_GNAM='$otgnam',OT_NAT='$otnat',OT_SEX='$otsex',OT_DOB='$otdob',OT_OCC='$otocc',OT_POB='$otpob',OT_POI='$otpoi',OT_DOI='$otdoi',OT_DOE='$otdoe',OT_FAT='$otfat',OT_MOT='$otmot',OT_ADD='$otadd',OT_AS='$otas',U_ID='$uid' WHERE AP_ID ='".$AP_ID."'"); } } if($upd){?> <script>alert("updated sucessfully"); window.location ="mg_reg.php" </script> <?php } if(!$upd){?> <script>alert("Not updated sucessfully"); window.location ="mg_reg.php" </script> <?php } } } ?> <script> function del(id){ var del = confirm("Are you sure Want to delete"); if(del){ window.location.href = "mg_reg.php?del_id="+id+"&del=1"; } else{ window.location.href = "mg_reg.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"> <!--[if lt IE 9]> <script src="js/html5shiv.js"></script> <script src="js/respond.min.js"></script> <![endif]--> <script> function showUser(str) { $.ajax({ type: "GET", url: "getsub.php?q="+str, success: function(result){ $("#subcat").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", 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> <script> $(document).ready(function() { $("#pyes").hide(); $("#pno").hide(); $("#cno").hide(); $("#cyes").hide(); $("#scard").hide(); }); function extra(val){ if(val == 'yes'){ $("#pno").hide(); $("#pyes").show(); } else if(val == 'no'){ $("#pyes").hide(); $("#pno").show(); } } function cextra(val){ if(val == 'yes'){ $("#cno").hide(); $("#cyes").show(); } else if(val == 'no'){ $("#cyes").hide(); $("#cno").show(); } } function sextra(val){ if(val == 'tak'){ $("#scard").show(); } else if(val == 'ord'){ $("#scard").show(); } else if(val == 'not'){ $("#scard").hide(); } } </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"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </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="#"><span class="glyphicon glyphicon-home"></span></a></li> <li class="active">Manage Register Details</li> </ol> </div><!--/.row--> <div class="row"> <div class="col-lg-12"> <h2 class="page-header">Add New Register Details</h2> </div> </div><!--/.row--> <section class="content"> <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="exampleInputEmail1">Online Application No:</label> <input type="text" class="form-control" id="apno" name="apno" value="<?php echo $data['AP_NO']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">Online Registration No:</label> <input type="text" class="form-control" id="regno" name="regno" value="<?php echo $data['REG_NO']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">Applied Date:</label> <?php if($AP_ID){?> <input type="date" class="form-control" id="demo" name="appdate" value="<?php echo $data['APP_DATE']; ?>"> <?php } else {?> <input type="date" class="form-control" id="demo" name="appdate" value="<?php echo date('Y-m-d') ?>"> <?php }?> </div> <div class="form-group col-sm-11"> <label for="exampleInputFile">Upload your passport size photograph:</label> <input type="file" name="apimg" id="exampleInputFile"> <?php if($AP_ID){?> <img src = "images/<?php echo $data['AP_IMG'];?>" height="100" width="100"></img> <?php }?> <label for="exampleInputFile">(Size:5 MB Max, Format:.jpg,.png)</label> </div> <div class="form-group col-sm-11"> <label for="sel1">Select Package:</label> <? if($AP_ID) {?> <select id="apsel" name="apsel" class="form-control" onchange="showUser(this.value)"> <?php $query1=mysql_query("select * from newapplication where AP_ID = '".$AP_ID."'"); while($row1=mysql_fetch_array($query1)) {?> <option value="<?php echo $row1['AP_SEL'];?>"><?php echo $row1['AP_SEL'];?></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($AP_ID) {?> <select id="subcat" name="subcat" class="form-control"> <?php $query1=mysql_query("select * from newapplication where AP_ID = '".$AP_ID."'"); while($row1=mysql_fetch_array($query1)) {?> <option value="<?php echo $row1['AP_SUBSEL'];?>"><?php echo $row1['AP_SUBSEL'];?></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($AP_ID && $data['AP_CLS']!="") {?> <select id="clas" name="clas" class="form-control"> <?php $queryc=mysql_query("select * from class where C_NAME='".$data['AP_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">Name In Full:</label> <input type="text" class="form-control" id="apname" name="apname" value="<?php echo $data['AP_NAME']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Gender:</label> <? if($AP_ID) {?> <select class="form-control" id="apgen" name="apgen"> <option value="<?php echo $data['AP_GEN']; ?>"><?php echo $data['AP_GEN']; ?></option> </select> <?}else{?> <select class="form-control" id="apgen" name="apgen"> <option value="Male">Male</option> <option value="Female">Female</option> </select> <? }?> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">DOB:</label> <input type="date" class="form-control" id="apdob" name="apdob" value="<?php echo $data['AP_DOB']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">Age:</label> <input type="text" class="form-control" id="apage" name="apage" value="<?php echo $data['AP_AGE']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">FATHER/LEGAL GUARDIAN'S FULL NAME : (INCLUDING SURNAME, IF ANY) (Initials not allowed) :</label> <input type="text" class="form-control" id="apfat" name="apfat" value="<?php echo $data['AP_FAT']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1"> MOTHER’S FULL NAME (INCLUDING SURNAME, IF ANY) (Initials not allowed) :</label> <input type="text" class="form-control" id="apmot" name="apmot" value="<?php echo $data['AP_MOT']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1"> IF MARRIED, FULL NAME OF WIFE/HUSBAND (INCLUDING SURNAME, IF ANY) (Initials not allowed).</label> <input type="text" class="form-control" id="aphw" name="aphw" value="<?php echo $data['AP_HW']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Marital Status </label> <? if($AP_ID) {?> <select class="form-control" id="apms" name="apms"> <option value="<?php echo $data['AP_MS']; ?>"><?php echo $data['AP_MS']; ?></option> </select> <?}else{?> <select class="form-control" id="apms" name="apms"> <option value="Single">Single</option> <option value="Married">Married</option> </select> <? } ?> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">Height(cms): </label> <input type="text" class="form-control" id="apheg" name="apheg" value="<?php echo $data['AP_HEG']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">Weight(Kg): </label> <input type="text" class="form-control" id="apweg" name="apweg" value="<?php echo $data['AP_WEG']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Blood Group: </label> <? if($AP_ID) {?> <select class="form-control" id="apblood" name="apblood" > <option value="<?php echo $data['AP_BLOOD']; ?>"><?php echo $data['AP_BLOOD']; ?></option> </select> <?}else{?> <select class="form-control" id="apblood" name="apblood" > <option value="A+">A+</option> <option value="A-">A-</option> <option value="B+">B+</option> <option value="B-">B-</option> <option value="AB+">AB+</option> <option value="AB-">AB-</option> <option value="O+">O+</option> <option value="O-">O-</option> </select> <? } ?> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">Visible Distinguishing Mark, If any :</label> <textarea class="form-control" rows="5" id="apvis" name="apvis"><?php echo $data['AP_VIS']; ?></textarea> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">Present Nationality :</label> <input type="text" class="form-control" id="apprs" name="apprs" value="<?php echo $data['AP_PRS']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">Previous Nationality :</label> <input type="text" class="form-control" id="apprv" name="apprv" value="<?php echo $data['AP_PRV']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">Permanent Residence Address </label> <textarea class="form-control" rows="5" id="apadd" name="apadd"><?php echo $data['AP_ADD']; ?></textarea> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">LandMark :</label> <input type="text" class="form-control" id="apland" name="apland" value="<?php echo $data['AP_LAND']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">City :</label> <input type="text" class="form-control" id="apcity" name="apcity" value="<?php echo $data['AP_CITY']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">Taluk : </label> <input type="text" class="form-control" id="aptal" name="aptal" value="<?php echo $data['AP_TAL']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">District : </label> <input type="text" class="form-control" id="apdis" name="apdis" value="<?php echo $data['AP_DIS']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">State : </label> <input type="text" class="form-control" id="apstate" name="apstate" value="<?php echo $data['AP_STATE']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">Country: </label> <input type="text" class="form-control" id="apcou" name="apcou" value="<?php echo $data['AP_COU']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">ZIP Code / Foreign Postal Code : </label> <input type="text" class="form-control" id="appcod" name="appcod" value="<?php echo $data['AP_PCOD']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">TELEPHONE NUMBER WITH AREA CODE ISD / STD : </label> <input type="text" class="form-control" id="aptel" name="aptel" value="<?php echo $data['AP_TEL']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">Email Id: </label> <input type="email" class="form-control" id="apmail" name="apmail" value="<?php echo $data['AP_MAIL']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">MAHARAM NAME (LADIES ONLY): </label> <input type="text" class="form-control" id="apmname" name="apmname" value="<?php echo $data['AP_MNAME']; ?>"> </div> <div class="form-group col-sm-11"> <label for="exampleInputEmail1">MAHRAM RELATIONSHIP: </label> <input type="text" class="form-control" id="apmrel" name="apmrel" value="<?php echo $data['AP_MREL']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Upload Passport Front and Back: </label> <input type="file" class="" id="imgpass" name="imgpass"> <?php if($AP_ID){?> <img src = "images/<?php echo $data['IMG_PASS'];?>" height="100" width="100"></img> <?php }?> <label for="exampleInputFile">(Size: 5 MB Max, Format: .jpg,.png)</label> </div> <br> <h4 class="form-group col-sm-11">Passport Details</h4> <div class="form-group col-sm-11"> <label for="sel1">Whether having valid Passport: </label> <? if($AP_ID) {?> <select class="form-control" id="pport" name="pahav" onload="extra(this.value)"> <option value="<?php echo $data['PA_HAV']; ?>"><?php echo $data['PA_HAV']; ?></option> </select> <?php } else { ?> <select class="form-control" id="pport" name="pahav" onchange="extra(this.value)"> <option value="yes">Yes</option> <option value="no">No</option> </select> <?php }?> </div> <div id="pno"> <div class="form-group col-sm-11"> <label for="sel1">If No Status of Passport:</label> <? if($AP_ID) {?> <select class="form-control" id="pastatus" name="pastatus"> <option value="<?php echo $data['PA_STATUS']; ?>"><?php echo $data['PA_STATUS']; ?></option> </select> <?php } else { ?> <select class="form-control" id="pastatus" name="pastatus"> <option value="takal">Applied In takal</option> <option value="ordinary">Applies In Ordinary</option> <option value="not">Not Applied</option> </select> <?php }?> </div> </div> <div id="pyes"> <div class="form-group col-sm-11"> <label for="sel1">Passport No: </label> <input type="text" class="form-control" id="pano" name="pano" value="<?php echo $data['PA_NO']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Surname: </label> <input type="text" class="form-control" id="pasur" name="pasur" value="<?php echo $data['PA_SUR']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Given Names: </label> <input type="text" class="form-control" id="pagname" name="pagname" value="<?php echo $data['PA_GNAME']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Nationality: </label> <input type="text" class="form-control" id="panat" name="panat" value="<?php echo $data['PA_NAT']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Sex:</label> <? if($AP_ID) {?> <select class="form-control" id="pasex" name="pasex"> <option value="<?php echo $data['PA_SEX']; ?>"><?php echo $data['PA_SEX']; ?></option> </select> <?php } else { ?> <select class="form-control" id="pasex" name="pasex"> <option value="Male">Male</option> <option value="Female">Female</option> </select> <?php }?> </div> <div class="form-group col-sm-11"> <label for="sel1">Date Of Birth:</label> <input type="date" class="form-control" id="padob" name="padob" value="<?php echo $data['PA_DOB']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Place Of Birth: </label> <input type="text" class="form-control" id="papob" name="papob" value="<?php echo $data['PA_POB']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Place Of Issue: </label> <input type="text" class="form-control" id="papoi" name="papoi" value="<?php echo $data['PA_POI']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Date Of Issue: </label> <input type="date" class="form-control" id="padoi" name="padoi" value="<?php echo $data['PA_DOI']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Date Of Expiry: </label> <input type="date" class="form-control" id="padoe" name="padoe" value="<?php echo $data['PA_DOE']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Father/Legal Guardian Name: </label> <input type="text" class="form-control" id="pafat" name="pafat" value="<?php echo $data['PA_FAT']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Mother Name: </label> <input type="text" class="form-control" id="pamot" name="pamot" value="<?php echo $data['PA_MOT']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Spouse Name: </label> <input type="text" class="form-control" id="paspo" name="paspo" value="<?php echo $data['PA_SPO']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Passport adders(As in passport): </label> <input type="text" class="form-control" id="paadd" name="paadd" value="<?php echo $data['PA_ADD']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">ZIP Code/Foreign Postal Code:</label> <input type="text" class="form-control" id="papcode" name="papcode" value="<?php echo $data['PA_PCODE']; ?>"> </div> </div> <br> <!-- <br> <h4 class="form-group col-sm-11">N.R.I/P.I.O.C/O.C.I/ Other Card Details</h4> <div class="form-group col-sm-11"> <label for="sel1">Whether having Any Card:</label> <select class="form-control" id="card" name="othav" onchange="cextra(this.value);"> <option value="">select</option> <option value="yes">Yes</option> <option value="no">No</option> </select> </div> <div id="cno"> <div class="form-group col-sm-11"> <label for="sel1">If No Status of Card:</label> <select class="form-control" id="sts" name="otsta" onchange="sextra(this.value)"> <option value="tak">Applied in Takal</option> <option value="ord">Applied in Ordinary</option> <option value="not">Not Applied</option> </select> </div> <div id="scard"> <div class="form-group col-sm-11"> <label for="sel1">Card Applied Date:</label> <input type="date" class="form-control" id="otadat" name="otadat"> </div> <div class="form-group col-sm-11"> <label for="sel1">File No:</label> <input type="text" class="form-control" id="otfile" name="otfile"> </div> </div> </div> <div id="cyes"> <div class="form-group col-sm-11"> <label for="sel1">Select Your Card:</label> <select class="form-control" id="sel1" name="otsel"> <option value="nri">N.R.I</option> <option value="pioc">P.I.O.C</option> <option value="oci">O.C.I</option> <option value="other">Other Card</option> </select> </div> <div class="form-group col-sm-11"> <label for="sel1">Sur Name:</label> <input type="text" class="form-control" id="otsur" name="otsur"> </div> <div class="form-group col-sm-11"> <label for="sel1">Given Names:</label> <input type="text" class="form-control" id="otgnam" name="otgnam"> </div> <div class="form-group col-sm-11"> <label for="sel1">Nationality:</label> <input type="text" class="form-control" id="otnat" name="otnat"> </div> <div class="form-group col-sm-11"> <label for="sel1">Sex:</label> <input type="text" class="form-control" id="otsex" name="otsex"> </div> <div class="form-group col-sm-11"> <label for="sel1">Date Of Birth:</label> <input type="date" class="form-control" id="otdob" name="otdob"> </div> <div class="form-group col-sm-11"> <label for="sel1">Occupation:</label> <input type="text" class="form-control" id="otocc" name="otocc"> </div> <div class="form-group col-sm-11"> <label for="sel1">Place Of Birth:</label> <input type="text" class="form-control" id="otpob" name="otpob"> </div> <div class="form-group col-sm-11"> <label for="sel1">Place Of Issue:</label> <input type="text" class="form-control" id="otpoi" name="otpoi"> </div> <div class="form-group col-sm-11"> <label for="sel1">Date Of Issue:</label> <input type="date" class="form-control" id="otdoi" name="otdoi"> </div> <div class="form-group col-sm-11"> <label for="sel1">Date Of Expiry:</label> <input type="date" class="form-control" id="otdoe" name="otdoe"> </div> <div class="form-group col-sm-11"> <label for="sel1">Father/Legal Guardian Name:</label> <input type="text" class="form-control" id="otfat" name="otfat"> </div> <div class="form-group col-sm-11"> <label for="sel1">Mother Name:</label> <input type="text" class="form-control" id="otmot" name="otmot"> </div> <div class="form-group col-sm-11"> <label for="sel1">N.R.I/P.I.O.C/O.C.I/OTHER CARD ADDRESS:</label> <input type="text" class="form-control" id="otadd" name="otadd"> </div> <div class="form-group col-sm-11"> <label for="sel1">(As in N.R.I/P.I.O.C/O.C.I/OTHER CARD)</label> <input type="text" class="form-control" id="otas" name="otas"> </div> </div> <h5 class="form-group col-sm-11">Note:</h5> <p class="form-group col-sm-11">Passport should reach us fifty days before departure. We need the passport / N.R.I / P.I.O.C / O.C.I / OTHER CARD for airline request last date.</p> <p class="form-group col-sm-11">If passport / N.R.I / P.I.O.C / O.C.I / OTHER CARD dose nit reach our administrative office on the said month. The booking will be automatically cancelled.</p> <p class="form-group col-sm-11">So avoid delay in handing over the passport / N.R.I / P.I.O.C / O.C.I / OTHER CARD to our Registration office only.</p> <br> --> <h4 class="form-group col-sm-11">Nominee Details</h4> <div class="form-group col-sm-11"> <label for="sel1">NAME OF NOMINEE (Major & Blood relation):</label> <input type="text" class="form-control" id="noname" name="noname" value="<?php echo $data['NO_NAME']; ?>"> </div> <div class="form-group col-sm-11"> <label for="comment">ADDRESS(RESIDENCE):</label> <textarea class="form-control" rows="5" id="noadd" name="noadd"><?php echo $data['NO_ADD']; ?></textarea> </div> <div class="form-group col-sm-11"> <label for="sel1">LandMark:</label> <input type="text" class="form-control" id="noland" name="noland" value="<?php echo $data['NO_LAND']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">City:</label> <input type="text" class="form-control" id="nocity" name="nocity" value="<?php echo $data['NO_CITY']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Taluk:</label> <input type="text" class="form-control" id="notal" name="notal" value="<?php echo $data['NO_TAL']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">District:</label> <input type="text" class="form-control" id="nodis" name="nodis" value="<?php echo $data['NO_DIS']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">State:</label> <input type="text" class="form-control" id="nostate" name="nostate" value="<?php echo $data['NO_STATE']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Country:</label> <input type="text" class="form-control" id="nocou" name="nocou" value="<?php echo $data['NO_COU']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">ZIP Code/Foreign Postal Code :</label> <input type="text" class="form-control" id="nopcod" name="nopcod" value="<?php echo $data['NO_PCOD']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Mobile:</label> <input type="text" class="form-control" id="nomob" name="nomob" value="<?php echo $data['NO_MOB']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">TELEPHONE NUMBER WITH AREA CODE ISD / STD:</label> <input type="text" class="form-control" id="notel" name="notel" value="<?php echo $data['NO_TEL']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Email:</label> <input type="email" class="form-control" id="nomail" name="nomail" value="<?php echo $data['NO_MAIL']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">Contact Person:</label> <input type="text" class="form-control" id="nocper" name="nocper" value="<?php echo $data['NO_CPER']; ?>"> </div> <div class="form-group col-sm-11"> <label for="sel1">NOMINEE RELATIONSHIP:</label> <input type="text" class="form-control" id="nonrel" name="nonrel" value="<?php echo $data['NO_NREL']; ?>"> </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> <div class="row"> <div class="col-lg-12"> <div class="panel panel-default"> <div class="panel-heading">View /Update Register Data Table</div> <div class="container"> <div class="box"> <div class="top"> 2016 </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="true">Item ID</th> <th data-field="name" data-sortable="true">App No</th> <th data-field="status" data-sortable="true">Status</th> <th data-field="action" data-sortable="true">Action</th> </tr> </thead> <tbody> <?php $table = mysql_query("select * from newapplication where APP_DATE like '2016-%-%'"); $AP_ID=1; while($row=mysql_fetch_array($table)) { ?> <tr> <td></td> <td><?php echo $AP_ID;?></td> <td><?php echo $row['AP_NO'];?></td> <td><a href= "mg_reg.php?AP_ID=<?php echo $row['AP_ID'];?>">Edit</a>/<a href="#" onclick="del(<?php echo $row['AP_ID'];?>)">Delete</a></td> <td><?php if($row['AP_STS']==1) {?> <a href = "mg_reg.php?AP_STS=0&SAI=<?php echo $row['AP_ID'];?>">Active</a> <?php } else {?> <a href = "mg_reg.php?AP_STS=1&SAI=<?php echo $row['AP_ID'];?>">InActive </a> <?php } ?></td> </tr> <?php $AP_ID++; }?> </tbody> </table> </div> </div> <hr> <div class="box"> <div class="top"> 2015 </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="true">Item ID</th> <th data-field="name" data-sortable="true">App No</th> <th data-field="status" data-sortable="true">Status</th> <th data-field="action" data-sortable="true">Action</th> </tr> </thead> <tbody> <?php $table = mysql_query("select * from newapplication where APP_DATE like '2015-%-%'"); $AP_ID=1; while($row=mysql_fetch_array($table)) { ?> <tr> <td></td> <td><?php echo $AP_ID;?></td> <td><?php echo $row['AP_NO'];?></td> <td><a href= "mg_reg.php?AP_ID=<?php echo $row['AP_ID'];?>">Edit</a>/<a href="#" onclick="del(<?php echo $row['AP_ID'];?>)">Delete</a></td> <td><?php if($row['AP_STS']==1) {?> <a href = "mg_reg.php?AP_STS=0&SAI=<?php echo $row['AP_ID'];?>">Active</a> <?php } else {?> <a href = "mg_reg.php?AP_STS=1&SAI=<?php echo $row['AP_ID'];?>">InActive </a> <?php } ?></td> </tr> <?php $AP_ID++; }?> </tbody> </table> </div> </div> <hr> <div class="box"> <div class="top"> 2014 </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="true">Item ID</th> <th data-field="name" data-sortable="true">App No</th> <th data-field="status" data-sortable="true">Status</th> <th data-field="action" data-sortable="true">Action</th> </tr> </thead> <tbody> <?php $table = mysql_query("select * from newapplication where APP_DATE like '2014-%-%'"); $AP_ID=1; while($row=mysql_fetch_array($table)) { ?> <tr> <td></td> <td><?php echo $AP_ID;?></td> <td><?php echo $row['AP_NO'];?></td> <td><a href= "mg_reg.php?AP_ID=<?php echo $row['AP_ID'];?>">Edit</a>/<a href="#" onclick="del(<?php echo $row['AP_ID'];?>)">Delete</a></td> <td><?php if($row['AP_STS']==1) {?> <a href = "mg_reg.php?AP_STS=0&SAI=<?php echo $row['AP_ID'];?>">Active</a> <?php } else {?> <a href = "mg_reg.php?AP_STS=1&SAI=<?php echo $row['AP_ID'];?>">InActive </a> <?php } ?></td> </tr> <?php $AP_ID++; }?> </tbody> </table> </div> </div> </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>
Simpan