-
Notifications
You must be signed in to change notification settings - Fork 6
/
Copy pathloademployee.php
22 lines (22 loc) · 995 Bytes
/
loademployee.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
<?php
include "connection.php";
$sql = "SELECT * FROM employee ORDER BY id DESC";
$result34 = mysql_query($sql) or die("Failed Sql Query");
while ($row3 = mysql_fetch_assoc($result34)) {
$id = $row3['id'];
$employee = $row3['employee_no'];
$surname = $row3['surname'];
$lastname = $row3['lastname'];
echo "<tr class='prev' id='pre$id'>";
echo "<td>".$row3['employee_no']."</td>";
echo "<td> $surname $lastname </td>";
echo "<td>".$row3['dept']."</td>";
echo "<td>".$row3['position']."</td>";
echo "<td>".$row3['phoneno']."</td>";
echo "<td>".date_only($row3['joined'])."</td>";
echo "<td><div class='btn btn-info view-button' did='$id'>View</div></td>";
echo "<td><div class='btn btn-danger delete-button' did='$id'>Delete</div></td>";
echo "<td><a href='printprofile.php?employee=$employee' class='btn btn-info' target='_new'>Print</a></td>";
echo "</tr>";
}
?>