<?php
session_start();

error_reporting(0);
if(phpversion() >= "4.2.0") {
$postvars = $HTTP_POST_VARS;
$getvars = $HTTP_GET_VARS;
extract($HTTP_POST_VARS);
extract($HTTP_GET_VARS); 
}
require("_header.php");


echo "<P><center><img src=\"images/steelers04.gif\">\n";

echo "<P><table border=1 width=80% bordercolor=\"#DDDDDD\" cellspacing=0 cellpadding=2 class=\"text\"><tr>\n";
echo "<td><b>Order</b></td>\n";
echo "<td><b>Purchaser</b></td>\n";
echo "<td><b>Qty</b></td>\n";
echo "<td><b>Guests</b></td>\n";
echo "<td><b>Paid</b></td>\n";
echo "<td><b>Amount</b></td>\n";
echo "</tr>\n";

// Connect to DB
$db = mysql_connect("localhost", "i5thacec", "miff0609");
if (!$db) {   echo "Error: Could not connect to DB.<br>" . mysql_error(); exit;    }
mysql_select_db("i5thacec_fifthace");

if ($_POST["act"] == "add") {
	$sql = "INSERT INTO tbl_attendees (att_purchaser,att_email,att_qty,att_guests,att_paid,att_amount) ";
	$sql .= "VALUES ('".$_POST["purchaser"]."','".$_POST["email"]."',".$_POST["qty"].",'".$_POST["guests"]."',".$_POST["paid"].",".$_POST["amount"].")";
	$result = mysql_query($sql);	
}

$sql = "SELECT * FROM tbl_attendees";
$result = mysql_query($sql);

if (mysql_numrows($result) > 0) {
		for ($i=0; $i < mysql_numrows($result); $i++) {
			  $row = mysql_fetch_array($result);
				echo "<tr>\n";
				echo "<td>".($i+1)."</td>\n";
				echo "<td><a href=\"mailto:".$row["att_email"]."\" class=\"text\">".$row["att_purchaser"]."</a></td>\n";
				echo "<td>".$row["att_qty"]."</td>\n";
				echo "<td>".$row["att_guests"]."</td>\n";
				echo "<td>".($row["att_paid"]==1?"Yes":"No")."</td>\n";
				echo "<td>$".$row["att_amount"]."</td>\n";
				echo "</tr>\n";		
		}
} else {
		echo "<tr><td colspan=6 align=center>No Orders Yet</td></tr>\n";
}

echo "</table>\n";


echo "<br><br><br><br><table border=0 width=80% cellspacing=0 cellpadding=2 class=\"text\">\n";
echo "<form action=\"steelers_list.php\" method=\"post\">\n";
echo "<input type=\"hidden\" name=\"act\" value=\"add\">\n";
echo "<tr><td><b>Purchaser:</b></td><td><input type=\"text\" size=25 name=\"purchaser\"></td></tr>\n";
echo "<tr><td><b>Email:</b></td><td><input type=\"text\" size=25 name=\"email\"></td></tr>\n";
echo "<tr><td><b>Qty:</b></td><td><input type=\"text\" size=2 name=\"qty\"></td></tr>\n";
echo "<tr><td><b>Guests:</b></td><td><input type=\"text\" size=40 name=\"guests\"></td></tr>\n";
echo "<tr><td><b>Paid:</b></td><td><SELECT name=\"paid\"><option value=1>Yes</option><option value=2>No</option></SELECT></td></tr>\n";
echo "<tr><td><b>Amount:</b></td><td>$<input type=\"text\" size=8 name=\"amount\" value=\"0.00\"></td></tr>\n";
echo "</table>\n";
echo "<input type=\"submit\" size=4 value=\"Add Guests to List\">\n";
echo "</form>\n";
echo "</center>\n";

require("_footer.php");
?>