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_list.php
<?php error_reporting(0); session_start(); include 'config.php'; $_POST['username']=$_SESSION['username']; $_POST['password']=$_SESSION['password']; $sql=mysqli_query($con,"select * from admin where USERNAME='".$_POST['username']."' and PASSWORD='".$_POST['password']."'"); if(mysqli_num_rows($sql)==1) { $ME_ID = $_GET['MEID']; $view = mysqli_query($con,"select * from list where ME_ID = '".$ME_ID."'"); // for editing $datab = mysqli_fetch_array($view); date_default_timezone_set("Asia/Kolkata"); if($_GET['del_id']){ ?> <?php $del = mysqli_query($con,"delete from list where ME_ID='".$_GET['del_id']."'"); //for deleting status if($del){?> <script> alert("Memeber List deleted sucessfully"); window.location= "mg_list.php"; </script> <?php } if(!$del){?> <script> alert("Memeber List Not deleted sucessfully"); window.location= "mg_list.php"; </script> <?php } } if($_POST['submit']){ $name = mysqli_real_escape_string($con,$_POST['name']); $num = mysqli_real_escape_string($con,$_POST['num']); $year = mysqli_real_escape_string($con,$_POST['year']); $apimg = ($_FILES['apimg']['name']); $tmp_img = $_FILES['apimg']['tmp_name']; move_uploaded_file($tmp_img, "images/".$apimg); $din = mysqli_real_escape_string($con,$_POST['din']); $sin = mysqli_real_escape_string($con,$_POST['sin']); $lic = mysqli_real_escape_string($con,$_POST['lic']); $add = mysqli_real_escape_string($con,$_POST['add']); $city = mysqli_real_escape_string($con,$_POST['city']); $pin = mysqli_real_escape_string($con,$_POST['pin']); $pho = mysqli_real_escape_string($con,$_POST['pho']); $mob = mysqli_real_escape_string($con,$_POST['mob']); $mail = mysqli_real_escape_string($con,$_POST['mail']); $web = mysqli_real_escape_string($con,$_POST['web']); if($name=="") { $name = mysqli_real_escape_string($con,$_POST['name1']); $num = mysqli_real_escape_string($con,$_POST['num1']); $apimg = ($_FILES['apimg1']['name']); $tmp_img = $_FILES['apimg1']['tmp_name']; move_uploaded_file($tmp_img, "images/".$apimg); $din = mysqli_real_escape_string($con,$_POST['din1']); $sin = mysqli_real_escape_string($con,$_POST['sin1']); $lic = mysqli_real_escape_string($con,$_POST['lic1']); $add = mysqli_real_escape_string($con,$_POST['add1']); $city = mysqli_real_escape_string($con,$_POST['city1']); $pin = mysqli_real_escape_string($con,$_POST['pin1']); $pho = mysqli_real_escape_string($con,$_POST['pho1']); $mob = mysqli_real_escape_string($con,$_POST['mob1']); $mail = mysqli_real_escape_string($con,$_POST['mail1']); $web = mysqli_real_escape_string($con,$_POST['web1']); } $app = mysqli_real_escape_string($con,$_POST['app']); $pname1 = mysqli_real_escape_string($con,$_POST['pname1']); $pdes1 = mysqli_real_escape_string($con,$_POST['pdes1']); $pname2 = mysqli_real_escape_string($con,$_POST['pname2']); $pdes2 = mysqli_real_escape_string($con,$_POST['pdes2']); $pname3 = mysqli_real_escape_string($con,$_POST['pname3']); $pdes3 = mysqli_real_escape_string($con,$_POST['pdes3']); $pname4 = mysqli_real_escape_string($con,$_POST['pname4']); $pdes4 = mysqli_real_escape_string($con,$_POST['pdes4']); $pmob1 = mysqli_real_escape_string($con,$_POST['pmob1']); $pmob2 = mysqli_real_escape_string($con,$_POST['pmob2']); $pmob3 = mysqli_real_escape_string($con,$_POST['pmob3']); $pmob4 = mysqli_real_escape_string($con,$_POST['pmob4']); $mname = mysqli_real_escape_string($con,$_POST['mname']); $mnum = mysqli_real_escape_string($con,$_POST['mnum']); $mfname = mysqli_real_escape_string($con,$_POST['mfname']); $mpas = mysqli_real_escape_string($con,$_POST['mpas']); $msau = mysqli_real_escape_string($con,$_POST['msau']); if($_GET['MEID']==""){ //for inserting new register $ins = mysqli_query($con,"insert into list (ME_NAME,ME_NUM,ME_IMG,ME_DIN,ME_SIN,ME_LIC,ME_ADD,ME_CITY,ME_PIN,ME_PHO,ME_MOB,ME_MAIL,ME_WEB,ME_APP,ME_PNAME1,ME_PDES1,ME_PNAME2,ME_PDES2,ME_PNAME3,ME_PDES3,ME_PNAME4,ME_PDES4,ME_MOB1,ME_MOB2,ME_MOB3,ME_MOB4,ME_MNAME,ME_MNUM,ME_MFNAME,ME_MPAS,ME_MSAU,ME_YR) values ('$name','$num','$apimg','$din','$sin','$lic','$add','$city','$pin','$pho','$mob','$mail','$web','$app','$pname1','$pdes1','$pname2','$pdes2','$pname3','$pdes3','$pname4','$pdes4','$pmob1','$pmob2','$pmob3','$pmob4','$mname','$mnum','$mfname','$mpas','$msau','$year')"); if(ins){?> <script> alert("Inserted sucessfully"); </script><?php } } else { if($_FILES['apimg']['name']!=""&&$_GET['MEID']!=""){ $upd = mysqli_query($con,"update list set ME_NAME='$name',ME_NUM='$num',ME_IMG='$apimg',ME_DIN='$din',ME_ADD='$add',ME_CITY='$city',ME_PIN='$pin',ME_SIN='$sin',ME_LIC='$lic',ME_PHO='$pho',ME_MOB='$mob',ME_MAIL='$mail',ME_WEB='$web',ME_APP='$app',ME_PNAME1='$pname1',ME_PDES1='$pdes1',ME_PNAME2='$pname2',ME_PDES2='$pdes2',ME_PNAME3='$pname3',ME_PDES3='$pdes3',ME_PNAME4='$pname4',ME_PDES4='$pdes4',ME_MOB1='$pmob1',ME_MOB2='$pmob2',ME_MOB3='$pmob3',ME_MOB4='$pmob4',ME_MNAME='$mname',ME_MNUM='$mnum',ME_MFNAME='$mfname',ME_MPAS='$mpas',ME_MSAU='$msau',ME_YR='$year' WHERE ME_ID ='".$ME_ID."'"); } else { $upd = mysqli_query($con,"update list set ME_NAME='$name',ME_NUM='$num',ME_DIN='$din',ME_ADD='$add',ME_CITY='$city',ME_PIN='$pin',ME_SIN='$sin',ME_LIC='$lic',ME_PHO='$pho',ME_MOB='$mob',ME_MAIL='$mail',ME_WEB='$web',ME_APP='$app',ME_PNAME1='$pname1',ME_PDES1='$pdes1',ME_PNAME2='$pname2',ME_PDES2='$pdes2',ME_PNAME3='$pname3',ME_PDES3='$pdes3',ME_PNAME4='$pname4',ME_PDES4='$pdes4',ME_MOB1='$pmob1',ME_MOB2='$pmob2',ME_MOB3='$pmob3',ME_MOB4='$pmob4',ME_MNAME='$mname',ME_MNUM='$mnum',ME_MFNAME='$mfname',ME_MPAS='$mpas',ME_MSAU='$msau',ME_YR='$year' WHERE ME_ID ='".$ME_ID."'"); } if($upd){?> <script>alert("updated sucessfully"); window.location ="mg_list.php" </script> <?php } } } ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>Admin Panel</title> <link href="css/bootstrap.min.css" rel="stylesheet"> <link href="css/datepicker3.css" rel="stylesheet"> <link href="css/styles.css" rel="stylesheet"> <link href="css/bootstrap-table.css" rel="stylesheet"> <!--[if lt IE 9]> <script src="js/html5shiv.js"></script> <script src="js/respond.min.js"></script> <![endif]--> </head> <script type="text/javascript" src="js/tinymce/tinymce.min.js"></script> <script type="text/javascript"> tinymce.init({ selector: "textarea", themes: "modern", forced_root_block : 'p' plugins: [ "advlist autolink lists link image charmap print preview anchor", "searchreplace visualblocks code fullscreen", "insertdatetime media table contextmenu paste" ], toolbar: "insertfile undo redo | styleselect | bold italic | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | link image" }); function cal(str,st1) { $.ajax({ type: "GET", url: "csgst.php?q="+str+"&state="+str1, success: function(result){ $("#taxvalue").html(result); } }); } function cal1(str) { document.getElementById("am1").enabled = true; document.getElementById("am2").disabled = true; $.ajax({ type: "GET", url: "igst.php?q="+str, success: function(result){ $("#taxvalue1").html(result); } }); } </script> <script> // for cancelling confirm function cancel(id){ var cancel = confirm("Are you sure Want to cancel"); if(cancel){ window.location.href = "mg_bill.php?SAI1="+id+"&NI_CANCEL=0"; } else{ window.location.href = "mg_bill.php"; } } </script> <script> function cust1(cid){ var cid1 = (escape(cid)); $.ajax({ type: "GET", url: "get_cust1.php?cid="+cid1, success: function(result){ $("#custid").html(result); } }); } </script> <body> <nav class="navbar navbar-inverse navbar-fixed-top" role="navigation"> <div class="container-fluid"> <div class="navbar-header"> <a href="#"><button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#sidebar-collapse"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> </a> <a class="navbar-brand" href="#"><img src="../images/logo/thoa.png" style="width:50px;height:50px;margin-top:-10px;"> <b>THOA Menu</b></a> <ul class="user-menu"> <li class="dropdown pull-right"> <a href="#" class="dropdown-toggle" data-toggle="dropdown"><img src="../images/team/6.jpg" style="border-radius:40%;width:35px;height:35px;"> MR. N.AHAMED THAMBI<span class="caret"></span></a> <ul class="dropdown-menu" role="menu"> <li><a href="logou.php" style="color:red;"><span class="glyphicon glyphicon-off"></span> Logout</a></li> </ul> </li> </ul> </div> </div><!-- /.container-fluid --> </nav> <div id="sidebar-collapse" class="col-sm-3 col-lg-2 sidebar"> <form role="search"> <div class="form-group"> <input type="text" class="form-control" placeholder="Search"> </div> </form> <?php include('header.php');?> </div><!--/.sidebar--> <div class="col-sm-9 col-sm-offset-3 col-lg-10 col-lg-offset-2 main"> <div class="row"> <ol class="breadcrumb"> <li><a href="dash.php"><span class="glyphicon glyphicon-home"></span></a></li> <li class="active">Manage Members List</li> </ol> </div><!--/.row--> <section class="content" > <div class="row"> <div class="col-lg-12"> <h2 class="page-header view1">To create member</h2> </div> </div><!--/.row--> <div class="row"> <!-- left column --> <div class="col-lg-12"> <!-- general form elements --> <div class="box box-primary"> <!-- form start --> <div class="container"> <form role="form" method="post" action="" enctype="multipart/form-data" > <div class="form-group col-sm-10"> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Year:</label> <select class="form-control" id="year" name="year"> <?php if($ME_ID) {?> <option value="<?php echo $datab['ME_YR'];?>"><?php echo $datab['ME_YR'];?></option> <?php $queryear=mysqli_query($con,"select * from year ORDER BY Y_LIST DESC"); while($rowyear=mysqli_fetch_array($queryear)) {?> <option value="<?php echo $rowyear['Y_LIST'];?>"><?php echo $rowyear['Y_LIST'];?></option> <?php } } else {?> <?php $queryear=mysqli_query($con,"select * from year ORDER BY Y_LIST DESC"); while($rowyear=mysqli_fetch_array($queryear)) {?> <option value='<?php echo $rowyear['Y_LIST'];?>'<?php if($rowyear['Y_LIST']=='2022') echo ' selected'; ?>><?php echo $rowyear['Y_LIST'];?></option> <?php }}?> </select> </div> </div> <?php if(!$ME_ID) {?> <div class="form-group col-sm-10"> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Select Old Member / New One:</label> <select class="form-control" onchange="coming(this.value);" id="comin" name="comin" required> <option value="">Select</option> <option value="company">Old</option> <option value="individual">New</option> </select> </div> </div> <?php } if($ME_ID) {?> <div class="form-group col-sm-10"> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Membership Name:</label> <input type="text" class="form-control" id="demo" name="name" value="<?php echo $datab['ME_NAME']; ?>" > </div> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Membership Number:</label> <input type="text" class="form-control" id="demo" name="num" value="<?php echo $datab['ME_NUM']; ?>" > </div> <div class="form-group col-sm-6"> <label for="exampleInputFile">Upload your photograph:</label> <input type="file" name="apimg" id="exampleInputFile"> <?php if($ME_ID){?> <img src = "images/<?php echo $datab['ME_IMG'];?>" height="100" width="100"></img> <?php }?> <label for="exampleInputFile">(Size:5 MB Max, Format:.jpg,.png)</label><br> <label for="exampleInputFile">Before upload rename your file name in this format <br> (Membership Number-Photo -> For Ex: 000101-Photo) </label> </div> </div> <div class="form-group col-sm-10"> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Date of incorporation:</label> <input type="text" class="form-control" id="din" name="din" value="<?php echo $datab['ME_DIN']; ?>" > </div> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Memeber Since:</label> <input type="text" class="form-control" id="sin" name="sin" value="<?php echo $datab['ME_SIN']; ?>" > </div> </div> <div class="form-group col-sm-10"> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Number of License:</label> <input type="text" class="form-control" id="lic" name="lic" value="<?php echo $datab['ME_LIC']; ?>" > </div> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Address:</label> <textarea class="form-control" rows="2" id="add" name="add"><?php echo $datab['ME_ADD']; ?></textarea> </div> </div> <div class="form-group col-sm-10"> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">City </label> <textarea class="form-control" rows="1" id="city" name="city"><?php echo $datab['ME_CITY']; ?></textarea> </div> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Pincode:</label> <textarea class="form-control" rows="1" id="pin" name="pin"><?php echo $datab['ME_PIN']; ?></textarea> </div> </div> <div class="form-group col-sm-10"> <div class="form-group col-sm-6"> <label for="exampleInputEmail1" >Phone Number : </label> <textarea class="form-control" rows="1" id="pho" name="pho"><?php echo $datab['ME_PHO']; ?></textarea> </div> <div class="form-group col-sm-6"> <label for="exampleInputEmail1" >Mobile : </label> <textarea class="form-control" rows="1" id="mob" name="mob"><?php echo $datab['ME_MOB']; ?></textarea> </div> </div> <div class="form-group col-sm-10"> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Email Id: </label> <textarea class="form-control" rows="1" id="mail" name="mail"><?php echo $datab['ME_MAIL']; ?></textarea> </div> <div class="form-group col-sm-6"> <label for="exampleInputEmail1" >Website : </label> <textarea class="form-control" rows="1" id="mob" name="web"><?php echo $datab['ME_WEB']; ?></textarea> </div> </div> <?php } else { ?> <div id="comp"> <div class="form-group col-sm-10"> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Membership Name:</label> <!--<input type="text" class="form-control" id="name1" name="name1" value="" >--> <select class="form-control" onclick="cust1(this.value);" id="demo" name="name"> <option value="">Select</option> <?php $querys=mysqli_query($con,"select * from list GROUP BY ME_NAME ORDER BY ME_NAME ASC"); while($rows=mysqli_fetch_array($querys)) {?> <option value="<?php echo $rows['ME_NAME'];?>"><?php echo $rows['ME_NAME'];?></option> <?php }?> </select> </div> </div> <div id="custid"> </div> </div> <div id="indi"> <div class="form-group col-sm-10"> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Membership Name:</label> <input type="text" class="form-control" id="demo1" name="name1" value="" > </div> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Membership Number:</label> <input type="text" class="form-control" id="demo2" name="num1" value="<?php $sql=mysqli_query($con,"SELECT MAX(ME_NUM) as hig FROM list"); $high = mysqli_fetch_array($sql); echo $high["hig"]+1; ?>" > </div> <div class="form-group col-sm-6"> <label for="exampleInputFile">Upload your photograph:</label> <input type="file" name="apimg1" id="exampleInputFile"> <?php if($ME_ID){?> <img src = "images/<?php echo $datab['ME_IMG'];?>" height="100" width="100"></img> <?php }?> <label for="exampleInputFile">(Size:5 MB Max, Format:.jpg,.png)</label><br> <label for="exampleInputFile">Before upload rename your file name in this format <br> (Membership Number-Photo -> For Ex: 000101-Photo) </label> </div> </div> <div class="form-group col-sm-10"> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Date of incorporation:</label> <input type="text" class="form-control" id="din1" name="din1" value="" > </div> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Memeber Since:</label> <input type="text" class="form-control" id="sin1" name="sin1" value="" > </div> </div> <div class="form-group col-sm-10"> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Number of License:</label> <input type="text" class="form-control" id="lic1" name="lic1" value="" > </div> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Address:</label> <textarea class="form-control" rows="2" id="add1" name="add1"></textarea> </div> </div> <div class="form-group col-sm-10"> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">City </label> <textarea class="form-control" rows="1" id="city1" name="city1"></textarea> </div> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Pincode:</label> <textarea class="form-control" rows="1" id="pin1" name="pin1"></textarea> </div> </div> <div class="form-group col-sm-10"> <div class="form-group col-sm-6"> <label for="exampleInputEmail1" >Phone Number : </label> <textarea class="form-control" rows="1" id="pho1" name="pho1"></textarea> </div> <div class="form-group col-sm-6"> <label for="exampleInputEmail1" >Mobile : </label> <textarea class="form-control" rows="1" id="mob1" name="mob1"></textarea> </div> </div> <div class="form-group col-sm-10"> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Email Id: </label> <textarea class="form-control" rows="1" id="mail1" name="mail1"></textarea> </div> <div class="form-group col-sm-6"> <label for="exampleInputEmail1" >Website : </label> <textarea class="form-control" rows="1" id="mob2" name="web1"></textarea> </div> </div> </div> <?php }?> <div class="form-group col-sm-10"> <label for="exampleInputEmail1">Details of Proprietor / Partner / Director</label> </div> <div class="form-group col-sm-10"> <div class="form-group col-sm-4"> <label for="exampleInputEmail1">The Applicant Company is ?:</label> <select class="form-control" name="app"> <?php if($ME_ID ){?> <option value="<?php echo $datab['ME_APP']; ?>"><?php echo $datab['ME_APP']; ?></option> <option value="Proprietary concern">Proprietary concern</option> <option value="Partnership concern">Partnership concern</option> <option value="Private Limited Company">Private Limited Company</option> <?php } else {?> <option value="">Choose</option> <option value="Proprietary concern">Proprietary concern</option> <option value="Partnership concern">Partnership concern</option> <option value="Private Limited Company">Private Limited Company</option> <?php } ?> </select> </div> </div> <div class="form-group col-sm-10"> <label for="sel1">Details 1:</label> </div> <div class="form-group col-sm-10"> <div class="form-group col-sm-4"> <label for="sel1">Name1:</label> <input type="text" class="form-control" id="qua1" name="pname1" value="<?php echo $datab['ME_PNAME1'];?>" > </div> <div class="form-group col-sm-4"> <label for="sel1">Designation1:</label> <input type="text" class="form-control" id="item1" name="pdes1" value="<?php echo $datab['ME_PDES1'];?>" > </div> <div class="form-group col-sm-4"> <label for="sel1">Mobile1:</label> <input type="text" class="form-control" id="mob1" name="pmob1" value="<?php echo $datab['ME_MOB1'];?>" > </div> </div> <div class="form-group col-sm-10"> <label for="sel1">Details 2:</label> </div> <div class="form-group col-sm-10"> <div class="form-group col-sm-4"> <label for="sel1">Name2:</label> <input type="text" class="form-control" id="qua2" name="pname2" value="<?php echo $datab['ME_PNAME2'];?>" > </div> <div class="form-group col-sm-4"> <label for="sel1">Designation2:</label> <input type="text" class="form-control" id="item2" name="pdes2" value="<?php echo $datab['ME_PDES2'];?>" > </div> <div class="form-group col-sm-4"> <label for="sel1">Mobile2:</label> <input type="text" class="form-control" id="mob2" name="pmob2" value="<?php echo $datab['ME_MOB2'];?>" > </div> </div> <div class="form-group col-sm-10"> <label for="sel1">Details 3:</label> </div> <div class="form-group col-sm-10"> <div class="form-group col-sm-4"> <label for="sel1">Name3:</label> <input type="text" class="form-control" id="qua2" name="pname3" value="<?php echo $datab['ME_PNAME3'];?>" > </div> <div class="form-group col-sm-4"> <label for="sel1">Designation3:</label> <input type="text" class="form-control" id="item2" name="pdes3" value="<?php echo $datab['ME_PDES3'];?>" > </div> <div class="form-group col-sm-4"> <label for="sel1">Mobile3:</label> <input type="text" class="form-control" id="mob3" name="pmob3" value="<?php echo $datab['ME_MOB3'];?>" > </div> </div> <div class="form-group col-sm-10"> <label for="sel1">Details 4:</label> </div> <div class="form-group col-sm-10"> <div class="form-group col-sm-4"> <label for="sel1">Name4:</label> <input type="text" class="form-control" id="qua2" name="pname4" value="<?php echo $datab['ME_PNAME4'];?>" > </div> <div class="form-group col-sm-4"> <label for="sel1">Designation4:</label> <input type="text" class="form-control" id="item2" name="pdes4" value="<?php echo $datab['ME_PDES4'];?>" > </div> <div class="form-group col-sm-4"> <label for="sel1">Mobile4:</label> <input type="text" class="form-control" id="mob4" name="pmob4" value="<?php echo $datab['ME_MOB4'];?>" > </div> </div> <div class="form-group col-sm-10"> <label for="exampleInputEmail1">Details of Munazzam Card Holder</label> </div> <div class="form-group col-sm-10"> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Name:</label> <input type="text" class="form-control" id="demo" name="mname" value="<?php echo $datab['ME_MNAME']; ?>" > </div> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Munazzam Number:</label> <input type="text" class="form-control" id="demo" name="mnum" value="<?php echo $datab['ME_MNUM']; ?>" > </div> </div> <div class="form-group col-sm-10"> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Firm Name:</label> <input type="text" class="form-control" id="demo" name="mfname" value="<?php echo $datab['ME_MFNAME']; ?>" > </div> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Passport Number:</label> <input type="text" class="form-control" id="demo" name="mpas" value="<?php echo $datab['ME_MPAS']; ?>" > </div> <div class="form-group col-sm-6"> <label for="exampleInputEmail1">Saudi Mobile Number:</label> <input type="text" class="form-control" id="demo" name="msau" value="<?php echo $datab['ME_MSAU']; ?>" > </div> </div> <!-- <div class="form-group col-sm-10"> <div class="form-group col-sm-3"> <label for="exampleInputEmail1">Enter Taxable Amount: </label> <input type="text" class="form-control" id="tax" name="tax" onkeyup="cal(cost1.value,cost2.value,cost3.value,this.value)"> </div> </div> --> <div class="box-footer col-sm-10"> <button type="submit" name="submit" value="submit" class="btn btn-primary">Click here to generate</button> <hr> <br> </div> </form> </div> </div> </div> </div> </section> <hr> <div class="row" style="position: absolute;width:100%;"> <div class="col-lg-12"> <div class="panel panel-default"> <div class="panel-heading view1">Memebers List</div> <div class="container"> <?php $queryear=mysqli_query($con,"select * from year ORDER BY Y_LIST DESC"); while($rowyear=mysqli_fetch_array($queryear)) {?> <div class="box"> <div class="top"> <?php echo $yr=$rowyear['Y_LIST'];?> </div> <hr> <div class="panel-body bottom"> <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="name1" data-sortable="true">MEMBERSHIP NUMBER</th> <th data-field="sname" data-sortable="true">TOUR NAME</th> <th data-field="status" data-sortable="true">Status</th> </tr> </thead> <tbody> <?php $table = mysqli_query($con,"select * from list WHERE ME_YR='$yr' ORDER BY ME_ID DESC"); $SID=1; while($row=mysqli_fetch_array($table)) { ?> <tr> <td></td> <td><?php echo $SID;?></td> <td><?php echo $row['ME_NUM'];?></td> <td><?php echo $row['ME_NAME'];?></td> <td><a href= "mg_list.php?MEID=<?php echo $row['ME_ID'];?>">Edit</a>/<a href="#" onclick="del(<?php echo $row['ME_ID'];?>)">Delete</a></td> </tr> <?php $SID++; }?> </tbody> </table> </div> </div> <?php } ?> </div> </div> </div> </div> </div> <!--/.main--> <script src="js/jquery-1.11.1.min.js"></script> <script src="js/bootstrap.min.js"></script> <script src="js/chart.min.js"></script> <script src="js/chart-data.js"></script> <script src="js/easypiechart.js"></script> <script src="js/easypiechart-data.js"></script> <script src="js/bootstrap-datepicker.js"></script> <script src="js/bootstrap-table.js"></script> <script> $(document).ready(function() { $('ul.subcat').hide(); $('li').click(function(event) { event.stopPropagation(); $('> ul', this).toggle(); }); }); function cal(str,str1,str2) { $.ajax({ type: "GET", url: "taxvalue.php?a1="+str+"&a2="+str1+"&a3="+str2, success: function(result){ $("#taxvalue").html(result); } }); } function cal1(str,str1) { document.getElementById("am1").enabled = true; document.getElementById("am2").disabled = true; $.ajax({ type: "GET", url: "igst.php?q="+str+"&state="+str1, success: function(result){ $("#taxvalue1").html(result); } }); } </script> <script> $('.top').on('click', function() { $parent_box = $(this).closest('.box'); $parent_box.siblings().find('.bottom').hide(); $parent_box.find('.bottom').toggle(); }); $('.top1').on('click', function() { $parent_box = $(this).closest('.box1'); $parent_box.siblings().find('.bottom1').hide(); $parent_box.find('.bottom1').toggle(); }); $("#cyes").hide(); function extra(val){ if(val == 'DD') { $("#cyes").show(); } else if(val == 'Cheque') { $("#cyes").show(); } else if(val == 'RTGS') { $("#cyes").show(); } else if(val != 'no'){ $("#cyes").hide(); } } function extra1(val){ if(val == 'yes'){ $("#pno").hide(); $("#pyes").show(); document.getElementById("am2").disabled = true; document.getElementById("am1").disabled = false; } else if(val == 'no'){ $("#pyes").hide(); $("#pno").show(); document.getElementById("am2").disabled = false; document.getElementById("am1").disabled = true; } } $("#pno").hide(); $("#pyes").hide(); $('#comp').hide(); $('#indi').hide(); function coming(val){ if(val == 'individual') { $('#comp').hide(); $('#indi').show(); } else if(val == 'company') { $('#comp').show(); $('#indi').hide(); } } </script> <script> function del(id){ var del = confirm("Are you sure Want to delete"); if(del){ window.location.href = "mg_list.php?del_id="+id+"&del=1"; } else{ window.location.href = "mg_list.php"; } } </script> <style> .container .box1 .top1 { padding: 12px; background-color: blue; color: white; cursor: pointer; } .container .box1 .bottom1 { display: none; } .container .box .top { padding: 12px; background-color: blue; color: white; cursor: pointer; } .container .box .bottom { display: none; } @media (min-width: 501px) and (max-width: 2000px){ .container .box { width:auto; max-width:900px; } .container .box1 { width:auto; max-width:900px; } } @media (min-width: 5px) and (max-width: 500px){ .container .box { width:100%; max-width:350px; } .container .box1 { width:100%; max-width:350px; } .view1 { font-size:14px; font-weight: bold; text-decoration: underline; } } </style> </body> </html> <?php } else { $queryu=mysqli_query($con,"select * from admin where ID='1'"); $rowu=mysqli_fetch_array($queryu); if($rowu) { $rowu['A_LOG']; $log = $rowu['A_LOG'] - 1; $upd_sts = mysqli_query($con,"UPDATE admin SET A_LOG ='$log' where ID='1'"); } header("Location: home.php"); } ?>
Simpan