Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function editmanger($ID,$Blood_BankID,$FirstName,$LastName, $EmployeeType)
- {global $conn;
- try
- {$statement = $this->conn->prepare("UPDATE Employees SET Blood_BankID =:Blood_BankID, FirstName =:FirstName, LastName =:LastName,
- EmployeeType =:EmployeeType WHERE EmployeeID = :ID ");
- $stmt->bindparam(":Blood_BankID", $Blood_BankID);
- $stmt->bindparam(":FirstName", $FirstName);
- $stmt->bindparam(":LastName", $LastName);
- $stmt->bindparam(":EmployeeType", $EmployeeType);
- $stmt->execute();
- }catch(PDOException $e)
- {
- echo $e->getMessage();
- }
- }
- <html>
- <body>
- <form method="POST" action="?" enctype="multipart/form-data">
- <table class="table1">
- <tr>
- <td><label style="color:#3a87ad; font-size:18px;">Blood_BankID</label></td>
- <td width="30"></td>
- <td><input type="text" name="Blood_BankID" placeholder="Blood_BankID" required /></td>
- </tr>
- <tr>
- <td><label style="color:#3a87ad; font-size:18px;">FirstName</label></td>
- <td width="30"></td>
- <td><input type="text" name="FirstName" placeholder="FirstName" required /></td>
- </tr>
- <tr>
- <td><label style="color:#3a87ad; font-size:18px;">LastName</label></td>
- <td width="30"></td>
- <td><input type="text" name="LastName" placeholder="LastName" required /></td>
- </tr>
- <tr>
- <td><label style="color:#3a87ad; font-size:18px;">EmployeeType</label></td>
- <td width="30"></td>
- <td><input type="text" name="EmployeeType" placeholder="EmployeeType" required /></td>
- </tr>
- </table>
- </div>
- <div class="modal-footer">
- <button type="submit" name="editform" class="btn btn-primary">Edit</button>
- </div>
- </form>
- </body>
- </html>
- if (isset($_POST['editform']))
- {
- try
- {
- $Blood_BankID=strip_tags($_POST['Blood_BankID']);
- $FirstName=strip_tags($_POST['FirstName']);
- $LastName=strip_tags($_POST['LastName']);
- $EmployeeType=strip_tags($_POST['EmployeeType']);
- $get_id=$_POST['id'];
- $auth_user->editmanger ($get_id,$Blood_BankID,$FirstName,$LastName, $EmployeeType);
- }
- if(isset($_GET['editmanger']))
- {
- include'editform.php';
- exit();
- }
- <table >
- <?php foreach ($stmt as $employee): ?>
- <tr>
- <td> <?php echo $employee['EmployeeID']; ?> </td>
- <td style= "width:150px"> <?php echo $employee['Blood_BankID']; ?> </td>
- <td> <?php echo $employee['FirstName']; ?> </td>
- <td> <?php echo $employee['LastName']; ?> </td>
- <td> <?php echo $employee['EmployeeType']; ?> </td>
- <td>
- <form action="?deleteDept" method="post">
- <input type="hidden" name="id" value="<?php echo $employee['EmployeeID']; ?>">
- <input type="submit" value="delete">
- </form>
- <form action="?editmanger" method="POST">
- <input type="hidden" name="id" value="<?php echo $employee['EmployeeID']; ?>">
- <input type="submit" value="Edit">
- </form>
- </td>
- </tr>
- <?php endforeach; ?>
- </table>
Add Comment
Please, Sign In to add comment