<?
$dbhost = 'internal-db.s34309.gridserver.com';
$dbuser = 'db34309_team2502';
$dbpass = 'PASSWORD';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'db34309_team2502_hours';
mysql_select_db($dbname);

function check_input($data)
{
    $data = trim($data);
    $data = stripslashes($data);
    $data = htmlspecialchars($data);
    return $data;
}

$c = 0;
$i = 0;
for ($i=0; $i < 30; $i++)
{
	if(check_input($_POST["fn$i"]) != null)
	{
		$c++;
		$fn[$i] = check_input($_POST["fn$i"]);
		$ln[$i] = check_input($_POST["ln$i"]);
		$t[$i] = check_input($_POST["t$i"]);
	}
}

$i = 0;
for ($i=0; $i < $c; $i++)
{
	$query  = "SELECT * FROM `hours` WHERE `last` LIKE '". mysql_real_escape_string($ln[$i])."' AND `first` LIKE '".mysql_real_escape_string($fn[$i])."'";
	$result = mysql_query($query);

	while($row = mysql_fetch_array($result, MYSQL_ASSOC))
	{
		$ot[$i] = $row['hours'];
		$fn[$i] = $row['first'];
		$ln[$i] = $row['last'];
		$log[$i] = $row['log'];
	}
}

mysql_close($conn);
?>