Banking_Databases/Delete-employee.php at main · j-morgan6/Banking_Databases · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
<html>
<style>
table, th, td {
  border: 1px solid black;
}
</style>
<?php
include 'config.php';

$conn = new mysqli($servername, $username, $password, $db);
// Check connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}
function displayFaculty() {
    global $conn; //reference the global connection object (scope)
    $sql = "SELECT Employee_ID, Employee_Name, Employee_Address, Employee_Salary,Bank_ID FROM employee";
        $result = $conn->query($sql);

       if ($result->num_rows > 0) {
          // Setup the table and headers
          echo "<table><tr><th>Employee_ID</th><th>Employee_Name</th><th>Employee_Address</th><th>Employee_Salary</th><th>Bank_ID</th><th>Click To Remove</th></tr>";
         // output data of each row into a table row
         while($row = $result->fetch_assoc()) {
             echo "<tr>
             <td>".$row["Employee_ID"]."</td>
             <td>".$row["Employee_Name"]."</td>
             <td> ".$row["Employee_Address"]."</td>
             <td> ".$row["Employee_Salary"]."</td>
             <td> ".$row["Bank_ID"]."</td>
             <td><a href=\"Delete-employee.php?form_submitted=1&Employee_ID=".$row["Employee_ID"]."\">Remove</a></td></tr>";
             }
        echo "</table>"; // close the table
        echo "There are ". $result->num_rows . " results.";
       // Don't render the table if no results found
      } else {
        echo "0 results";
                                                                                                                          }
 }
 ?>
<body>
<p><h2>University accounts Delete:</h2></p>
<p><h2>List of Bank:</h2></p>
<?php
displayFaculty();
?>
<form action="Delete-employee.php" method=get>
                <input type="hidden" name="form_submitted" >
                <input type="hidden" name="Employee_ID" >
</form>
<?php

if (isset($_GET["form_submitted"])){
  if (!empty($_GET["Employee_ID"]) && !empty($_GET["form_submitted"]))
{
   $profID = $_GET["Employee_ID"]; //gets id from the form
   $sqlstatement = $conn->prepare("DELETE FROM employee where Employee_ID =?"); //prepare the statement
   $sqlstatement->bind_param("s",$profID); //insert the variables into the ? in the above statement
   $sqlstatement->execute(); //execute the query
   echo $sqlstatement->error; //print an error if the query fails
   $sqlstatement->close();
 }
 else {
	 echo "<b> Error: Something went wrong with the form.</b>";
 }
header("Refresh:0;url=Delete-employee.php"); //refresh the page to show the faculty is gone
}
   $conn->close();
   ?> <!-- this is the end of our php code -->
   </body>
   </html>