p align="left"><input type="submit" name="wrst" value="Список неуспевающих"> </div> </form> <form name="mean" action="practice.php" method="post"> <br> <div align="center"> <input type="submit" name="prct" value="Направление на практику"> </div> </form> </body> </html> studlist.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="studlist.php"> Список студентов </a> | <a href="speclist.php"> Специальности </a> | <a href="subj-tch.php"> Дисциплины </a> | <a href="plan.php"> Учебный план </a> <hr> <h1 align="center" > Список студентов </h1> <hr> <br> <?php require("connect.php"); $result = mysql_query("SELECT * FROM Students ORDER BY 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></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); ?> <div align="center"> <FORM name=mean action=studlist.php method=post> <br><INPUT type=submit value="Добавить студента" name=new1><BR><BR></FORM> </div> <div align=center> <?php if (@$new1) { ?> <FORM name="mean" method="post" action=studlist.php> <br> ФИО:<input type="text" name = "stname"> <br> Номер:<input type="text" name = "stnum"> <br> Группа:<input type="text" name = "grnum"> <br> <input type="submit" name = "stnew" value="Добавить"><br> </FORM> </div> <?php } if (@$stnew) { require("connect.php"); mysql_query("INSERT INTO Students (StudID,StudName,GroupNum) VALUES ('$stnum','$stname','$grnum')"); mysql_query("INSERT INTO MarkJournal(SubjID, LTypeID, StudID, LNumb) SELECT SubjID, LTypeID, StudID, LNumb FROM Plan JOIN Students WHERE StudID = '$stnum' "); $result = mysql_query("SELECT * FROM Students WHERE StudName LIKE '%$stname%'"); ?> <br> <br> <div align=center><H4>Добавлена запись:</H4></div><br> <div align=center><table border = 1> <tr><td> Номер </td> <td> ФИО </td> <td> Группа </td> </tr> <?php while ($myrow = mysql_fetch_array($result)) { //tr-строка,td-ячейка,H1-1-й уровень printf("<tr><td><H7>%d",$myrow["StudID"],"</h7></td></tr>"); printf("<td>%s",$myrow["StudName"],"</tr>"); printf("<td>%s",$myrow["GroupNum"],"</tr>"); } } ?> </table> </div> </body> </html> speclist.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="studlist.php"> Список студентов </a> | <a href="speclist.php"> Специальности </a> | <a href="subj-tch.php"> Дисциплины </a> | <a href="plan.php"> Учебный план </a> <hr> <h1 align="center"> Список специальностей </h1> <hr> <br> <? require("connect.php"); $result = mysql_query("SELECT * FROM Specializations",$db); if ($myrow = mysql_fetch_array($result)) { echo "<table border=1 align=center>\n"; echo "<tr><td>Код</td><td>Наименование</td></tr>\n"; do { printf("<tr><td>%d</td><td>%s</td></tr>\n", $myrow["SpecID"], $myrow["SpecName"]); } while ($myrow = mysql_fetch_array($result)); echo "</table>\n"; } else { echo "Sorry, no records were found!"; } mysql_close($db); ?> </body> </html> subj-tch.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="studlist.php"> Список студентов </a> | <a href="speclist.php"> Специальности </a> | <a href="subj-tch.php"> Дисциплины </a> | <a href="plan.php"> Учебный план </a> <hr> <h1 align="center"> Дисциплины </h1> <hr> <br> <? require("connect.php"); $result = mysql_query("SELECT DISTINCT Subjects.SubjName, Teachers.TchName FROM (Teachers JOIN TimeTable ON Teachers.TchID = TimeTable.TchID ) JOIN Subjects ON Subjects.SubjID=TimeTable.SubjID",$db); 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>%s</td></tr>\n", $myrow["SubjName"], $myrow["TchName"]); } while ($myrow = mysql_fetch_array($result)); echo "</table>\n"; } else { echo "Sorry, no records were found!"; } mysql_close($db); ?> </body> </html> plan.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="studlist.php"> Список студентов </a> | <a href="speclist.php"> Специальности </a> | <a href="subj-tch.php"> Дисциплины </a> | <a href="plan.php"> Учебный план </a> <hr> <h1 align="center"> Учебный план </h1> <hr> <br> <? require("connect.php"); $result = mysql_query("select SubjName, LTypeName, LNumb from (Plan join Subjects on Plan.SubjID = Subjects.SubjID) join LessTypes on Plan.LTypeID = LessTypes.LTypeID",$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>%s</td><td>%s</td><td>%d</td></tr>\n", $myrow["SubjName"], $myrow["LTypeName"], $myrow["LNumb"]); } 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=plan.php method=post> <br> <INPUT type="submit" value="Внести изменения" name=newwrk></FORM> </div> <div align=center> <?php if (@$newwrk) { ?> <FORM name="mean" method="post" action=plan.php> <br> Предмет:<input type="text" name = "sbjname"> <br> Занятие:<input type="text" name = "lsn"> <br> Номер:<input type="text" name = "lnum"> <br> <input type="submit" name = "addwrk" value="Добавить"> <INPUT type="submit" value="Удалить" name="delwrk"> <br> </FORM> </div> <?php } if (@$addwrk) { require("connect.php"); $result = mysql_query("SELECT SubjID FROM Subjects WHERE SubjName LIKE '$sbjname'"); $tmpsubj = mysql_fetch_array($result); $tmpsubjid = $tmpsubj["SubjID"]; $result = mysql_query("SELECT LTypeID FROM LessTypes WHERE LTypeName LIKE '$lsn'"); $tmplsn = mysql_fetch_array($result); $tmplsnid = $tmplsn["LTypeID"]; mysql_query("INSERT INTO Plan (SubjID, LTypeID, LNumb) VALUES ('$tmpsubjid', '$tmplsnid', '$lnum')"); mysql_close($db); require("connect.php"); mysql_query("INSERT INTO MarkJournal (SubjID, LTypeID, StudID, LNumb) SELECT SubjID, LTypeID, StudID, LNumb FROM Plan JOIN Students WHERE SubjID = $tmpsubjid AND LTypeID = $tmplsnid AND LNumb = $lnum "); mysql_close($db); } if (@$delwrk) { require("connect.php"); $result = mysql_query("SELECT SubjID FROM Subjects WHERE SubjName LIKE '$sbjname'"); $tmpsubj = mysql_fetch_array($result); $tmpsubjid = $tmpsubj["SubjID"]; $result = mysql_query("SELECT LTypeID FROM LessTypes WHERE LTypeName LIKE '$lsn'"); $tmplsn = mysql_fetch_array($result); $tmplsnid = $tmplsn["LTypeID"]; mysql_query("DELETE FROM MarkJournal WHERE SubjID = $tmpsubjid AND LTypeID = $tmplsnid AND LNumb = $lnum"); mysql_query("DELETE FROM Plan WHERE SubjID = $tmpsubjid AND LTypeID = $tmplsnid AND LNumb = $lnum"); mysql_close($db); } ?> </body> </html> jrnlst.php <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1251" /> <title>Журнал: выбор страницы</title> </head>
Страницы: 1, 2, 3, 4, 5
|