Well, it sounds like you have it planned out already, which helps alot. First, you’ll need to plan out the data base, which from what i can see, would be at least 3 tables.
1 - student info (grade, classes, etc)
2 - teacher info (name, login info, etc)
3 - evaluation info (student_id, teacher_id, etc)
on the main page, i would start out with a simple listing of the students and maybe some of the their info. You can list which teachers have already evaluated the student too in that area. You can either use a url to get to the different areas and still use the same page and form using actions and GETs.
I do something just like this for our support tickets, the code is below.
[php]
if(isset($_POST[‘close’])) {
for($i = 0; $i < count($_POST[‘ck’]); $i++) {
//echo $_POST[‘ck’][$i]."
";
$rid = $_POST[‘ck’][$i];
mysql_query(“UPDATE venzo_contactus SET status = 0 WHERE req_id = ‘$rid’”) or die(mysql_error());
}
}
$query = mysql_query(“SELECT * FROM venzo_contactus WHERE status <> 0 ORDER BY date DESC”) or die(mysql_error());
$numrows = mysql_num_rows($query);
?>
| Req ID |
Submitted |
Status |
From |
Topic |
Updated On |
Ans'd by |
|
<?php
$date = date("Y-m-d");
$CurDate = strtotime($date);
$yesterday = strtotime("-1 day", $CurDate);
for($i = 0; $i < $numrows; $i++) {
$r = mysql_fetch_array($query);
$compare = strtotime($r[‘date’]);
if($compare > $yesterday) {
$new = "<span style='color: red;'>$r[req_id]</span>";
} else {
$new = $r['req_id'];
}
if($r['status'] == 0) {
$status = "Closed";
} else if($r['status'] == 1) {
$status = "On Hold";
} else if($r['status'] == 2) {
$status = "New";
} else if($r['status'] == 3) {
$status = "A.C.R";
} else if($r['status'] == 4) {
$status = "Updated";
}
if($r['subject'] == "") {
$r['subject'] = "Test";
}
if($r['last_answered_by'] == "") {
$ans = "<span style='color: red;'>Open</span>";
} else {
$ans = $r['last_answered_by'];
}
if($i % 2) {
echo "<tr bgcolor='#FFE6CC'>\n";
} else {
echo "<tr bgcolor='white'>\n";
}
if(empty($r['last_answered_by'])) {
$ans = "";
} else {
$val = explode(', ', $r['last_answered_by']);
$ans = end($val);
}
?>
<?php echo $new; ?> |
<?=date('m/d/Y', strtotime($r['createdon']))?> |
<?php echo $status; ?> |
<?php echo $r['email']; ?> |
<?php echo truncate(stripslashes($r['subject'])); ?> |
<?=date('m/d/Y', strtotime($r['date']))?> @ <?=date('h:i:s a', strtotime($r['date']))?> |
<?php echo $ans; ?> |
|
<?php } ?>
|
|
|
|
|
|
|
|
[/php]
I use both url’s and buttons to control user actions. I can click on the ticket topic to view the question, or if its an old ticket that hasn’t been updated in a while, i can check the box and hit close to close the ticket.
As far as editing goes, that all depends on how and what you want to edit. I would suggest first getting the evaluation form converted to html, get all the fields named and then go from there. Its alot easier to troubleshoot if its all on one page though.
