mark record read??
Posted: Tue Feb 17, 2004 2:47 pm
I have an online job application that has an admin section where the HR admin can see all applications that have been submitted online. What I want to do is allow the HR admin to select a checkbox when the application has been read and printed.
Here is my code:
My problem is that I have no clue how to make the work??
-How do I submit this to the database without a submit button?
-How do I put this checkbox into a form?or do I need to
Maybe I am going about this the wrong way, I would appreciate any help on this!
Thank you!!
Here is my code:
Code: Select all
<?php
$query = "SELECT * from application ORDER by appID DESC";
$result = mysql_query($query)
or die ("could not execute query");
echo "<table>\n";
echo "<tr align="left"><th width="40"><font face="Verdana" size="1"><b>Printed</b></font></th>
<tr align="left"><th width="120"><font face="Verdana" size="1"><b>Applicant Name</b></font></th>
<th width="120"><font face="Verdana" size="1"><b>Position Applied</b></font></th>
<th width="120"><font face="Verdana" size="1"><b>Application</b></font></th>
<th width="120"><font face="Verdana" size="1"><b>Date</b></font></th>
<th width="80"><font face="Verdana" size="1"><b>Resume</b></font></th>
<th width="80"><font face="Verdana" size="1"><b>Delete</b></font></th></tr>\n";
while ( $row = mysql_fetch_array($result))
{
extract($row);
echo "<tr>\n";
echo "<td width="40"><input type="checkbox" name="C1" value="ON"><br></td>\n";
echo "<td width="120"><font face="Verdana" size="1">$first_name $last_name</font><br></td>\n";
echo "<td width="120"><font face="Verdana" size="1">$position_apply</font><br></td>\n";
echo "<td width="120"><font face="Verdana" size="1"><a href="../show_app.php?appID=$appID" target="_blank">view application</a></font><br></td>\n";
echo "<td width="120"><font face="Verdana" size="1">$date</font><br></td>\n";
if(file_exists("../resume/".$first_name.$last_name.".doc")){
echo "<td width="80"><font face="Verdana" size="1"><a href="../resume/".$first_name.$last_name.".doc">Yes</a></font><br></td>\n";
} else {
echo "<td width="80"><font face="Verdana" size="1">No</font><br></td>\n";
}
echo "<td width="120"><font face="Verdana" size="1"><a href="../delete_app.php?appID=$appID" target="_blank">delete</a></font><br></td>\n";
}
echo "</tr></table>\n";
?>Code: Select all
<input type="checkbox" name="C1" value="ON">-How do I submit this to the database without a submit button?
-How do I put this checkbox into a form?or do I need to
Maybe I am going about this the wrong way, I would appreciate any help on this!
Thank you!!