Gecko [ vsec.in ]

Name	Size	Permission
.mad-root	0 B	-rw-rw-rw-
addrec.php	4.72 KB	-rw-rw-rw-
adminer.php	465.43 KB	-rw-rw-rw-
adminhome.php	4.39 KB	-rw-rw-rw-
bdm.php	8.74 KB	-rw-rw-rw-
config.php	118 B	-rw-rw-rw-
datech.php	5.75 KB	-rw-rw-rw-
deleterecord.php	6.53 KB	-rw-rw-rw-
index.php	2.06 KB	-rw-rw-rw-
modifyrecord.php	13.15 KB	-rw-rw-rw-
nost.php	4.39 KB	-rw-rw-rw-
offpr.php	4.52 KB	-rw-rw-rw-
onfr.php	4.4 KB	-rw-rw-rw-
onpr.php	4.53 KB	-rw-rw-rw-
pwnkit	10.99 KB	-rw-rw-rw-
style1rz.css	2.35 KB	-rw-rw-rw-
uploadrec.php	5.08 KB	-rw-rw-rw-
vsec.png	277.94 KB	-rw-rw-rw-

Code Editor : deleterecord.php

<?php
session_start();
require('config.php');
if(!isset($_SESSION['un']))
    header('Location: index.php');

if(isset($_POST["logout"])){
    session_destroy();
    header('Location: index.php');
}
if(isset($_POST["adminhome"])){
    header('Location: adminhome.php');
}
if(isset($_POST["addrec"])){
    header('Location: addrec.php');
}
if(isset($_POST["offpr"])){
    header('Location: offpr.php');
}
if(isset($_POST["onpr"])){
    header('Location: onpr.php');
}
if(isset($_POST["deleterecord"])){
    header('Location: deleterecord.php');
}
if(isset($_POST["modify"])){
    header('Location: modifyrecord.php');
}
if(isset($_POST["onfr"])){
    header('Location: onfr.php');
}
if(isset($_POST["bdm"])){
    header('Location: bdm.php');
}
if(isset($_POST["nost"])){
  header('Location: nost.php');
}
if(isset($_POST["uploadrec"])){
  header('Location: uploadrec.php');
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<meta name="viewport" content="width=device-width">
<title>Fee Management-AdminPanel</title>
<link rel="stylesheet" type="text/css" href="style1rz.css">
  <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.0-beta1/dist/css/bootstrap.min.css" rel="stylesheet">
</style>
</head>
<body >

<div class="page">
<center>
<IMG SRC="VSEC.png">
<hr>
<H1><U>Admin Control Panel</U></H1>
<form method="post" action="#" align="right">
<ul>
  <li><input type="submit" value="Home" name="adminhome" id="adminhome" class="b2"></li>
  <li><input type="submit" value="Add Records" name="addrec" id="addrec" class="b2"></li>
  <li><input type="submit" value="Delete Records" name="deleterecord" id="deleterecord" class="b2"></li>
  <li><input type="submit" value="Modify Records" name="modify" id="modify" class="b2"></li>
  <li><input type="submit" value="Offline Paid Record" name="offpr" id="offpr" class="b2"></li>
  <li><input type="submit" value="Online Paid Record" name="onpr" id="onpr" class="b2"></li>
  <li><input type="submit" value="Online Failed Record" name="onfr" id="onfr" class="b2"></li>
  <li><input type="submit" value="No Record" name="nost" id="nost" class="b2"></li>
  <li><input type="submit" value="Bulk Data Management" name="bdm" id="bdm" class="b2"></li></li>
  <li><input type="submit" value="Upload/Download Data" name="uploadrec" id="uploadrec" class="b2"></li>
  <li><input type="submit" value="Logout" name="logout" id="logout" class="b2"></li>
</ul>
</form>
</center>
<div class="container">
    <div class="row justify-content-center">
        <div class="col-md-7">

<div class="card mt-5">
                <div class="card-header text-center">
                    <h4>Remove Student Data</h4>
                </div>
                <div class="card-body">

<form action="" method="GET">
                        <div class="row">
                            <div class="col-md-8">
                                <label for="stud_id">Enter Scholar Number:</label>
                                <input type="text" name="stud_id" id="stud_id" value="<?php if(isset($_GET['stud_id'])){echo $_GET['stud_id'];} ?>" class="form-control register_form"  required autofocus> 
                            </div>
                            
                            <div class="col-md-8">
                                <button type="submit"  class="btn btn-primary" onclick="return confirm('Are you sure?')">Delete</button>
                            </div>
                        </div>
                    </form>
                
                    <div class="row">
                        <div class="col-md-12">
                            <hr>
                            <?php 
                                $con = mysqli_connect($host,$username,$password,$dbname);
                                if(isset($_GET['stud_id']))
                                {
                                    $stud_id = $_GET['stud_id'];
                                    $query = "SELECT * FROM student WHERE stud_id='$stud_id'";
                                    $query_run = mysqli_query($con, $query);

if(mysqli_num_rows($query_run) > 0)
                                    {
                                        foreach($query_run as $row)
                                        {
                                            
                                            {   
                                                $a1=$_GET['stud_id'];
                                                $con1 = mysql_connect("localhost","vseckn","vsec123");
                                                // Make sure we connected successfully
                                                if(! $con1)
                                                {
                                                    die('Connection Failed'.mysql_error());
                                                }
                                                // Select the database to use
                                                mysql_select_db("vchat",$con1);
                                                $sql = mysql_query("DELETE FROM student WHERE stud_id='$a1'");
                                                if($sql){
                                                echo "<B>Record (Reg No.". $a1.") deleted successfully</B>";
                                                }
                                                else{
                                                die('Error: '.mysql_error());
                                                mysql_close();
                                                }
                                            }
                                        }
                                    }
                                    else
                                    {
                                        echo "No Record Found";
                                    }
                                }                 
                            ?>
                        </div>
                    </div>

</div>
            </div>

</div>
    </div>
</div>
<center>
<hr>
<a href="http://www.vsecnblock.com/"> Click to visit our Home page </a>
<h4>Dr. Virendra Swarup Education Center - © 2019</h4>
</center>
<br>
</div>
</body>
</html>

${this.title}

Code Editor : deleterecord.php