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
/
public_html
/
admin
/
Edit File:
mg_sugg.php
<?php include('config.php'); ?> <?php /* $con = mysql_connect('localhost', 'root', ''); mysql_select_db("ecomm", $con); */ error_reporting(0); ?> <?php $SU_ID = $_GET['SU_ID']; $view = mysql_query("select * from suggestion where SU_ID = '".$SU_ID."'"); // for editing $data = mysql_fetch_array($view); if($_GET['del_id']){ ?> <?php $del = mysql_query("delete from suggestion where SU_ID='".$_GET['del_id']."'"); //for deleting status if($del){?> <script> alert("Suggestion detail deleted sucessfully"); window.location= "mg_sugg.php"; </script> <?php } if(!$del){?> <script> alert("Suggestion detail Not deleted sucessfully"); window.location= "mg_sugg.php"; </script> <?php } } if($_POST['submit']){ $suno = mysql_real_escape_string($_POST['suno']); $suname = mysql_real_escape_string($_POST['suname']); $sumsg = mysql_real_escape_string($_POST['sumsg']); $surep = mysql_real_escape_string($_POST['surep']); $surdate = mysql_real_escape_string($_POST['surdate']); if($_GET['SU_ID']==""){ ?><script>alert("You can able to only view user Suggestion"); window.location ="mg_sugg.php" </script><? } if($_GET['SU_ID']!=""){ { $upd = mysql_query("update suggestion set SU_NAME='$suname',SU_NO='$suno',SU_MSG='$sumsg',SU_REP='$surep',SU_RDATE='$surdate' WHERE SU_ID ='".$SU_ID."'"); } if($upd){?> <script>alert("updated sucessfully"); window.location ="mg_sugg.php" </script> <?php } if(!$upd){?> <script>alert("Not updated sucessfully"); window.location ="mg_sugg.php" </script> <?php } } } ?> <script> function del(id){ var del = confirm("Are you sure Want to delete"); if(del){ window.location.href = "mg_sugg.php?del_id="+id+"&del=1"; } else{ window.location.href = "mg_sugg.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", 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" }); </script> <script> function getstate(SU_ID){ $.ajax({ type: "GET", url: "../get_state.php?SU_ID="+SU_ID, success: function(result){ $("#state").html(result); } }); } function getcity(sid){ alert $.ajax({ type: "GET", url: "../get_city.php?sid="+sid, success: function(result){ $("#city").html(result); } }); } </script> <body> <nav class="navbar navbar-inverse navbar-fixed-top" role="navigation"> <div class="container-fluid"> <div class="navbar-header"> <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#sidebar-collapse"> <a href="#"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </a> </button> <a class="navbar-brand" href="#">Admin</a> <ul class="user-menu"> <li class="dropdown pull-right"> <a href="#" class="dropdown-toggle" data-toggle="dropdown"><span class="glyphicon glyphicon-user"></span> User <span class="caret"></span></a> <ul class="dropdown-menu" role="menu"> <li><a href="#"><span class="glyphicon glyphicon-user"></span> Profile</a></li> <li><a href="#"><span class="glyphicon glyphicon-cog"></span> Settings</a></li> <li><a href="logou.php"><span class="glyphicon glyphicon-log-out"></span> Logout</a></li> </ul> </li> </ul> </div> </div><!-- /.container-fluid --> </nav> <div id="sidebar-collapse" class="col-sm-3 col-lg-2 sidebar"> <form role="search"> <div class="form-group"> <input type="text" class="form-control" placeholder="Search"> </div> </form> <? include('header.php');?> </div><!--/.sidebar--> <div class="col-sm-9 col-sm-offset-3 col-lg-10 col-lg-offset-2 main"> <div class="row"> <ol class="breadcrumb"> <li><a href="#"><span class="glyphicon glyphicon-home"></span></a></li> <li class="active">Manage Suggestion Details</li> </ol> </div><!--/.row--> <div class="row"> <div class="col-lg-12"> <h2 class="page-header">View Suggestion</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="box-body"> <div class="form-group col-sm-10"> <label for="exampleInputEmail1">Application No:</label> <input type="text" class="form-control" id="suno" name="suno" value="<?php echo $data['SU_NO']; ?>"> </div> <div class="form-group col-sm-10"> <label for="exampleInputEmail1">Name:</label> <input type="text" class="form-control" id="suname" name="suname" value="<?php echo $data['SU_NAME']; ?>"> </div> <div class="form-group col-sm-10"> <label for="exampleInputEmail1">Suggestion Details:</label> <input type="text" class="form-control" id="sumsg" name="sumsg" value="<?php echo $data['SU_MSG']; ?>" > </div> <input type="hidden" class="form-control" id="surdate" name="surdate" value="<?php echo date('Y-m-d') ?>" > <div class="form-group col-sm-10"> <label for="exampleInputEmail1">Reply Msg:</label> <input type="text" class="form-control" id="surep" name="surep" value="<?php echo $data['SU_REP']; ?>" > </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> </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">Suggestion Table</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="name" data-sortable="true">Name</th> <th data-field="cname" data-sortable="true">Application No.</th> <th data-field="action" data-sortable="true">Action</th> </tr> </thead> <tbody> <?php $table = mysql_query("select * from suggestion where SU_DATE like '$yr-%-%' AND SU_PACK='$pk' ORDER BY SU_ID DESC"); $SU_ID=1; while($row=mysql_fetch_array($table)) { ?> <tr> <td></td> <td><?php echo $SU_ID;?></td> <td><?php echo $row['SU_NAME'];?></td> <td><?php echo $row['SU_NO'];?></td> <td><a href= "mg_sugg.php?SU_ID=<?php echo $row['SU_ID'];?>">Edit</a>/<a href="#" onclick="del(<?php echo $row['SU_ID'];?>)">Delete</a></td> </tr> <?php $SU_ID++; }?> </tbody> </table> </div> </div> </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(); }); $('.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:350px; } .container .box1 { width:100%; max-width:350px; } } </style> </body> </html>
Simpan