One Hat Cyber Team

Edit File: view_profile2.php

<? require ("inc/header.php"); ?>

<!- content starts here -->

<table width="100%"  border="0" cellspacing="0" cellpadding="5" class="text">
   <tr bgcolor=#cccccc>
    <td colspan="8"><strong><? echo "$w_update" ?></strong></td>
  </tr>
<?
//set the number of columns
$columns = 1;

if (!$rowstart) { $rowstart=0;}

$ending = 200;

$query = "SELECT *
	FROM students_profile
	WHERE stdprogramme_id = '$programme_id' AND
	stdfaculty_id = '$faculty_id' AND
	stddepartment_id = '$department_id' AND
	std_custome8 != 'GRADUATE'
	$od
	LIMIT $rowstart,$ending";

$query2 = "SELECT *
	FROM students_profile
	WHERE stdprogramme_id = '$programme_id' AND
	stdfaculty_id = '$faculty_id' AND
	stddepartment_id = '$department_id' AND
	std_custome8 != 'GRADUATE'
	$od";

$result = mysql_query($query);
$result2 = mysql_query($query2);
$num2 = mysql_num_rows($result2);
$num_rows = mysql_num_rows($result2);
$num = mysql_num_rows($result);

$thisrows=mysql_num_rows($result);
$allrows=mysql_num_rows($result2);
$rowbegin=$rowstart+1;
$rowend=$rowstart+$thisrows;

//put all the code here for running the script itself using $result in the while loop

//we add this line because we need to know the number of rows

if ($num > 1) {
$themembers = "Students";
}
else {
$themembers = "Student";
}
?>
<?
if ($num != 0) {
?>
       <tr>
        <td colspan="8"><strong><? echo "Showing $rowbegin - $rowend of $allrows $themembers"; ?> (<? echo GetProgramme ($programme_id) ?>, <? echo GetFaculty ($faculty_id) ?>, <? echo GetDepartment ($department_id) ?>)</strong></td>
      </tr>
 <tr bgcolor=#999999>
    <td><strong>S/No</strong></td>
    <td><strong><a href="<? $php_self ?>?&od=ORDER BY surname&programme_id=<? echo $programme_id ?>&faculty_id=<? echo $faculty_id ?>&department_id=<? echo $department_id ?>&rowstart=<? echo $rowstart ?>" title="Sort By Surname" style="color: #ffffff">Surname</a></strong></td>
    <td><strong>First Name</strong></td>
    <td><strong>Othernames</strong></td>
    <td><strong>Matric No</strong></td>
    <td><strong>Passport</strong></td>
    <td><strong>Action</strong></td>
  </tr>
<?
}
?>
<?
for ($i=1+$rowstart; $i<$num_rows+1+$rowstart; $i++) {
if ($i%2 ==0) {$bgcolor = '#f0f0f0';} else {$bgcolor = '#cccccc';} 
    $row = mysql_fetch_array($result);
    $row2 = mysql_fetch_array($result2);

$std_id = $row["std_id"];
$matric_no = $row["matric_no"];
$surname = $row["surname"];
$firstname = $row["firstname"];
$othernames = $row["othernames"];
$gender = $row["gender"];
$marital_status = $row["marital_status"];
$birthdate = $row["birthdate"];
$place_of_birth = $row["place_of_birth"];
$home_town = $row["home_town"];
$local_gov = $row["local_gov"];
$state_of_origin = $row["state_of_origin"];
$nationality = $row["nationality"];
$contact_address = $row["contact_address"];
$student_email = $row["student_email"];
$parents_name = $row["parents_name"];
$student_homeaddress = $row["student_homeaddress"];
$student_mobiletel = $row["student_mobiletel"];
$student_landtel = $row["student_landtel"];
$next_of_kin = $row["next_of_kin"];
$nok_address = $row["nok_address"];
$nok_tel = $row["nok_tel"];
$stdprogramme_id = $row["stdprogramme_id"];
$stdfaculty_id = $row["stdfaculty_id"];
$stddepartment_id = $row["stddepartment_id"];
$std_custome1 = $row["std_custome1"];
$std_custome2 = $row["std_custome2"];
$std_custome3 = $row["std_custome3"];
$std_custome4 = $row["std_custome4"];
$std_custome5 = $row["std_custome5"];
$std_custome6 = $row["std_custome6"];
$std_custome7 = $row["std_custome7"];
$std_custome8 = $row["std_custome8"];

$surname = stripslashes($surname);
$firstname = stripslashes($firstname);
$othernames = stripslashes($othernames);
$place_of_birth = stripslashes($place_of_birth);
$home_town = stripslashes($home_town);
$local_gov = stripslashes($local_gov);
$state_of_origin = stripslashes($state_of_origin);
$nationality = stripslashes($nationality);
$contact_address = stripslashes($contact_address);
$student_email = stripslashes($student_email);
$parents_name = stripslashes($parents_name);
$student_homeaddress = stripslashes($student_homeaddress);
$next_of_kin = stripslashes($next_of_kin);
$nok_address = stripslashes($nok_address);

$std_custome1 = stripslashes($std_custome1);
$std_custome2 = stripslashes($std_custome2);
$std_custome3 = stripslashes($std_custome3);
$std_custome4 = stripslashes($std_custome4);
$std_custome5 = stripslashes($std_custome5);
$std_custome6 = stripslashes($std_custome6);
$std_custome7 = stripslashes($std_custome7);
$std_custome8 = stripslashes($std_custome8);

$encsurname = urlencode($surname);
$encfirstname = urlencode($firstname);
$encothernames = urlencode($othernames);

$encfullname = strtoupper(trim("$surname $firstname $othernames"));

$wcheck = substr($matric_no, 0, 12);
if ($wcheck == "REGISTRATION") {
$chtomat = "<br><br>[<a href='change_mat.php?std_id=$std_id&rowstart=$rowstart&rg=$matric_no&encf=$encfullname' style='color: blue; font-size: 10px'>Change to Matric No</a>]";
}

if($i % $columns == 0) {
        //if there is no remainder, we want to start a new row
        echo "<TR>";
    }
    echo "<TD valign='top'>" ;
if ($std_id) {
?>
  <tr bgcolor=<? echo $bgcolor ?>>
    <td><? echo $i ?></td>
    <td><b><? echo strtoupper($surname) ?></b></td>
    <td><? echo strtoupper($firstname) ?></td>
    <td><? echo strtoupper($othernames) ?></td>
    <td><? echo $matric_no ?></td>
    <td><img src="<? echo GetImage ($std_custome4) ?>"></td>
    <td><? echo WithDrawer ($std_id) ?> <? echo SessionLimit ($std_id) ?> <? OtherWithDrawals ($std_id) ?>[<a href='suspension.php?std_id=<? echo $std_id ?>&programme_id=<? echo $programme_id ?>&faculty_id=<? echo $faculty_id ?>&department_id=<? echo $department_id ?>' style='color: blue; font-size: 10px'>suspend</a>]</td>
  </tr>
<?
}

"</TD>";
    if(($i % $columns) == ($columns - 1) || ($i + 1) == $num_rows) {
        //if there is a remainder of 1, end the row
        //or if there is nothing left in our result set, end the row
        echo "</TR>";
    }
}
?>
</table>
<br>
<?
if ($num == 0) {
?>
<table width="98%"  border="0" cellpadding="5" cellspacing="0" align="center" class="text" id="border">
  <tr>
    <td align=left>
No Record Found
</td>
  </tr>
</table>
<br>
<?
}
?>
<table width="98%"  border="0" cellpadding="5" cellspacing="0" align="center" class="text" id="border">
  <tr>
    <td align=right>
<?
$od = $_GET["od"];
$programme_id = $_GET["programme_id"];
$faculty_id = $_GET["faculty_id"];
$department_id = $_GET["department_id"];

$numrows=mysql_num_rows($result);
if (($rowbegin>$numrows) AND ($numrows !=0))
{?>
        <A HREF="<? $php_self ?>?rowstart=<? echo $rowstart-$ending; ?>&od=<? echo $od ?>&programme_id=<? echo $programme_id ?>&faculty_id=<? echo $faculty_id ?>&department_id=<? echo $department_id ?>"> < Previous</A> 
        <?}?>
<?
$num_rows=mysql_num_rows($result2);
if (($rowbegin>$numrows) AND ($rowstart+$ending<$num_rows))
{?>
        |
        <?}?>

<?
$num_rows=mysql_num_rows($result2);
if($rowstart+$ending<$num_rows) 
{?>
        <A HREF="<? $php_self?>?rowstart=<?echo $rowstart+$ending; ?>&od=<? echo $od ?>&programme_id=<? echo $programme_id ?>&faculty_id=<? echo $faculty_id ?>&department_id=<? echo $department_id ?>"> Next ></A> 
        <? } ?>
</td>
  </tr>
</table>
<br>

<!- content ends here -->

<? require ("inc/footer.php"); ?>