EmployeeManagementSystem/we2.php at master · purva98/EmployeeManagementSystem · 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
<!DOCTYPE html>
<html>
<head>
  <title>Resign Applicants</title>
</head>
</html>


<?php

include ('connsp.php');
include('we1.php');
session_start();


 if(isset($_REQUEST['submit']))
{

  $dol=$_REQUEST['dol'];

  //exit();
  $dateTime = new DateTime($dol);
  $dol= date_format($dateTime,'Y-m-d');
//  echo $dol;

  $upd="UPDATE resign SET dol='$dol' WHERE emlid=$v1 ";
  $sql = "DELETE FROM teacher WHERE empid=$v1";
//  echo $upd;
//  exit();
  $res=$connsp->query($upd);

if($res AND $connsp->query($sql))
{
  //alert("insert success");
  ?>
    <script type="text/javascript">
      alert(' dol insert success and deleted successfully');
      //window.location="applicants.php";
    </script>
    <?php
}
else
{
  echo "insert not success";
}
}
?>
<div style="color: black; font-color:red; font-family: arial;font-size: 30px">Following is the list of updated list of resignants:
</div>
<?php
include('we1.php');
?>