Guest User

Untitled

a guest
Nov 22nd, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.42 KB | None | 0 0
  1. public function editmanger($ID,$Blood_BankID,$FirstName,$LastName, $EmployeeType)
  2. {global $conn;
  3. try
  4. {$statement = $this->conn->prepare("UPDATE Employees SET Blood_BankID =:Blood_BankID, FirstName =:FirstName, LastName =:LastName,
  5. EmployeeType =:EmployeeType WHERE EmployeeID = :ID ");
  6. $stmt->bindparam(":Blood_BankID", $Blood_BankID);
  7. $stmt->bindparam(":FirstName", $FirstName);
  8. $stmt->bindparam(":LastName", $LastName);
  9. $stmt->bindparam(":EmployeeType", $EmployeeType);
  10. $stmt->execute();
  11. }catch(PDOException $e)
  12. {
  13. echo $e->getMessage();
  14. }
  15. }
  16.  
  17. <html>
  18. <body>
  19.  
  20.  
  21.  
  22.  
  23.  
  24. <form method="POST" action="?" enctype="multipart/form-data">
  25. <table class="table1">
  26. <tr>
  27. <td><label style="color:#3a87ad; font-size:18px;">Blood_BankID</label></td>
  28. <td width="30"></td>
  29. <td><input type="text" name="Blood_BankID" placeholder="Blood_BankID" required /></td>
  30. </tr>
  31. <tr>
  32. <td><label style="color:#3a87ad; font-size:18px;">FirstName</label></td>
  33. <td width="30"></td>
  34. <td><input type="text" name="FirstName" placeholder="FirstName" required /></td>
  35. </tr>
  36.  
  37. <tr>
  38. <td><label style="color:#3a87ad; font-size:18px;">LastName</label></td>
  39. <td width="30"></td>
  40. <td><input type="text" name="LastName" placeholder="LastName" required /></td>
  41. </tr>
  42. <tr>
  43. <td><label style="color:#3a87ad; font-size:18px;">EmployeeType</label></td>
  44. <td width="30"></td>
  45. <td><input type="text" name="EmployeeType" placeholder="EmployeeType" required /></td>
  46. </tr>
  47.  
  48. </table>
  49.  
  50.  
  51. </div>
  52. <div class="modal-footer">
  53.  
  54. <button type="submit" name="editform" class="btn btn-primary">Edit</button>
  55. </div>
  56.  
  57.  
  58. </form>
  59.  
  60. </body>
  61. </html>
  62.  
  63. if (isset($_POST['editform']))
  64. {
  65. try
  66.  
  67. {
  68.  
  69.  
  70.  
  71. $Blood_BankID=strip_tags($_POST['Blood_BankID']);
  72. $FirstName=strip_tags($_POST['FirstName']);
  73. $LastName=strip_tags($_POST['LastName']);
  74. $EmployeeType=strip_tags($_POST['EmployeeType']);
  75. $get_id=$_POST['id'];
  76. $auth_user->editmanger ($get_id,$Blood_BankID,$FirstName,$LastName, $EmployeeType);
  77.  
  78. }
  79. if(isset($_GET['editmanger']))
  80. {
  81.  
  82. include'editform.php';
  83.  
  84.  
  85. exit();
  86. }
  87.  
  88. <table >
  89. <?php foreach ($stmt as $employee): ?>
  90. <tr>
  91. <td> <?php echo $employee['EmployeeID']; ?> </td>
  92. <td style= "width:150px"> <?php echo $employee['Blood_BankID']; ?> </td>
  93. <td> <?php echo $employee['FirstName']; ?> </td>
  94. <td> <?php echo $employee['LastName']; ?> </td>
  95. <td> <?php echo $employee['EmployeeType']; ?> </td>
  96.  
  97. <td>
  98. <form action="?deleteDept" method="post">
  99. <input type="hidden" name="id" value="<?php echo $employee['EmployeeID']; ?>">
  100. <input type="submit" value="delete">
  101. </form>
  102. <form action="?editmanger" method="POST">
  103. <input type="hidden" name="id" value="<?php echo $employee['EmployeeID']; ?>">
  104. <input type="submit" value="Edit">
  105. </form>
  106.  
  107. </td>
  108. </tr>
  109. <?php endforeach; ?>
  110. </table>
Add Comment
Please, Sign In to add comment