D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
diafrica
/
result.dominicaninstitute.org
/
Filename :
comprehensiveexam.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 if(isset($_POST['findstudent'])) { $mat=$_POST['mat']; $programmesn=$_POST['programmesn']; ?> <?php $query_ass="select * from students where matric = '$mat'"; $result_ass=mysql_query($query_ass) or die(mysql_error()); $row_ass=mysql_fetch_assoc($result_ass); $de_ass=$row_ass['de']; $query_dio1 = "SELECT *,r.sn as dsn FROM coursesregistered as r inner join coursestobetaken as t on r.coursesn=t.sn where t.programmesn=$programmesn and r.matric='$mat' and t.de='$de_ass'"; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $row_dio1 = mysql_fetch_assoc($dio1); $totalRows_dio1 = mysql_num_rows($dio1); ?> <?php if ($totalRows_dio1==0) { $jkjk="Student with Matric No: <b>".$mat."</b> was not found. It is either there is no student with this matric number or that student has not yet been registered for any session!"; include("personaltranscript.php"); exit(); } ?> <!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("top1.php"); ?> <?php include("dtable0.php"); ?> <?php include("nav.php"); ?> <?php include("dtable1.php"); ?> <?php include("topcontainer.php"); ?> <!--Content Goes Here--> <?php $sql = "SELECT *,d.namer as dnamer,p.namer as dprog FROM programmes as p inner join departments as d on p.departmentsn=d.sn where p.sn=$programmesn"; $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_assoc($result); $department=$row['dnamer']; $programme=$row['dprog']; $faculty=$row['facultysn']; $sql = "SELECT *,f.namer as dnamer FROM departments as d inner join faculties as f on d.facultysn=f.sn where d.facultysn=$faculty"; $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_assoc($result); $faculty=$row['dnamer']; ?> <?php $sql = "SELECT *,date_format(dob,'%b %e, %Y') as dater FROM students where matric='$mat'"; $result = mysql_query($sql, $csn) or die(mysql_error()); $row = mysql_fetch_assoc($result); $yearofentry=$row['yearofentry']; $yearofentry=$yearofentry+1; $yearofentry=$row['yearofentry'] . "/" . $yearofentry; ?> <table width="100%" border="0" cellpadding="3" cellspacing="2"> <tr valign="top"> <td><b>Name: </b><span><?php echo($row['surname']); ?></span>, <?php echo($row['firstname']); ?> <?php echo($row['othernames']); ?></td> <td align="left"><b>Matric. No: </b><?php echo($row['matric']); ?></td> <td align="left"><strong>Course of Study:</strong><span style="text-transform:uppercase; font-weight:bold;"> <?php echo $programme; ?></span></td> </tr> <tr valign="top"> <td><strong>Faculty:</strong> <span style="text-transform:uppercase; font-weight:bold;"><?php echo $faculty; ?></span></td> <td align="left"><b>Date of Birth: </b><?php echo($row['dater']); ?></td> <td align="left"><strong>Gender: </strong></td> </tr> <tr valign="top"> <td ><strong>Nationality: </strong><br /> </td> <td align="left"><b>Mode of Entry: </b> <?php $ded=$row['de']; if($ded=='DE'){ echo($ded); } else { echo('UTME'); } ?></td> <td align="left"><b>Year of Admission: </b><?php echo $row['yearofentry']; ?><br /> </td> </tr> </table> <div style="text-align:center"> <?php $query_ass2="select * from comprehensive where matric = '$mat'"; $result_ass2=mysql_query($query_ass2) or die(mysql_error()); $row_ass2=mysql_fetch_assoc($result_ass2); $totalrow2 = mysql_num_rows($result_ass2); if ($totalrow2 == 0) { ?> <p><strong>ENTER SCORES</strong></p> <?php ?> <form method="post" action="dadmin.php"> <table style="border-collapse: collapse;" width="100%" border="1" cellpadding="5" cellspacing="5"> <tr > <th>Secred Scriptures (Written)</th> <th>Systematic (Written)</th> <th>Moral (Written)</th> </tr> <tr > <td><input type="hidden" name="matric" value="<?php echo $mat ?>"><input type="number" required="" name="secred"></td> <td><input type="number" required="" name="systematic"></td> <td><input type="number" required="" name="moral"></td> </tr> <tr > <th>Secred Scriptures (Oral)</th> <th>Systematic (Oral)</th> <th>Moral (Oral)</th> </tr> <tr > <td><input type="number" required="" name="secredo"></td> <td><input type="number" required="" name="systematico"></td> <td><input type="number" required="" name="moralo"></td> </tr> </table><br><br> <input type="submit" name="subcom" value="Submit"> </form> <?php }else{ ?> <p>Result Added Already</p> <?php } ?> </div> <!--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("personaltranscript.php"); }?> <?php /*} else { include("ddadmin.php"); }*/?>