Timesheet Woes

Anon

I'm trying to code a timesheet web page/database application that consists of a form in which the user enters his/her timesheet details - the results of which are then submitted to a mySQL database.

The mySQL database works well and the data submits, but the web design calls for each entry to be added immediately following submission into a table at the bottom of the page. This table is written in and therein lies the problem.

I don't know how to enter details into HTML tables based on user input.

For example, if the user worked for one hour in the morining, he or she would enter the details pertaining to that hour (i.e. Start/Finish Time, Hours Worked, Job Description etc) and click submit.

The form then reloads and this data then n needs to be in the HTML table. If the process is repeated, the next entry should be in the same table, but on the next row.

This cycle should continue - each subsequent entry must be on the line below it - until
terminated by the user by clicking on a "Completed" button.

Anyway, I know my explanation is not very clear, but basically I need to know how to send form data to specific rows, columns and cells of an HTML table.

Any assistance would be greatly appreciated - its driving me crazy!

                    Thanks!

Anon

You have to save the all datas in the mysql table, so that you can call the "old" lines (with a query) in order to show them in the table.
The other solution would be to save the datas in a session variable.
I know I'm not clear at all :/ but after the form submution you will add in a table or a variable or anything you can call in the called page and then you build your table with a loop.
Clear ? 😉)

Anon

Im not quite sure what you mean by :-

"This cycle should continue - each subsequent entry must be on the line below it - until
terminated by the user by clicking on a 'Completed' button"

But placing database records (rows) into a HTML table is very easy indeed.
<!- CODE BLOCK -->
<?php
$db = mysql_connect("username", "pass");
mysql_select_db("yourdatabase",$db);
$result = mysql_query("SELECT Statement",$db);
if($records = mysql_fetch_array($result)) {
echo "<table border=1>\n";
echo "<tr><td>field1</td><td>field2</td> </tr>\n";

do {

printf("<tr><td>%s %s</td><td>%s</tr> \n", $myrow["field1"], $myrow["field2"]);

}

while ($myrow = mysql_fetch_array($result));
echo "</table>\n";
} else {
echo "Sorry, no records were found!"; }
?>

Thats it

Anon

Sorry the variable $myrow on line 23 should be $records!

Regards

Sacevoy!

kparker

Actually, you can get by without saving anything until the entire set of data is entered. The key to doing this is to name all the <input> fields with brackets:

for ($i = 0; $i <= sizeof($start); $i++ )
  {
  echo '<tr><td>';
  echo "<input type=text name=\"start[]\" value=\"" . $start[$i] . '>';
  // etc for the other fields...
  echo '</td></tr>';
  }

That "less-than-OR-EQUAL" is not an off-by-one error. Rather, it causes the table to contain one extra set of blank entry fields at the bottom.