|
p align="left"><form action="" method="post" onSubmit="return IsInputEmpty(this.Data.value, this.KChas.value);"> <? include("library/db_connect.php"); include("library/menu.shtml"); if($_SERVER['REQUEST_METHOD']!=='POST') { echo '<table width="250" border="1" bordercolor="#FFCCFF"><font color=000000><h5><tr><th>ФИОПреп</th><th>Дисциплина</th><th>Группа</th><th>Вид занятия</th><th>Дата</th><th>Кол-воЧасов</th><th>Часовая ставка</th></h5></font> <caption align="top"><h3>Журнал занятий</h3></caption><br>'; $query33 = mysql_query("select * from Kto4toUKogoVedet", $conn); while ($row33 = mysql_fetch_array($query33)) { $query1 = mysql_query("select FIOPrep from Prepodavateli where KodPrep='{$row33['KodPrep']}'", $conn); while ($row1 = mysql_fetch_array($query1)) { $query2 = mysql_query("select NazvDisc from Disciplini where KodDisc='{$row33['KodDisc']}'", $conn); while ($row2 = mysql_fetch_array($query2)) { $query3 = mysql_query("select NazvVidZan from VidiZanyatiy where KodVidZan='{$row33['KodVidZan']}'", $conn); while ($row3 = mysql_fetch_array($query3)) { $query44 = mysql_query("Select Stavka from Razryadi, Prepodavateli where FIOPrep='{$row1['FIOPrep']}' AND Prepodavateli.NomRazr=Razryadi.NomRazr", $conn); while ($row44 = mysql_fetch_array($query44)) { $query55 = mysql_query("Select BazPlata from Disciplini where KodDisc='{$row33['KodDisc']}'", $conn); while ($row55 = mysql_fetch_array($query55)) { $query66 = mysql_query("Select 4isloStudGr from Gruppi where KodGr='{$row33['KodGr']}'", $conn); while ($row66 = mysql_fetch_array($query66)) { $query77 = mysql_query("Select MinRent from Gruppi LEFT JOIN Kursi ON (Gruppi.KodKursa = Kursi.KodKursa) where KodGr ='{$row33['KodGr']}'", $conn); while ($row77 = mysql_fetch_array($query77)) { $rezault=(($row44['Stavka']+$row55['BazPlata'])*$row66['4isloStudGr']*$row33['Kolvo4asov'])/$row77['MinRent']; echo '<tr><td>'.$row1['FIOPrep'].'</td><td>'.$row2['NazvDisc'].'</td><td>'.$row33['KodGr'].'</td><td>'.$row3['NazvVidZan'].'</td><td>'.$row33['Data'].'</td><td>'.$row33['Kolvo4asov'].'</td><td>'.$rezault.'</td></tr>'; mysql_query("update Kto4toUKogoVedet set ChasovStav='{$rezault}' where ( KodPrep='{$row33['KodPrep']}' AND KodDisc='{$row33['KodDisc']}' AND KodVidZan='{$row33['KodVidZan']}' AND KodGr='{$row33['KodGr']}' AND '{$row33['Data']}')", $conn); } } } } } } } } echo '</table>'; echo ' <form name="form1" method="post" action="">'; $query4 = mysql_query("select FIOPrep from Prepodavateli", $conn); echo '<table><caption><font color=CC3300 size="2"><b>Заполните поля для добавления записи в журнал.</font></b> <tr><td valign="middle"> <h4> Выберите ФИО Преподавателя</h4></td> <td valign="middle"> <select name="FPrepod">'; while ($row4 = mysql_fetch_array($query4)) { echo ' <option>'.$row4['FIOPrep'].'</option>'; } echo ' </select> </td> </tr><br><br>'; $query5 = mysql_query("select NazvDisc from Disciplini", $conn); echo '<tr><td valign="middle"> <h4> Выберите дисциплину</h4></td><td valign="middle"><select name="NDisc">'; while ($row5 = mysql_fetch_array($query5)) { echo ' <option>'.$row5['NazvDisc'].'</option>'; } echo ' </select> </td> </tr><br><br>'; $query6 = mysql_query("select KodGr from Gruppi", $conn); echo '<tr><td valign="middle"> <h4> Выберите группу</h4></td> <td valign="middle"> <select name="KGruppi">'; while ($row6 = mysql_fetch_array($query6)) { echo ' <option>'.$row6['KodGr'].'</option>'; } echo ' </select> </td></tr><br><br>'; $query7 = mysql_query("select NazvVidZan from VidiZanyatiy", $conn); echo '<tr><td valign="middle"> <h4>Выберите Вид занятия</h4></td > <td valign="middle"> <select name="NVidZan">'; while ($row7 = mysql_fetch_array($query7)) { echo ' <option>'.$row7['NazvVidZan'].'</option>'; } echo ' </select> </td></tr><br><br>'; echo '<tr> <td valign="middle"> <strong> Дата</td></strong> <td valign="middle"> <input type=text name="Data" value="2009-01-01"> </td> </tr>'; echo '<tr><td valign="middle"><strong> Количество часов</td></strong> <td valign="middle"> <input type=text name="KChas" value="1"></td></tr>'; echo ' <tr><td valign="middle"> <p><br> <input name="ADD" type=submit value="Добавить запись в журнал"> </td></tr></p></table> </form><br>'; } if (isset($Data)) { echo ' <form name="form1" method="post" action=""><table border="0">'; $query9 = mysql_query("select KodPrep from Prepodavateli where FIOPrep='{$FPrepod}'", $conn); $row9 = mysql_fetch_array($query9); $query10 = mysql_query("select KodDisc from Disciplini where NazvDisc='{$NDisc}'", $conn); $row10 = mysql_fetch_array($query10); $query11 = mysql_query("select KodVidZan from VidiZanyatiy where NazvVidZan='{$NVidZan}'", $conn); $row11 = mysql_fetch_array($query11); mysql_query("insert into Kto4toUKogoVedet (KodPrep, KodDisc, KodGr, KodVidZan, Data, Kolvo4asov) values ('{$row9['KodPrep']}', '{$row10['KodDisc']}', '{$KGruppi}', '{$row11['KodVidZan']}', '{$Data}', '{$KChas}')", $conn); echo '<table width="200" border="1" bordercolor="#FFCCFF" bgcolor="#FFFFCC"><tr><th>ФИОПреп</th><th>Дисциплина</th><th>Группа</th><th>Вид занятия</th><th>Дата</th><th>Кол-воЧасов</th><th>Часовая ставка</th> <caption align="top"><h2><b>Журнал</h2></b></caption>'; $query33 = mysql_query("select * from Kto4toUKogoVedet", $conn); while ($row33 = mysql_fetch_array($query33)) { $query1 = mysql_query("select FIOPrep from Prepodavateli where KodPrep='{$row33['KodPrep']}'", $conn); while ($row1 = mysql_fetch_array($query1)) { $query2 = mysql_query("select NazvDisc from Disciplini where KodDisc='{$row33['KodDisc']}'", $conn); while ($row2 = mysql_fetch_array($query2)) { $query3 = mysql_query("select NazvVidZan from VidiZanyatiy where KodVidZan='{$row33['KodVidZan']}'", $conn); while ($row3 = mysql_fetch_array($query3)) { $query44 = mysql_query("Select Stavka from Razryadi, Prepodavateli where FIOPrep='{$row1['FIOPrep']}' AND Prepodavateli.NomRazr=Razryadi.NomRazr", $conn); while ($row44 = mysql_fetch_array($query44)) { $query55 = mysql_query("Select BazPlata from Disciplini where KodDisc='{$row33['KodDisc']}'", $conn); while ($row55 = mysql_fetch_array($query55)) { $query66 = mysql_query("Select 4isloStudGr from Gruppi where KodGr='{$row33['KodGr']}'", $conn); while ($row66 = mysql_fetch_array($query66)) { $query77 = mysql_query("Select MinRent from Gruppi LEFT JOIN Kursi ON (Gruppi.KodKursa = Kursi.KodKursa) where KodGr ='{$row33['KodGr']}'", $conn); while ($row77 = mysql_fetch_array($query77)) { $res=(($row44['Stavka']+$row55['BazPlata'])*$row66['4isloStudGr']*$row33['Kolvo4asov'])/$row77['MinRent']; echo '<tr><td>'.$row1['FIOPrep'].'</td><td>'.$row2['NazvDisc'].'</td><td>'.$row33['KodGr'].'</td><td>'.$row3['NazvVidZan'].'</td><td>'.$row33['Data'].'</td><td>'.$row33['Kolvo4asov'].'</td><td>'.$res.'</td></tr>'; } } } } } } } } echo '</table>'; } ?> </p> <p align="left"> </p> </body> </html> udalenieStudenta.php <html> <head> <title>Удаление студента</title> <meta content="text/html; charset=windows-1251" http-equiv="Content-Type" /> <meta http-equiv="Content-Language" content="ru-RU" /> <meta name="language" content="russian ru русский" /> </head> <body> <h6 align="center"><font color=#000066 size="4" face="Geneva, Arial, Helvetica, sans-serif"><strong>Платные курсы</strong></font><br> <font color="#003399" size="5"><em>"Медики-практиканты"</em></font></h6 align="center"> <hr color=006600 size="3"> <? include("library/db_connect.php"); if(isset($_POST['kodstudenta'])) { $res=count($_POST['kodstudenta']); //количество выбранных студентов for($i=0; $i<$res; $i++) { mysql_query("DELETE from StudentiVGruppax where ( KodStud='{$_POST['kodstudenta'][$i]}' AND KodGr='{$_POST['kgruppi']}' )", $conn); mysql_query('DELETE from Studenti where KodStud='.$_POST['kodstudenta'][$i]); } echo' <strong><font color=660066 size="5"><p align="center">Студент удален.</strong></font></p align="center">'; } else { echo ' <strong><font color=660066 size="5"><p align="center">Вы не выбрали студента.</strong></font></p align="center">'; } ?> <p align="left"> </p> </body> </html> index.php <meta content="text/html; charset=windows-1251" http-equiv="Content-Type" /> <meta http-equiv="Content-Language" content="ru-RU" /> <meta name="language" content="russian ru русский" /> <html> <style type="text/css"> <!-- .стиль1 {color: #006699} .стиль3 {color: #006699; font-size: 12px; } .стиль5 { color: #000000; font-size: 14px; font-family: "Courier New", Courier, monospace; } --> </style> <script type="text/javascript"> <!-- function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; } function MM_nbGroup(event, grpName) { //v6.0 var i,img,nbArr,args=MM_nbGroup.arguments; if (event == "init" && args.length > 2) { if ((img = MM_findObj(args[2])) != null && !img.MM_init) { img.MM_init = true; img.MM_up = args[3]; img.MM_dn = img.src; if ((nbArr = document[grpName]) == null) nbArr = document[grpName] = new Array(); nbArr[nbArr.length] = img; for (i=4; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) != null) { if (!img.MM_up) img.MM_up = img.src; img.src = img.MM_dn = args[i+1]; nbArr[nbArr.length] = img; } } } else if (event == "over") { document.MM_nbOver = nbArr = new Array(); for (i=1; i < args.length-1; i+=3) if ((img = MM_findObj(args[i])) != null) { if (!img.MM_up) img.MM_up = img.src; img.src = (img.MM_dn && args[i+2]) ? args[i+2] : ((args[i+1])? args[i+1] : img.MM_up); nbArr[nbArr.length] = img; } } else if (event == "out" ) { for (i=0; i < document.MM_nbOver.length; i++) { img = document.MM_nbOver[i]; img.src = (img.MM_dn) ? img.MM_dn : img.MM_up; } } else if (event == "down") { nbArr = document[grpName]; if (nbArr) for (i=0; i < nbArr.length; i++) { img=nbArr[i]; img.src = img.MM_up; img.MM_dn = 0; } document[grpName] = nbArr = new Array(); for (i=2; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) != null) { if (!img.MM_up) img.MM_up = img.src; img.src = img.MM_dn = (args[i+1])? args[i+1] : img.MM_up; nbArr[nbArr.length] = img; } } } function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } //--> </script> <head> <title>Курсы.Главная страница.</title> </head> <body onLoad="MM_preloadImages('img/nag.png','img/but_nav.png','img/trans_.png')"> <p> <? // echo '<hr color="808080" size="1">'; include("library/db_connect.php"); /*соединеие с базой*/ include("library/menu.shtml"); // echo '<hr color="808080" size="1">'; ?> </p> <table width="100%" border="0"> <tr> <td width="245" height="132"> </td> <td width="246" background="img/butt.png"><a href="http://localhost/med/kurs.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image3','','img/but_nav.png',0)"><img src="img/nag.png" name="Image3" width="245" height="130" border="0"></a><a href="javascript:;" target="_top" onClick="MM_nbGroup('down','group1','but','img/nag.png',1)" onMouseOver="MM_nbGroup('over','but','img/but_nav.png','img/trans_.png',1)" onMouseOut="MM_nbGroup('out')"></a></td> <td width="245" background="img/преп.png"><a href="http://localhost/med/SpisokPrepod.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image2','','img/but_nav.png',1)"><img src="img/nag.png" name="Image2" width="245" height="130" border="0"></a></td> <td width="214"> </td> </tr> <tr> <td height="129"> </td> <td valign="middle" background="img/журнал.png"><a href="http://localhost/med/vt.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image4','','img/but_nav.png',1)"><img src="img/nag.png" name="Image4" width="245" height="130" border="0"></a></td> <td background="img/оплата.png"><a href="http://localhost/med/Oplata.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image5','','img/but_nav.png',1)"><img src="img/nag.png" name="Image5" width="245" height="130" border="0"></a></td> <td> </td> </tr> <tr> <td height="131"> </td> <td valign="middle" background="img/программа.png"><a href="http://localhost/med/vtKto.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image6','','img/but_nav.png',1)"><img src="img/nag.png" name="Image6" width="245" height="130" border="0"></a></td> <td background="img/студ.png"><a href="http://localhost/med/Spisok.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image7','','img/but_nav.png',1)"><img src="img/nag.png" name="Image7" width="245" height="130" border="0"></a></td> <td> </td> </tr> <tr> <td height="42"> </td> <td valign="middle"> </td> <td> </td> <td> </td> </tr> </table> <? include("library/copyright.php"); ?> </body> </html>
Страницы: 1, 2, 3, 4
| 
