Skip to content
Permalink
master
Go to file
 
 
Cannot retrieve contributors at this time
43 lines (36 sloc) 1.26 KB
<?php
require("../dbCon.php");
require("../commonFunctions.php");
?>
<html>
<head>
<link rel="stylesheet" href="../style.css">
</head>
<body>
<div id="header">
<?php writeMenuAdm('Employees.php'); ?>
</div>
<div id='contentwrapper'>
<?php
$sql = "SELECT
EmployeeID, LastName, FirstName, Title, TitleOfCourtesy, BirthDate, HireDate, Address, City, Region, PostalCode, Country, HomePhone, Extension, ReportsTo, Salary
FROM employees WHERE EmployeeID = " . $_GET['EmployeeID'];
$result = $con->query($sql);
makeTable($result);
?>
<hr>
<?php
$sql = "SELECT Photo, Notes
FROM employees WHERE EmployeeID = " . $_GET['EmployeeID'];
$result = $con->query($sql);
$row = $result->fetch_assoc();
if ($row['Photo'] !== null){
loadPicture($row['Photo'], 40);
}
?>
<hr>
<h3>Notes:</h3>
<p><?php echo $row['Notes']; ?> </p>
</div>
</body>
</html>
You can’t perform that action at this time.