D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
diafrica
/
result.dominicaninstitute.org
/
Connecter
/
Filename :
listcoursestobetaken2.php
back
Copy
<?php if (!$_SESSION){ session_start(); } $acc=$_SESSION['acc']; $yto=$_SESSION['yto']; if(isset($acc) && ($acc=="administratoroftheduresult2018byto")){?> <?php include("Connecter/dataconn.php"); ?> <?php include("checkforpending2.php"); ?> <?php include("checkforpending.php"); ?> <?php if (isset($_GET['deltab'])) { $deltab=$_GET['deltab']; $sql="delete from coursestobetaken where sn = ".$deltab; $result=mysql_query($sql,$csn) or die(mysql_error()); $sql="delete from coursesregistered where coursesn = ".$deltab; $result=mysql_query($sql,$csn) or die(mysql_error()); } ?> <?php if(isset($_GET['editcoursestobetaken'])) { $a1=$_GET['namer']; $a2=$_GET['unit']; $a3=$_GET['status']; $a4=$_GET['stand']; $a5=$_GET['stance']; $a6=$_GET['lecturersn']; $a7=$_GET['sn']; $a8=$_GET['code']; $sqlwork="update coursestobetaken set namer='$a1', unit=$a2, status='$a3', stand='$a4',stance='$a5',lecturersn=$a6 where code = $a8"; $work=@mysql_query($sqlwork); $sqlwork="update courses set namer='$a1', unit=$a2, status='$a3', where code=$a8"; $work=@mysql_query($sqlwork); } ?> <?php if(isset($_GET['addlecturer'])) { $q1=$_GET['namer']; $q2=$_GET['username']; $q3=$_GET['passwrd']; $q4=$_GET['departmentsn']; $sqlwork="select * from lecturers where namer='$q1' or username='$q2'"; $work=mysql_query($sqlwork); $num_work=mysql_num_rows($work); if($num_work==0){ $sqlwork="insert into lecturers (namer,username,passwrd,departmentsn,archived) values ('$q1','$q2','$q3',$q4,'No')"; $work=@mysql_query($sqlwork); } } ?> <?php if(isset($_GET['chosecourse'])) { $a1=$_GET['code']; $a2=$_GET['stand']; $a3=$_GET['stance']; $a4=$_GET['lecturersn']; $b1=$_GET['programmesn']; $b2=$_GET['session']; $b3=$_GET['semester']; $b4=$_GET['level']; $xx=$_GET['de']; $sqlwork="select * from coursestobetaken where code='$a1' and programmesn=$b1 and session='$b2' and level=$b4 and de='$xx'"; $work=mysql_query($sqlwork); $num_work=mysql_num_rows($work); if($num_work==0){ $sqlwork2="select * from courses where code='$a1'"; $work2=mysql_query($sqlwork2); $row_work2=mysql_fetch_array($work2); $c1=$row_work2['namer']; $c2=$row_work2['unit']; $c3=$row_work2['status']; $sqlwork="insert into coursestobetaken (code,stand,stance,lecturersn,programmesn,session,semester,level,namer,unit,status,archived,de) values ('$a1','$a2','$a3',$a4,$b1,'$b2',$b3,$b4,'$c1',$c2,'$c3','No','$xx')"; $work=@mysql_query($sqlwork); } } ?> <?php if(isset($_GET['addcourse'])) { $a1=$_GET['code']; $a2=$_GET['stand']; $a3=$_GET['stance']; $a4=$_GET['lecturersn']; $b1=$_GET['programmesn']; $b2=$_GET['session']; $b3=$_GET['semester']; $b4=$_GET['level']; $c1=$_GET['namer']; $c2=$_GET['unit']; $c3=$_GET['status']; $xx=$_GET['de']; $a1=strtoupper($a1); $sqlwork2="select * from courses where code='$a1'"; $work2=mysql_query($sqlwork2); $num_work2=mysql_num_rows($work2); if($num_work2==0){ $sqlwork="insert into courses (code,namer,unit,status,archived) values ('$a1','$c1',$c2,'$c3','No')"; $work=@mysql_query($sqlwork); $sqlwork="select * from coursestobetaken where code='$a1' and programmesn=$b1 and session='$b2' and level=$b4 and de='$xx'"; $work=mysql_query($sqlwork); $num_work=mysql_num_rows($work); if($num_work==0){ $sqlwork="insert into coursestobetaken (code,stand,stance,lecturersn,programmesn,session,semester,level,namer,unit,status,archived,de) values ('$a1','$a2','$a3',$a4,$b1,'$b2',$b3,$b4,'$c1',$c2,'$c3','No','$xx')"; $work=@mysql_query($sqlwork); } } } ?> <?php if(isset($_GET['ses'])) { $natasession=$_GET['ses']; $progid=$_GET['tab']; $query_dio1 = "SELECT * FROM programmes where sn=".$progid; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $row_dio1 = mysql_fetch_assoc($dio1); $typer=$row_dio1['typer']; $n=$row_dio1['numberofyears']; $query_dio2 = "SELECT * FROM departments where sn=".$row_dio1['departmentsn']; $dio2 = mysql_query($query_dio2, $csn) or die(mysql_error()); $row_dio2 = mysql_fetch_assoc($dio2); ?> <!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" /> <?php include("head.php"); ?> </head> <body> <?php include("top.php"); ?> <?php include("dtable0.php"); ?> <?php include("nav.php"); ?> <?php include("dtable1.php"); ?> <?php include("topcontainer.php"); ?> <!--Content Goes Here--> <div class="headingbiggest">Courses for <?php echo($row_dio1['namer']); ?> [<?php echo($row_dio2['namer']); ?>] in <?php echo($natasession); ?> Session</div> <hr /> <?php //Loop for Each Year/Level in the Programme of Study ?> <?php for($i=0;$i<$n;$i++){ $p=$i+1; ?> <?php $session=$natasession; $level=$p; $programmesn=$progid; $de=''; ?> <div class="headingbigger">Year <?php echo($p); ?></div> <div class="post2"> <?php //Loop for Each Semester in the Level/Year ?> <?php for($u=1;$u<=2;$u++){ $semester=$u; ?> <div class="headingnormal">Semester <?php echo($semester); ?></div><hr /> <table width="100%" border="1" cellpadding="3" cellspacing="2" frame="vsides" rules="rows"> <?php $query_vin = "SELECT * FROM coursestobetaken where programmesn=$programmesn and session='$session' and level=$level and semester=$semester and de='$de'"; $vin = mysql_query($query_vin, $csn) or die(mysql_error()); $num_vin=mysql_num_rows($vin); ?> <?php if($num_vin<1){ echo("<tr><td colspan='9' style='color:#990000;'>No Course Added Yet!</td></tr>"); } else { ?> <tr valign="top" style="background-color:#000; color:#FFF;"> <td width="20px"><b> </b></td> <td width="60px"><b>Code</b></td> <td><b>Course</b></td> <td><b>Unit</b></td> <td><b>Status</b></td> <td><b>Stand</b></td> <td><b>Stance</b></td> <td><b>Lecturer</b></td> <td width="90px"><b> </b></td> </tr> <?php $f=0; while($row_vin = mysql_fetch_assoc($vin)) { $f++; ?> <tr valign="top"> <td align="left"><?php echo($f); ?>.</td> <td align="left"><?php echo($row_vin['code']); ?></td> <td align="left"><?php echo($row_vin['namer']); ?></td> <td align="left"><?php echo($row_vin['unit']); ?></td> <td align="left"><?php echo($row_vin['status']); ?></td> <td align="left"><?php echo($row_vin['stand']); ?></td> <td align="left"><?php echo($row_vin['stance']); ?></td> <td align="left"><?php $sql="SELECT * FROM lecturers where sn = ".$row_vin['lecturersn']; $result = mysql_query($sql); $row = mysql_fetch_array($result); echo($row['namer']); ?></td> <td align="center"> <a href="listcoursestobetaken2.php?tab=<?php echo $programmesn; ?>&ses=<?php echo $session; ?>&deltab=<?php echo($row_vin['sn']); ?>">Delete</a> <a href="editcoursestobetaken2.php?tab=<?php echo $programmesn; ?>&ses=<?php echo $session; ?>&editab=<?php echo($row_vin['sn']); ?>">Edit</a> </td> </tr> <?php } } ?> </table> <?php $sql = "SELECT sum(unit) FROM coursestobetaken where programmesn=$programmesn and session='$session' and level=$level and semester=$semester and de='$de'"; $result = mysql_query($sql); $row=mysql_fetch_array($result); ?> <?php if($num_vin>0){ ?> <div align="right" style="font-weight:bold; color:#22398f; font-size:14px; background-color:#b7c5f9; padding:5px 20px 5px 20px;">Total Units: <?php echo($row[0]); ?></div> <?php } ?> <table width="100%" border="1" cellpadding="3" cellspacing="2" frame="border" rules="none"> <tr valign="top"> <td width="50px" style="background-color:#000; color:#FFF; font-weight:bold;">Add Courses Here</td> <td> <div class="franca">1. Choose from Previously Added Courses:</div> <form action="listcoursestobetaken2.php" method="get" name="form1" id="form1"> <?php $sql = "SELECT * FROM courses where archived='No' order by code asc"; $result = mysql_query($sql); ?> <b>Course:</b><select name="code" id="code"> <?php while($row = mysql_fetch_array($result)){ ?> <option value="<?php echo $row['code']; ?>"><?php echo $row['code']; ?></option> <?php }?> </select> <b>Stand:</b><select name="stand" id="stand" style="width:52px;"> <option value="" selected="selected"></option> <option value="Faculty Required">Faculty Required</option> <option value="Department Required">Department Required</option> </select> <b>Stance:</b><select name="stance" id="stance" style="width:72px;"> <option value="Internal" selected="selected">Internal</option> <option value="External">External</option> <option value="Compulsory">Compulsory</option> </select> <?php $sql = "SELECT * FROM lecturers where archived='No'"; $result = mysql_query($sql); ?> <b>Lecturer:</b><select name="lecturersn" id="lecturersn" style="width:270px;"> <?php while($row = mysql_fetch_array($result)){ ?> <option value="<?php echo $row['sn']; ?>"><?php echo $row['namer']; ?></option> <?php }?> </select> <div align="right"> <input name="chosecourse" type="submit" id="chosecourse" value=" Choose Course " /> <input name="ses" type="hidden" value="<?php echo($session); ?>" /> <input name="tab" type="hidden" value="<?php echo($programmesn); ?>" /> <input name="programmesn" type="hidden" value="<?php echo($programmesn); ?>" /> <input name="session" type="hidden" value="<?php echo($session); ?>" /> <input name="semester" type="hidden" value="<?php echo($semester); ?>" /> <input name="level" type="hidden" value="<?php echo($level); ?>" /> <input name="de" type="hidden" value="<?php echo($de); ?>" /> </div> </form> <hr /> <div class="franca">2. Enter New Course, Not Previously Added:</div> <form action="listcoursestobetaken2.php" method="get" name="form1" id="form1"> <b>Code:</b><input name="code" type="text" size="8" required="required" /> <b>Course:</b><input name="namer" type="text" size="15" required="required" /> <b>Unit:</b><select name="unit" id="unit"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> <option value="6">6</option> <option value="7">7</option> </select> <b>Status:</b><select name="status" id="status"> <option value="C">C</option> <option value="R">R</option> <option value="E">E</option> </select> <b>Stand:</b><select name="stand" id="stand" style="width:52px;"> <option value="" selected="selected"></option> <option value="Faculty Required">Faculty Required</option> <option value="Department Required">Department Required</option> </select> <b>Stance:</b><select name="stance" id="stance" style="width:72px;"> <option value="Internal" selected="selected">Internal</option> <option value="External">External</option> <option value="Compulsory">Compulsory</option> </select> <?php $sql = "SELECT * FROM lecturers where archived='No'"; $result = mysql_query($sql); ?> <b>Lecturer:</b><select name="lecturersn" id="lecturersn" style="width:270px;"> <?php while($row = mysql_fetch_array($result)){ ?> <option value="<?php echo $row['sn']; ?>"><?php echo $row['namer']; ?></option> <?php }?> </select> <div align="right"> <input name="addcourse" type="submit" id="addcourse" value=" Add Course " /> <input name="ses" type="hidden" value="<?php echo($session); ?>" /> <input name="tab" type="hidden" value="<?php echo($programmesn); ?>" /> <input name="programmesn" type="hidden" value="<?php echo($programmesn); ?>" /> <input name="session" type="hidden" value="<?php echo($session); ?>" /> <input name="semester" type="hidden" value="<?php echo($semester); ?>" /> <input name="level" type="hidden" value="<?php echo($level); ?>" /> <input name="de" type="hidden" value="<?php echo($de); ?>" /> </div> </form> <hr /> <div class="franca">Enter New Lecturer, Not Previously Added:</div> <form action="listcoursestobetaken2.php" method="get" name="form1" id="form1"> <b>Name:</b><input name="namer" type="text" size="20" required="required" /> <b>Username:</b><input name="username" type="text" size="7" required="required" /> <b>Password:</b><input name="passwrd" type="text" size="7" required="required" /> <?php $sql = "SELECT * FROM departments where archived='No'"; $result = mysql_query($sql); ?> <b>Dept:</b><select name="departmentsn" id="departmentsn" style="width:150px;"> <option value="0" selected="selected">External</option> <?php while($row = mysql_fetch_array($result)){ ?> <option value="<?php echo $row['sn']; ?>"><?php echo $row['namer']; ?></option> <?php }?> </select> <div align="right"> <input name="addlecturer" type="submit" id="addlecturer" value=" Add Lecturer " /> <input name="ses" type="hidden" value="<?php echo($session); ?>" /> <input name="tab" type="hidden" value="<?php echo($programmesn); ?>" /> <input name="programmesn" type="hidden" value="<?php echo($programmesn); ?>" /> <input name="session" type="hidden" value="<?php echo($session); ?>" /> <input name="semester" type="hidden" value="<?php echo($semester); ?>" /> <input name="level" type="hidden" value="<?php echo($level); ?>" /> </div> </form> </td> </tr> </table> <div> </div> <div> </div> <div> </div> <div> </div> <?php //End of Loop for Each Semester in the Level/Year ?> <?php } ?> </div><div class="post-bot2"></div> <?php //End of Loop for Each Year/Level in the Programme of Study ?> <?php } ?> <?php //Beginning of Direct Entry ?> <?php if($typer=='Degree'){ ?> <div class="headingbiggest">Courses for DIRECT ENTRY</div> <hr /> <?php //Loop for Each Year/Level in the Programme of Study ?> <?php for($i=1;$i<$n;$i++){ $p=$i+1; ?> <?php $session=$natasession; $level=$p; $programmesn=$progid; $de='DE'; ?> <div class="headingbigger">Year <?php echo($p); ?> [<?php echo($de); ?>]</div> <div class="post2"> <?php //Loop for Each Semester in the Level/Year ?> <?php for($u=1;$u<=2;$u++){ $semester=$u; ?> <div class="headingnormal">Semester <?php echo($semester); ?></div><hr /> <table width="100%" border="1" cellpadding="3" cellspacing="2" frame="vsides" rules="rows"> <?php $query_vin = "SELECT * FROM coursestobetaken where programmesn=$programmesn and session='$session' and level=$level and semester=$semester and de='$de'"; $vin = mysql_query($query_vin, $csn) or die(mysql_error()); $num_vin=mysql_num_rows($vin); ?> <?php if($num_vin<1){ echo("<tr><td colspan='9' style='color:#990000;'>No Course Added Yet!</td></tr>"); } else { ?> <tr valign="top" style="background-color:#000; color:#FFF;"> <td width="20px"><b> </b></td> <td width="60px"><b>Code</b></td> <td><b>Course</b></td> <td><b>Unit</b></td> <td><b>Status</b></td> <td><b>Stand</b></td> <td><b>Stance</b></td> <td><b>Lecturer</b></td> <td width="90px"><b> </b></td> </tr> <?php $f=0; while($row_vin = mysql_fetch_assoc($vin)) { $f++; ?> <tr valign="top"> <td align="left"><?php echo($f); ?>.</td> <td align="left"><?php echo($row_vin['code']); ?></td> <td align="left"><?php echo($row_vin['namer']); ?></td> <td align="left"><?php echo($row_vin['unit']); ?></td> <td align="left"><?php echo($row_vin['status']); ?></td> <td align="left"><?php echo($row_vin['stand']); ?></td> <td align="left"><?php echo($row_vin['stance']); ?></td> <td align="left"><?php $sql="SELECT * FROM lecturers where sn = ".$row_vin['lecturersn']; $result = mysql_query($sql); $row = mysql_fetch_array($result); echo($row['namer']); ?></td> <td align="center"> <a href="listcoursestobetaken2.php?tab=<?php echo $programmesn; ?>&ses=<?php echo $session; ?>&deltab=<?php echo($row_vin['sn']); ?>">Delete</a> <a href="editcoursestobetaken2.php?tab=<?php echo $programmesn; ?>&ses=<?php echo $session; ?>&editab=<?php echo($row_vin['sn']); ?>">Edit</a> </td> </tr> <?php } } ?> </table> <?php $sql = "SELECT sum(unit) FROM coursestobetaken where programmesn=$programmesn and session='$session' and level=$level and semester=$semester and de='$de'"; $result = mysql_query($sql); $row=mysql_fetch_array($result); ?> <?php if($num_vin>0){ ?> <div align="right" style="font-weight:bold; color:#22398f; font-size:14px; background-color:#b7c5f9; padding:5px 20px 5px 20px;">Total Units: <?php echo($row[0]); ?></div> <?php } ?> <table width="100%" border="1" cellpadding="3" cellspacing="2" frame="border" rules="none"> <tr valign="top"> <td width="50px" style="background-color:#000; color:#FFF; font-weight:bold;">Add Courses Here</td> <td> <div class="franca">1. Choose from Previously Added Courses:</div> <form action="listcoursestobetaken2.php" method="get" name="form1" id="form1"> <?php $sql = "SELECT * FROM courses where archived='No' order by code asc"; $result = mysql_query($sql); ?> <b>Course:</b><select name="code" id="code"> <?php while($row = mysql_fetch_array($result)){ ?> <option value="<?php echo $row['code']; ?>"><?php echo $row['code']; ?></option> <?php }?> </select> <b>Stand:</b><select name="stand" id="stand" style="width:52px;"> <option value="" selected="selected"></option> <option value="Faculty Required">Faculty Required</option> <option value="Department Required">Department Required</option> </select> <b>Stance:</b><select name="stance" id="stance" style="width:72px;"> <option value="Internal" selected="selected">Internal</option> <option value="External">External</option> <option value="Compulsory">Compulsory</option> </select> <?php $sql = "SELECT * FROM lecturers where archived='No'"; $result = mysql_query($sql); ?> <b>Lecturer:</b><select name="lecturersn" id="lecturersn" style="width:270px;"> <?php while($row = mysql_fetch_array($result)){ ?> <option value="<?php echo $row['sn']; ?>"><?php echo $row['namer']; ?></option> <?php }?> </select> <div align="right"> <input name="chosecourse" type="submit" id="chosecourse" value=" Choose Course " /> <input name="ses" type="hidden" value="<?php echo($session); ?>" /> <input name="tab" type="hidden" value="<?php echo($programmesn); ?>" /> <input name="programmesn" type="hidden" value="<?php echo($programmesn); ?>" /> <input name="session" type="hidden" value="<?php echo($session); ?>" /> <input name="semester" type="hidden" value="<?php echo($semester); ?>" /> <input name="level" type="hidden" value="<?php echo($level); ?>" /> <input name="de" type="hidden" value="<?php echo($de); ?>" /> </div> </form> <hr /> <div class="franca">2. Enter New Course, Not Previously Added:</div> <form action="listcoursestobetaken2.php" method="get" name="form1" id="form1"> <b>Code:</b><input name="code" type="text" size="8" required="required" /> <b>Course:</b><input name="namer" type="text" size="15" required="required" /> <b>Unit:</b><select name="unit" id="unit"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> <option value="6">6</option> <option value="7">7</option> </select> <b>Status:</b><select name="status" id="status"> <option value="C">C</option> <option value="R">R</option> <option value="E">E</option> </select> <b>Stand:</b><select name="stand" id="stand" style="width:52px;"> <option value="" selected="selected"></option> <option value="Faculty Required">Faculty Required</option> <option value="Department Required">Department Required</option> </select> <b>Stance:</b><select name="stance" id="stance" style="width:72px;"> <option value="Internal" selected="selected">Internal</option> <option value="External">External</option> <option value="Compulsory">Compulsory</option> </select> <?php $sql = "SELECT * FROM lecturers where archived='No'"; $result = mysql_query($sql); ?> <b>Lecturer:</b><select name="lecturersn" id="lecturersn" style="width:270px;"> <?php while($row = mysql_fetch_array($result)){ ?> <option value="<?php echo $row['sn']; ?>"><?php echo $row['namer']; ?></option> <?php }?> </select> <div align="right"> <input name="addcourse" type="submit" id="addcourse" value=" Add Course " /> <input name="ses" type="hidden" value="<?php echo($session); ?>" /> <input name="tab" type="hidden" value="<?php echo($programmesn); ?>" /> <input name="programmesn" type="hidden" value="<?php echo($programmesn); ?>" /> <input name="session" type="hidden" value="<?php echo($session); ?>" /> <input name="semester" type="hidden" value="<?php echo($semester); ?>" /> <input name="level" type="hidden" value="<?php echo($level); ?>" /> <input name="de" type="hidden" value="<?php echo($de); ?>" /> </div> </form> <hr /> <div class="franca">Enter New Lecturer, Not Previously Added:</div> <form action="listcoursestobetaken2.php" method="get" name="form1" id="form1"> <b>Name:</b><input name="namer" type="text" size="20" required="required" /> <b>Username:</b><input name="username" type="text" size="7" required="required" /> <b>Password:</b><input name="passwrd" type="text" size="7" required="required" /> <?php $sql = "SELECT * FROM departments where archived='No'"; $result = mysql_query($sql); ?> <b>Dept:</b><select name="departmentsn" id="departmentsn" style="width:150px;"> <option value="0" selected="selected">External</option> <?php while($row = mysql_fetch_array($result)){ ?> <option value="<?php echo $row['sn']; ?>"><?php echo $row['namer']; ?></option> <?php }?> </select> <div align="right"> <input name="addlecturer" type="submit" id="addlecturer" value=" Add Lecturer " /> <input name="ses" type="hidden" value="<?php echo($session); ?>" /> <input name="tab" type="hidden" value="<?php echo($programmesn); ?>" /> <input name="programmesn" type="hidden" value="<?php echo($programmesn); ?>" /> <input name="session" type="hidden" value="<?php echo($session); ?>" /> <input name="semester" type="hidden" value="<?php echo($semester); ?>" /> <input name="level" type="hidden" value="<?php echo($level); ?>" /> </div> </form> </td> </tr> </table> <div> </div> <div> </div> <div> </div> <div> </div> <?php //End of Loop for Each Semester in the Level/Year ?> <?php } ?> </div><div class="post-bot2"></div> <?php //End of Loop for Each Year/Level in the Programme of Study ?> <?php } ?> <?php //End of Direct Entry ?> <?php } ?> <form action="managecourses.php" method="post" name="form1" id="form1"> <div align="right"> <input name="donecourse" type="submit" id="donecourse" value=" Done " style="font-size:16px; font-weight:bold; color:maroon;" /> <input name="ses" type="hidden" value="<?php echo($session); ?>" /> <input name="tab" type="hidden" value="<?php echo($programmesn); ?>" /> </div> </form> <!--Content Ends Here--> <?php include("bottomcontainer.php"); ?> <?php //include("dtable2.php"); ?> <?php //include("side.php"); ?> <?php include("dtable3.php"); ?> <?php include("foot.php"); ?> </body> </html> <?php } else { include("dadmin.php"); } ?> <?php } else { include("ddadmin.php"); }?>