<head>
<title>Manager Level</title>
</head>
<body background="bg.gif"><font face="arial">
<center>
<img src="by_logo.gif" border=1>
<h2>Bankable You Software Solutions</H2>
<h3><u>Manager Level</u></h3>
<b>Welcome to the Manager Level Administrative Site! In this area you will be able to add, remove, view, or edit information about NE Georgia Sales Customers and drivers, as well as generate reports.</b><br><br>
<table background="bg.gif" cellpadding="5" cellspacing="5" border="0">
<tr><td><font face="arial">
<?
session_start();
if($m_login != "OK"){
header("Location: http://ebiz.terry.uga.edu/~smiller/admintoolS/mgrLogin.html");
exit;
}
else if($m_login =="OK"){
$db_name = "test_sandra";
$table_name = "CUSTOMER";
$connection = @mysql_connect("localhost", "smiller", "mill1823") or die("Couldn't connect.");
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select database.");
$sql_1 = "SELECT customerid, storename FROM $table_name ORDER BY storename";
$result_1 = @($sql_1, $connection) or die("Couldn't execute query.");
while($item_1 = mysql_fetch_array($result_1)){
$customerid = $item_1['customerid'];
$storename = $item_1['storename'];
$option_block .="<option value = \"$customerid\">$storename </option>";
}
$form_block1 = "
<form name=\"eventForm1\" method=\"POST\" action= \"customer.php\">
<SELECT NAME=Customer>
<OPTION VALUE=Default>Please select customer
<OPTION VALUE=null>-----------
$option_block;
</SELECT><br></td>
<td><font face=\"arial\"><a href=\"custview.php\">View all</a></td>
<td><font face=\"arial\"><a href=\"addcust.php\">Add new</a></td></tr>
<tr><td colspan=\"3\"><input type=\"subnit\" value=\"Remove\"> <input type=\"submit\" value=\"View Report\">
<input type=\"submit\" value=\"Edit\"></td></tr>
</form>
";
echo "$form_block1";
?>
<tr><td colspan=\"3\"><center><font face=\"arial\">
<b>-- OR --</b></center></td></tr>
<tr><td><font face="arial">
<?
$db_name = "test_sandra";
$table_name = "DRIVER";
$connection = @mysql_connect("localhost", "smiller", "mill1823") or die("Couldn't connect.");
$db = @mysql_select_db($db_name, $connection) or die("Couldn't select database.");
$sql_2 = "SELECT driverid, dfname, dlname FROM $table_name ORDER BY dlname";
$result_2 = @($sql_2, $connection) or die("Couldn't execute query.");
while($item_2 = mysql_fetch_array($result_2)){
$driverid = $item_2['driverid'];
$dfname = $item_2['dfname'];
$dlname = $item_2['dlname'];
$option_block_2 .="<option value = \"$driverid\">$dlname, $dfname </option>";
}
$form_block2 ="
<form name=\"eventForm2\" method=\"POST\" action=\"customer.php\">
<SELECT NAME=Customer>
<OPTION VALUE=Default>Please select driver
<OPTION VALUE=null>------------------
$option_block_2;
</SELECT></td>
<td><font face=\"arial\"><a href=\"driverview.php\">View all</a></td>
<td><font face=\"arial\"><a href=\"adddriver.php\">
Add new</a></td></tr>
<tr><td colspan=\"3\"><input type=\"submit\" value=\"Remove\"> <input type=\"submit\" value=\"View Report\">
<input type=\"submit\" value=\"Edit\"></td></tr>
</form>
</table>
";
echo "$form_block2";
?>
<br><br>
<center>
<a href="index.html">Return to the home page</a>
<a href = "mgrLogin.html">Return to manager login page</a>
</center>
</body>
