p align="left"><body bgcolor="#DAE3EB"> <a href="index.php"> На главную </a> <hr> <h1 align="center"> Журнал </h1> <hr> <br> <h3>Выберите страницу</h3> <br> <?php require("connect.php"); $result = mysql_query("select * FROM Subjects"); $link_edit = "jrnsubj.php"; print ("<div align=center><H3>Список журналов по предметам:</H3></div><br>"); print ("<div align=center><table border = 1>"); print ("<tr><td><strong>Номер</strong></td><td><strong>Предмет</strong></td></tr>\n"); if ($myrow = mysql_fetch_array($result)) { do { printf("<tr><td>%d</td><td><a href=\"%s?SubjID=%d\">%s </a></td></tr>\n",$myrow["SubjID"], $link_edit, $myrow["SubjID"], $myrow["SubjName"],"</div>"); } while ($myrow = mysql_fetch_array($result)); } ?> </body> </html> jrnsubj.php <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1251" /> <title>Журнал: занятия по предмету</title> </head> <body bgcolor="#DAE3EB"> <a href="index.php"> На главную </a> | <a href="jrnlst.php"> Назад </a> <hr> <?php require("connect.php"); $result = mysql_query("SELECT SubjName FROM Subjects WHERE SubjID = $SubjID"); $tmp1 = mysql_fetch_array($result); $currnam = $tmp1["SubjName"]; ?> <h1>Журнал занятий по предмету <?php echo $currnam ?></h1> <hr> <br> <?php require("connect.php"); $result = mysql_query ("SELECT * FROM Plan JOIN LessTypes ON Plan.LTypeID = LessTypes.LTypeID WHERE Plan.SubjID = $SubjID",$db); $link_edit="journal.php"; print ("<div align=center><H3>Список работ:</H3></div><br>"); print ("<div align=center><table border = 1>"); print ("<tr><td>Работа</td></tr>\n"); if ($myrow = mysql_fetch_array($result)) { do { printf("<tr><td><a href=\"%s?SubjID=%d<ypeID=%d&LNumb=%d\">%s %d</a></td></tr>\n", $link_edit, $myrow["SubjID"], $myrow["LTypeID"], $myrow["LNumb"], $myrow["LTypeName"], $myrow["LNumb"], "</div>"); } while ($myrow = mysql_fetch_array($result)); echo "</table>\n"; } mysql_close($db); ?> </body> </html> journal.php <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1251" /> <title>Журнал Занятия</title> </head> <body bgcolor="#DAE3EB"> <a href="index.php"> На главную </a> | <a href=<?php echo 'jrnsubj.php?SubjID='; echo $SubjID; echo'<ypeID='; echo $LTypeID; echo '&LNumb='; echo $LNumb; ?>> Назад </a> <hr> <?php require("connect.php"); $result = mysql_query("SELECT SubjName FROM Subjects WHERE SubjID = $SubjID "); $tmp1 = mysql_fetch_array($result); $currnam = $tmp1["SubjName"]; $result = mysql_query("SELECT LTypeName FROM LessTypes WHERE LTypeID = $LTypeID "); $tmp2 = mysql_fetch_array($result); $currnam1 = $tmp2["LTypeName"]; mysql_close($db); ?> <h1> <?php echo $currnam; echo ": "; echo $currnam1; echo " "; echo $LNumb;?> </h1> <hr> <?php require("connect.php"); $result = mysql_query("SELECT StudName, Mark FROM MarkJournal JOIN Students ON MarkJournal.StudID = Students.StudID WHERE SubjID = $SubjID AND LTypeID = $LTypeID AND LNumb = $LNumb"); if ($myrow = mysql_fetch_array($result)) { echo "<table border=1 align=center >\n"; echo "<tr><td><strong>ФИО</strong></td><td><strong>Оценка</strong></td></tr>\n"; do { printf("<tr><td>%s</td><td>%d</td></tr>\n", $myrow["StudName"], $myrow["Mark"]); } while ($myrow = mysql_fetch_array($result)); echo "</table>\n"; } mysql_close($db); ?> <div align="center"> <form name="mean" action=<?php echo 'journal.php?SubjID='; echo $SubjID; echo'<ypeID='; echo $LTypeID; echo '&LNumb='; echo $LNumb; ?> method="post"> <input type="submit" name="setmrk" value="Поставить оценку"> </form> </div> <?php if (@$setmrk) { ?> <div align="center"> <FORM name="mean" method="post" action=<?php echo 'journal.php?SubjID='; echo $SubjID; echo'<ypeID='; echo $LTypeID; echo '&LNumb='; echo $LNumb; ?> > <br> ФИО:<input type="text" name = "stname"> <br> Оценка:<input type="text" name = "mark"> <br> <input type="submit" name = "newmrk" value="Внести в журнал"><br> </FORM> </div> <?php } if (@$newmrk) { require("connect.php"); $result = mysql_query("SELECT StudID FROM Students WHERE StudName LIKE '%$stname%' "); $tmpstud = mysql_fetch_array($result); $tmpstudid = $tmpstud["StudID"]; mysql_query("UPDATE MarkJournal SET Mark = $mark WHERE SubjID = $SubjID AND LTypeID = $LTypeID AND StudID = $tmpstudid AND LNumb = $LNumb"); } ?> </body> </html> studtabchs.php <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1251" /> <title>Успеваемость</title> </head> <body bgcolor="#DAE3EB"> <a href="index.php"> На главную </a> <hr> <h1 align="center"> Выберите студента </h1> <hr> <br> <?php require("connect.php"); $result = mysql_query("SELECT * FROM Students"); $link_edit = "studtab.php"; print ("<div align=center><H3>Список студентов:</H3></div><br>"); print ("<div align=center><table border = 1>"); print ("<tr><td><strong>Номер</strong></td><td><strong>ФИО</strong></td><td><strong>Группа</strong></td></tr>\n"); if ($myrow = mysql_fetch_array($result)) { do { printf("<tr><td>%d</td><td><a href=\"%s?StudID=%d\">%s </a></td><td>%d</td></tr>\n",$myrow["StudID"], $link_edit, $myrow["StudID"], $myrow["StudName"], $myrow["GroupNum"],"</div>"); } while ($myrow = mysql_fetch_array($result)); } ?> </body> </html> studtab.php <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1251" /> <title>Общая успеваемость студента</title> </head> <body bgcolor="#DAE3EB"> <a href="index.php"> На главую </a> | <a href="studtabchs.php"> Назад </a> <hr> <?php require("connect.php"); $result = mysql_query("SELECT StudName FROM Students WHERE StudID = $StudID"); $tmp1 = mysql_fetch_array($result); $currnam = $tmp1["StudName"]; ?> <h1 align="center"><?php echo $currnam ?> : Общая успеваемость</h1> <hr> <br> <?php require("connect.php"); $result = mysql_query("SELECT SubjName, LTypeName, LNumb, Mark FROM ((MarkJournal JOIN Students ON MarkJournal.StudID = Students.StudID) JOIN Subjects ON MarkJournal.SubjID = Subjects.SubjID) JOIN LessTypes ON MarkJournal.LTypeID = LessTypes.LTypeID WHERE Students.StudID = $StudID",$db); if ($myrow = mysql_fetch_array($result)) { echo "<table border=1 align=center >\n"; echo "<tr><td><strong>Предмет</strong></td><td><strong>Работа</strong></td><td><strong>Номер</strong></td><td><strong>Оценка</strong></td></tr>\n"; do { printf("<tr><td>%s</td><td>%s</td><td>%d</td><td>%d</td></tr>\n", $myrow["SubjName"], $myrow["LTypeName"], $myrow["LNumb"], $myrow["Mark"]); } while ($myrow = mysql_fetch_array($result)); echo "</table>\n"; } mysql_close($db); ?> </body> </html> worst.php <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1251" /> <title>Неуспевающие</title> </head> <body bgcolor="#DAE3EB"> <a href="index.php"> На главную </a> <hr> <h1 align="center"> Неуспевающие </h1> <hr> <br> <?php require("connect.php"); $result = mysql_query("SELECT StudID, StudName, GroupNum FROM Students WHERE StudID NOT IN (SELECT StudID FROM MarkJournal WHERE Mark IS NOT NULL)",$db); if ($myrow = mysql_fetch_array($result)) { echo "<table border=1 align=center >\n"; echo "<tr><td><strong>Номер</strong></td><td><strong>ФИО</strong></td><td><strong>Группа</strong></td></tr>\n"; do { printf("<tr><td>%d</td><td>%s</td><td>%d</td></tr>\n", $myrow["StudID"], $myrow["StudName"], $myrow["GroupNum"]); } while ($myrow = mysql_fetch_array($result)); echo "</table>\n"; } else { echo "Sorry, no records were found!"; } mysql_close($db); ?> </body> </html> practice.php <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1251" /> <title>Практика</title> </head> <body bgcolor="#DAE3EB"> <a href="index.php"> На главную</a> <hr> <h1 align="center"> Практика </h1> <hr> <br> <?php require("connect.php"); $result = mysql_query("SELECT StudID, StudName, GroupNum, EntName FROM Students LEFT OUTER JOIN Enterprises ON Students.PractEntID = Enterprises.EntID",$db); if ($myrow = mysql_fetch_array($result)) { echo "<table border=1 align=center >\n"; echo "<tr><td><strong>Номер</strong></td><td><strong>ФИО</strong></td><td><strong>Группа</strong></td><td><strong>Практика</strong></td></tr>\n"; do { printf("<tr><td>%d</td><td>%s</td><td>%d</td><td>%s</td></tr>\n", $myrow["StudID"], $myrow["StudName"], $myrow["GroupNum"], $myrow["EntName"]); } while ($myrow = mysql_fetch_array($result)); echo "</table>\n"; } else { echo "Sorry, no records were found!"; } mysql_close($db); ?> <div align="center"> <FORM name=mean action=practice.php method=post> <br><INPUT type=submit value="Назначить предприятие" name=new2><BR><BR></FORM> </div> </div> <div align=center> <?php if (@$new2) { ?> <FORM name="mean" method="post" action=practice.php> <br> ФИО:<input type="text" name = "stname"> <br> Предприятие:<input type="text" name = "ent"> <br> <input type="submit" name = "entedit" value="Назначить"><br> </FORM> </div> <?php } if (@$entedit) { require("connect.php"); $sql = mysql_query("SELECT EntID FROM Enterprises WHERE EntName LIKE '%$ent%'"); $entid = mysql_fetch_array($sql); $tmp = $entid["EntID"]; mysql_query("UPDATE Students SET PractEntID = $tmp WHERE StudName LIKE '%$stname%' "); $result = mysql_query("SELECT StudID, StudName, GroupNum, EntName FROM Students LEFT OUTER JOIN Enterprises ON Students.PractEntID = Enterprises.EntID WHERE StudName LIKE '%$stname%'"); ?> <br> <div align=center><H4>Отредактировано:</H4></div><br> <div align=center><table border = 1> <tr><td> Номер </td> <td> ФИО </td> <td> Группа </td> <td> Предприятие </td> </tr> <?php while ($myrow = mysql_fetch_array($result)) { printf("<tr><td>%d",$myrow["StudID"],"</td>"); printf("<td>%s",$myrow["StudName"],"</td>"); printf("<td>%d",$myrow["GroupNum"],"</td>"); printf("<td>%s",$myrow["EntName"],"</td></tr>"); } } ?> </table> </div> </body> </html>
Страницы: 1, 2, 3, 4, 5
|