Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
43 lines (35 sloc) 1.39 KB
<?php
require("../dbCon.php");
require("../commonFunctions.php");
$sql = "SELECT * FROM employees WHERE EmployeeID = '" . $_SESSION["EmployeeID"] . "'";
//echo $sql;
if (!$result = $con->query($sql)) {}
$row = $result->fetch_assoc();
if ($row) {
$FirstName = $row['FirstName'];
}
//echo "Welcome " . $_SESSION["userName"] . "!";
?>
<html>
<head>
<link rel="stylesheet" href="../style.css">
</head>
<body>
<div id="header">
<?php writeMenuEmp(basename($_SERVER['PHP_SELF'])); ?>
</div>
<div id='contentwrapper'>
<h1>Active orders</h1>
<hr>
<?php
$sql = "SELECT OrderID, CustomerID, OrderDate, RequiredDate, ShipVia, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry, CompanyName, Address, City, Region, PostalCode, Country
FROM northwind.`orders qry` WHERE EmployeeID is null OR ShippedDate is null ORDER BY RequiredDate ASC;";
if (!$result = $con->query($sql)){}
$trArgs = array("onclick=\"window.document.location='ViewOrder.php?orderID=%OrderID%'\"",
array('%OrderID%' => 'OrderID')
);
makeTable($result, $trArgs);
?>
</div>
</body>
</html>
You can’t perform that action at this time.