0

Please help me :)
how to do this? Student post an assignment to the supervisor.
Supervisor will receive that assignment and approve it whether click button YES or NO.
The question here is,
how to show YES or NO statement at the student page after supervisor has approved their assignment?
Thank you.

3
Contributors
7
Replies
25
Views
3 Years
Discussion Span
Last Post by chocolatte.lavista_1
0

is it enough if we just use <a href=""> only?
This is the coding,

<?php
session_start();


if ($_SESSION['NAME']=="") {
    echo "<script>document.location.href='index.php'</script>";
        exit;} 
$id= $_SESSION['id'];

include "code.php";

$query="SELECT student.name, student.matric, student.session, data.title, data.day, data.month, data.year, data.hour, data.minute, data.timing
FROM student 
INNER JOIN data
ON student.matric = data.matric
WHERE student.session='2013/2014'
ORDER BY student.name, data.day, data.month, data.year;";
$sql=mysql_query($query) or die("Error 1");
$rows=mysql_num_rows($sql);
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Student Supervision System</title>

<script type="text/javascript">
function MM_jumpMenu(targ,selObj,restore){ //v3.0
  eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  if (restore) selObj.selectedIndex=0;
}
</script>

</head>

<body>
<p align="center">
  <img src="img/bnnr13.jpg" width="1000" height="180"></p>

  <p align="center">
    Welcome <? echo  "<b>".$_SESSION['SV_FIRST_NAME']."!</b>";?>
    </p>
<table width="1115" height="550" border="1" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><!--<p align="right">

    Welcome <? echo  "<b>".$_SESSION['SV_FIRST_NAME']."!</b>";?>
    <br /><br /></p>-->
      <br /><div align="center">
        <?php include "sv_menu.php";?>

      </div>
      <h1 align="center"><u>Student's List</u></h1>

<table width="177" height="49" border="1" align="center">
      <tr>
        <th width="57" height="45" scope="row">Session</th>
        <td width="8" align="center">
        :
        </td>
        <td width="113">
        <form name="form" id="form">
          <select name="jumpMenu2" id="jumpMenu2" onchange="MM_jumpMenu('parent',this,0)">
            <option value="sv_student_list2.php">2013/2014</option>
            <option value="sv_student_list.php">2011/2012</option>
            <option value="sv_student_list3.php">2012/2013</option>
          </select>
        </form></td>
      </tr>
    </table>
    <br /><br />
    <table width="1005" height="277" border="1" align="center">
      <tr>
        <th width="373" align="center" scope="row">Name</th>
        <td width="129" align="center">Matric Number</td>
        <td width="146" align="center">Document's Title</td>
        <td width="109" align="center">Date Send</td>
        <td width="81" align="center">Time</td>
        <td width="127" align="center">Document Approval</td>
      </tr>

    <?
    while($row = mysql_fetch_array($sql))
    {
    $fullname = $row['name'];
    $matrik = $row['matric'];
    $title = $row['title'];
    $day = $row['day'];
    $month = $row['month'];
    $year = $row['year'];
    $hour = $row['hour'];
    $minute = $row['minute'];
    $timing = $row['timing'];
    ?>
      <tr>
        <th scope="row" align="left"><?php echo $fullname; ?>&nbsp;</th>
        <td align="center"><?php echo $matrik; ?>&nbsp;</td>
        <td align="center"><a href="sv_student_report.php">
        <a href='sv_student_report.php?stdata=<? echo $matrik;?>'><?php echo $title; ?></a>&nbsp;</td>
        <td align="center"><?php echo $day."/".$month."/".$year; ?>&nbsp;</td>
        <td align="center"><?php echo $hour.":".$minute." ".$timing; ?>&nbsp;</td>
        <td align="center">
        <a href="sv_yes.php">YES</a> / <a href="sv_no.php">NO</a></td>
      </tr>
      <? } ?>
      <tr>
        <th scope="row" align="left">&nbsp;</th>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
      </tr>
      <tr>
        <th scope="row" align="left">&nbsp;</th>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
      </tr>
      <tr>
        <th scope="row" align="left">&nbsp;</th>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
      </tr>
      <tr>
        <th scope="row" align="left">&nbsp;</th>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
      </tr>
      <tr>
        <th scope="row" align="left">&nbsp;</th>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
      </tr>
      <tr>
        <th scope="row" align="left">&nbsp;</th>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
      </tr>
      <tr>
        <th scope="row" align="left">&nbsp;</th>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
        <td align="center">&nbsp;</td>
      </tr>
    </table></td>
  </tr>
</table><br />

</body>
</html>
0

Link "<a href" for teacher, for student just display the status.
You save the status in database I supouse ?

0

I guess you must be having status or approved column in your table
you can add same column in your query and display it

SELECT student.name, student.matric, student.session, data.title, data.day, data.month, data.year, data.hour, data.minute, data.timing, data.status
0

that's mean I need to add data.status right?
Thanks. I'll try.
But can we use "<a href" to move the data status into database?
What method that we need use to link the data status into database?
Is it $_POST?

0

first you have to create page for senior to approve the record status

where they set status to approve or unapprove, all pending records

same status can be displayed to junior login.

a href is only html link. you can not achieve updation of database using html links.

YOu need to create process page as I suggested in first line of this message

post and get are 2 methods in which html form elements are submitted to post and get php arrays, which can be processed by php handler code to update database.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.