Time Is Money (part 2) - In... (
Page 4 of 11 )
The two halves of "view.php" correspond to two
different form processors, "delete.php" and "add.php" respectively. Let's look
at "add.php" first.
<?
// add.php - add timesheet entry
// includes
// checks
// if all checks pass
// open connection to database
$connection = mysql_connect($hostname, $user, $pass) or die ("Unable to
connect!");
// create datestamp
$datestamp = $y . "-" . $m . "-" . $d;
// insert data
$query = "INSERT INTO log (pid, tid, uid, hours, date) VALUES ('$pid',
'$tid', '$SESSION_UID', '$h', '$datestamp')";
$result = mysql_db_query($database, $query, $connection) or die ("Error in
query: $query. " . mysql_error());
// close connection
mysql_close($connection);
// redirect back
header("Location:view.php?d=$d&m=$m&y=$y");
?>
The data received from the form in "view.php" - project, task
and hour values - is used by this script to formulate an INSERT query and insert
the entry into the "log" table. The $SESSION_UID variable is used to identify
which user this entry belongs to.
Once the data has been inserted, the
browser is redirected back to the page it came from, using the datestamp values
passed to it from "view.php".
/ 4 
