[Resolved] [Resolved] submitting a form then displaying the result on the same page

timmybuck

Hi Guys,

im creating a help desk system but am stuck. I would it so that when a technican views a job he can submit a comment about it eg action taken. Once he has submitted this it is stored and the next technican can come along and read what he has done and then carry out his part and then resubmit the form. so really one job can be dealt with by many technicans.so in a effect we build up a history.

i have two tables one for the user called request_table and one for the tech guys called tech_table.

This code below shows the job details and a form that allows the technican to submit a comment about it.

</head>
<body>
<?php
$jobId=$_GET['jobId'];

mysql_connect("localhost","phpuser","phpuser03") or die ("Database connection error");
mysql_select_db( helpdesk);

$sql = "select jobId, email, room, computers, description, date FROM requests_table

WHERE requests_table.jobId='$jobId'";

$result = mysql_query($sql);
echo mysql_error() ;

echo "<table>\n";

echo " <tr>\n";

echo " <th><b>JobID</b></th>\n";

echo " <th><b>email</b></th>\n";

echo " <th><b>Room</b></th>\n";

echo " <th><b>Computers</b></th>\n";

echo " <th><b>description</b></th>\n";

echo " <th><b>date & time</b></th>\n";

echo " </tr>\n";

while ($row = mysql_fetch_array($result)) {

echo '<td>'.$row['jobId'].'</td>'; 
echo '<td>'.$row['email'].'</td>'; 
echo '<td>'.$row['room'].'</td>'; 
echo ' <td>'.$row['computers'].'</td>'."\n";   
echo ' <td>'.$row['description'].'</td>'."\n"; 
echo ' <td>'.$row['date'].'</td>'."\n"; 
echo  '</tr>'."\n";    
echo '</table>';
}

?>
<br>
<br>

<p> </p>
<p> </p>
<table width="994" height="132" border="0">
<tr>
<th width="75" scope="row">Tech Id </th>
<td width="348"><strong>Action taken </strong></td>
<td width="118"><strong>Date & time </strong></td>
<td width="338"><strong>Email comment </strong></td>
<td width="93"><strong>Status of Job </strong></td>
</tr>
<tr>
<th scope="row"><form name="form5" method="post" action="">
<input name="textfield" type="text" size="5" maxlength="5">
</form></th>
<td><form name="form1" method="post" action="">
<textarea name="textarea" cols="35" rows="5"></textarea>
</form></td>
<td> </td>
<td><form name="form2" method="post" action="">
<textarea name="textarea" cols="35" rows="5"></textarea>
</form></td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td><form name="form3" method="post" action="">
<input type="submit" name="Submit1" value="Submit">
</form></td>
<td> </td>
<td><form name="form4" method="post" action="">
<input type="submit" name="Submit" value="Submit">
</form></td>
<td> </td>
</tr>
</table>

i also have some code that i think i need to inlude in the above code. this code is supposed to allow the technican to actually submit the form. i would also like the the sumbitted information to display straight away ont he same page and the form ready fpr antoher tech guy to make a comment.

<?php
if($_POST["Submit1"]) {

$action_taken = addslashes($_POST['action_taken']);
$db = @mysql_connect('localhost', 'phpuser', 'phpuser03') or die('Could not connect to the database: '.mysql_error());
@mysql_select_db('helpdesk') or die('Could not select the database: '.mysql_error());

$result = mysql_query('INSERT INTO tech_table (jobId, 'Tech_initals', action_taken, date)'.
"VALUES ('$jobId','$Tech_initals','$action_taken', NOW())") or die('Unable to insert record. '.mysql_error());
?>

can anyone help or advise

FMB

When I look at this, I question myself, how many freking submit buttons does on need for ONE form?

The only answer I can come up with is ONE (1) !

I count 2 submit buttons and 5 forms!!!!!!

Restart coding using one (1) form and one (1) submit button. If that fails to solve your problem come back and ask again.

{sorry if I'm sounding like an ass}

timmybuck

ok yes you are right, i have made some changes

here is my code below at the momment i have two forms and two submit buttons. At the momment im trying to get the details form to work. i can get it to post to the database, but i also want it to post to same page at the bttom so that people can read the action_taken. ata the momment it's not outputting in properly in my html table. no content is being out putted

</head>
<body>
<?php

$jobId=$_GET['jobId'];

mysql_connect("localhost","phpuser","phpuser03") or die ("Database connection error");
mysql_select_db( helpdesk);

$sql = "select jobId, email, room, computers, description, date FROM requests_table

WHERE requests_table.jobId='$jobId'";

$result = mysql_query($sql);
echo mysql_error() ;

while ($row = mysql_fetch_array($result)) {

echo '<td>'.$row['jobId'].'</td>'; 
echo '<td>'.$row['email'].'</td>'; 
echo '<td>'.$row['room'].'</td>'; 
echo ' <td>'.$row['computers'].'</td>'."\n";   
echo ' <td>'.$row['description'].'</td>'."\n"; 
echo ' <td>'.$row['date'].'</td>'."\n"; 
echo  '</tr>'."\n";    
echo '</table>';
}

?>
<br>
<br>
<form name="details" method="post" action= "<? echo $_SERVER['PHP_SELF'] . "?jobId=" . $jobId; ?>">
<table width="374" height="160" border="0">
<tr>
<th width="54" scope="row">TechId</th>
<td width="250"><strong>Action taken </strong></td>
<td width="56"> </td>
</tr>
<tr>
<th scope="row"><input name="Tech_initals" type="text" size="8" maxlength="5"></th>
<td><textarea name="action_taken" cols="35" rows="5"></textarea></td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td><input type="submit" name="Submit1" value="Submit"></td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
</tr>
</table>
</form>
<form name="form2" method="post" action="">
<table width="374" height="160" border="0">
<tr>
<th width="54" scope="row">Status of job </th>
<td width="250"><strong>Email comment </strong></td>
<td width="56"> </td>
</tr>
<tr>
<th scope="row"><input name="techId" type="text" size="8" maxlength="5"></th>
<td><textarea name="action_taken" cols="35" rows="5"></textarea></td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td><input type="submit" name="Submit" value="Submit"></td>
<td> </td>
</tr>
<tr>
<th scope="row"> </th>
<td> </td>
<td> </td>
</tr>
</table>
</form>
<?php
$color[0] = "FCFCFC";

$color[1] = " 34ADE5 ";

$jobId=$GET['jobId'];
$action_taken=$GET['action_taken'];
$Tech_initals=$_GET['Tech_intials'];

if($_POST["Submit1"]) {

$action_taken = addslashes($POST['action_taken']);
$Tech_initals = addslashes($POST['Tech_initals']);

$db = @mysql_connect('localhost', 'phpuser', 'phpuser03') or die('Could not connect to the database: '.mysql_error());
@mysql_select_db('helpdesk') or die('Could not select the database: '.mysql_error());

$result = mysql_query('INSERT INTO tech_table (jobId, Tech_initals, action_taken, date)'.
"VALUES ('$jobId','$Tech_initals','$action_taken', NOW())") or die('Unable to insert record. '.mysql_error());

$sql = "SELECT 'jobId', 'Tech_initials', 'action_taken', 'date' FROM tech_table" ;

$result = mysql_query($sql);
echo "<table>\n";

echo " <tr>\n";

echo " <th><b>JobID</b></th>\n";

echo " <th><b>Tech Initals</b></th>\n";
echo " <th><b>Action taken</b></th>\n";

echo " <th><b>Date</b></th>\n";

echo " </tr>\n";

while ($row = mysql_fetch_array($result)) {

//print_r($result) ;
// echo mysql_error() ;
$a = ($a+1)%2;

echo '<tr bgcolor='.$color[$a] . ">\n";

echo '<td>'.$row['jobId'].'</td>';
echo ' <td>'.$row['Tech_initals'].'</td>'."\n";

echo ' <td>'.$row['action_taken'].'</td>'."\n";

echo ' <td>'.$row['date'].'</td>'."\n";
echo '</tr>'."\n";

//echo '</table>';
}}
?>

</body>
</html>