Dre4m Was Here

Dre4m Shell
Server IP : 103.6.199.200 / Your IP : 18.224.31.90
Web Server : Microsoft-IIS/10.0
System : Windows NT EMPUSA 10.0 build 20348 (Windows Server 2016) i586
User : EMPUSA$ ( 0)
PHP Version : 7.4.33
Disable Function : NONE
MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF
Directory : C:/Domains/smsmalor/smsmalorsetar.com/wwwroot/
Upload File :
[ HOME SHELL ]
Current File : C:/Domains/smsmalor/smsmalorsetar.com/wwwroot/detail_alumni_urus.php
<?php require_once('Connections/mentorpbs.php'); ?><?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$currentPage = $_SERVER["PHP_SELF"];

$colname_DetailRS1 = "-1";
if (isset($_GET['recordID'])) {
  $colname_DetailRS1 = $_GET['recordID'];
}
mysql_select_db($database_mentorpbs, $mentorpbs);
$query_DetailRS1 = sprintf("SELECT * FROM ahli_robotik INNER JOIN bangsa ON bangsa.id_bangsa=ahli_robotik.bangsa_id INNER JOIN agama ON agama.id_agama=ahli_robotik.agama_id INNER JOIN jantina ON jantina.id_jantina=ahli_robotik.jantina_id INNER JOIN hubungan_penjaga ON hubungan_penjaga.id_hubungan=ahli_robotik.hubungan_penjaga_id WHERE id_ahli = %s", GetSQLValueString($colname_DetailRS1, "int"));
$DetailRS1 = mysql_query($query_DetailRS1, $mentorpbs) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);
$totalRows_DetailRS1 = mysql_num_rows($DetailRS1);

$maxRows_DetailRS2 = 10;
$pageNum_DetailRS2 = 0;
if (isset($_GET['pageNum_DetailRS2'])) {
  $pageNum_DetailRS2 = $_GET['pageNum_DetailRS2'];
}
$startRow_DetailRS2 = $pageNum_DetailRS2 * $maxRows_DetailRS2;

$colname_DetailRS2 = "-1";
if (isset($_POST['textbox_my_nokp'])) {
  $colname_DetailRS2 = $_POST['textbox_my_nokp'];
}
mysql_select_db($database_mentorpbs, $mentorpbs);
$query_DetailRS2 = sprintf("SELECT * FROM robotik_kelas_jaw INNER JOIN kelas ON kelas.kelasid=robotik_kelas_jaw.kelas_id INNER JOIN jawatan ON jawatan.id_jawatan=robotik_kelas_jaw.jawatan_id WHERE nokp_ahli = %s", GetSQLValueString($colname_DetailRS2, "text"));
$query_limit_DetailRS2 = sprintf("%s LIMIT %d, %d", $query_DetailRS2, $startRow_DetailRS2, $maxRows_DetailRS2);
$DetailRS2 = mysql_query($query_limit_DetailRS2, $mentorpbs) or die(mysql_error());
$row_DetailRS2 = mysql_fetch_assoc($DetailRS2);

if (isset($_GET['totalRows_DetailRS2'])) {
  $totalRows_DetailRS2 = $_GET['totalRows_DetailRS2'];
} else {
  $all_DetailRS2 = mysql_query($query_DetailRS2);
  $totalRows_DetailRS2 = mysql_num_rows($all_DetailRS2);
}
$totalPages_DetailRS2 = ceil($totalRows_DetailRS2/$maxRows_DetailRS2)-1;

$queryString_DetailRS2 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
  $params = explode("&", $_SERVER['QUERY_STRING']);
  $newParams = array();
  foreach ($params as $param) {
    if (stristr($param, "pageNum_DetailRS2") == false && 
        stristr($param, "totalRows_DetailRS2") == false) {
      array_push($newParams, $param);
    }
  }
  if (count($newParams) != 0) {
    $queryString_DetailRS2 = "&" . htmlentities(implode("&", $newParams));
  }
}
$queryString_DetailRS2 = sprintf("&totalRows_DetailRS2=%d%s", $totalRows_DetailRS2, $queryString_DetailRS2);
?><!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" />
<title>Untitled Document</title>
<style type="text/css">
<!--
.style1 {
	color: #000099;
	font-size: 24px;
}
.style2 {color: #006600}
-->
</style>
</head>

<body>
<form id="form1" name="form1" method="post" action="">
  <div align="center" class="style1">MAKLUMAT ALUMNI KELAB ROBOTIK (PENGURUSAN)</div>
</form>
<p>&nbsp;</p>
<p align="center"><img src="images/robotik/<?php echo $row_DetailRS1['nama_ahli']; ?>.jpg" alt="" width="165" height="189" /></p>
<p>&nbsp;</p>
<table width="839" border="1" align="center">
  <tr>
    <td width="187"><div align="right" class="style2">No Rujukan:</div></td>
    <td width="636"><?php echo $row_DetailRS1['id_ahli']; ?> </td>
  </tr>
  <tr>
    <td><div align="right" class="style2">Kata Laluan:</div></td>
    <td><?php echo $row_DetailRS1['kata_laluan']; ?></td>
  </tr>
  <tr>
    <td><div align="right" class="style2">Nama:</div></td>
    <td><?php echo $row_DetailRS1['nama_ahli']; ?> </td>
  </tr>
  <tr>
    <td><div align="right" class="style2">No Kad Pengenalan:</div></td>
    <td><?php echo $row_DetailRS1['nokp_ahli']; ?></td>
  </tr>
  <tr>
    <td><div align="right" class="style2">Jantina:</div></td>
    <td><?php echo $row_DetailRS1['jantina']; ?> </td>
  </tr>
  <tr>
    <td><div align="right" class="style2">Tahun Jadi Ahli:</div></td>
    <td><?php echo $row_DetailRS1['tahun_ahli']; ?> </td>
  </tr>
  <tr>
    <td><div align="right" class="style2">Bangsa:</div></td>
    <td><?php echo $row_DetailRS1['bangsa']; ?> </td>
  </tr>
  <tr>
    <td><div align="right" class="style2">Agama:</div></td>
    <td><?php echo $row_DetailRS1['agama']; ?> </td>
  </tr>
  <tr>
    <td><div align="right" class="style2">Alamat 1:</div></td>
    <td><?php echo $row_DetailRS1['alamat1']; ?> </td>
  </tr>
  <tr>
    <td><div align="right" class="style2">Alamat 2:</div></td>
    <td><?php echo $row_DetailRS1['alamat2']; ?> </td>
  </tr>
  <tr>
    <td><div align="right" class="style2">Alamat 3:</div></td>
    <td><?php echo $row_DetailRS1['alamat3']; ?> </td>
  </tr>
  <tr>
    <td><div align="right" class="style2">Poskos:</div></td>
    <td><?php echo $row_DetailRS1['poskod']; ?> </td>
  </tr>
  <tr>
    <td><div align="right" class="style2">Bandar:</div></td>
    <td><?php echo $row_DetailRS1['bandar']; ?> </td>
  </tr>
  <tr>
    <td><div align="right" class="style2">Negeri:</div></td>
    <td><?php echo $row_DetailRS1['negeri']; ?> </td>
  </tr>
  <tr>
    <td><div align="right" class="style2">No Hand Phone:</div></td>
    <td><?php echo $row_DetailRS1['nohp_ahli']; ?> </td>
  </tr>
  <tr>
    <td><div align="right"><span class="style2">Gmail</span></div></td>
    <td><?php echo $row_DetailRS1['gmail_ahli']; ?></td>
  </tr>
  <tr>
    <td><div align="right" class="style2">Hubungan dengan Penjaga:</div></td>
    <td><?php echo $row_DetailRS1['hubungan']; ?></td>
  </tr>
  <tr>
    <td><div align="right" class="style2">Nama Penjaga:</div></td>
    <td><?php echo $row_DetailRS1['nama_penjaga']; ?></td>
  </tr>
  <tr>
    <td><div align="right" class="style2">No Hand Phone Penjaga::</div></td>
    <td><?php echo $row_DetailRS1['nohp_penjaga']; ?></td>
  </tr>
</table>

<p align="center"><a href="cari_ahli_robotik_urus.php">KEMBALI</a></p>
<p align="center">&nbsp;</p>
<form id="form2" name="form2" method="post" action="">
  <div align="center" class="style2">
    <p>PAPAR
      MAKLUMAT KELAS DAN JAWATAN</p>
    <p>
      <label>No Kad Pengenalan:
      <input name="textbox_my_nokp" type="text" id="textbox_my_nokp" value="<?php echo $row_DetailRS1['nokp_ahli']; ?>" size="12" readonly/>
      </label>
    </p>
    <p>
      <label>
      <input type="submit" name="button_kelas_jaw" id="button_kelas_jaw" value="CARI" />
      </label>
    </p>
  </div>
</form>
<p align="center">&nbsp;
<table border="1" align="center">
  <tr>
    <td><div align="center" class="style2">No Rujukan</div></td>
    <td><div align="center" class="style2">No Kad Pengenalan</div></td>
    <td><div align="center" class="style2">Tahun - Tingkatan</div></td>
    <td><div align="center" class="style2">Tingkatan</div></td>
    <td><div align="center" class="style2">Kelas</div></td>
    <td><div align="center" class="style2">Tahun - Jawatan</div></td>
    <td><div align="center" class="style2">Jawatan</div></td>
    <td><div align="center" class="style2">Catatan</div></td>
  </tr>
  <?php do { ?>
    <tr>
      <td><div align="center"> <?php echo $row_DetailRS2['id_ahli']; ?></div></td>
      <td><div align="center"><?php echo $row_DetailRS2['nokp_ahli']; ?>&nbsp; </div></td>
      <td><div align="center"><?php echo $row_DetailRS2['tahun_tk']; ?>&nbsp; </div></td>
      <td><div align="center"><?php echo $row_DetailRS2['tingkatan']; ?>&nbsp; </div></td>
      <td><div align="center"><?php echo $row_DetailRS2['namakelas']; ?></div></td>
      <td><div align="center"><?php echo $row_DetailRS2['tahun_jaw']; ?>&nbsp; </div></td>
      <td><div align="center"><?php echo $row_DetailRS2['jawatan']; ?></div></td>
      <td><div align="center"><?php echo $row_DetailRS2['catatan']; ?>&nbsp; </div></td>
    </tr>
    <?php } while ($row_DetailRS2 = mysql_fetch_assoc($DetailRS2)); ?>
</table>
<br />
<table border="0">
  <tr>
    <td><?php if ($pageNum_DetailRS2 > 0) { // Show if not first page ?>
          <a href="<?php printf("%s?pageNum_DetailRS2=%d%s", $currentPage, 0, $queryString_DetailRS2); ?>">First</a>
          <?php } // Show if not first page ?>
    </td>
    <td><?php if ($pageNum_DetailRS2 > 0) { // Show if not first page ?>
          <a href="<?php printf("%s?pageNum_DetailRS2=%d%s", $currentPage, max(0, $pageNum_DetailRS2 - 1), $queryString_DetailRS2); ?>">Previous</a>
          <?php } // Show if not first page ?>
    </td>
    <td><?php if ($pageNum_DetailRS2 < $totalPages_DetailRS2) { // Show if not last page ?>
          <a href="<?php printf("%s?pageNum_DetailRS2=%d%s", $currentPage, min($totalPages_DetailRS2, $pageNum_DetailRS2 + 1), $queryString_DetailRS2); ?>">Next</a>
          <?php } // Show if not last page ?>
    </td>
    <td><?php if ($pageNum_DetailRS2 < $totalPages_DetailRS2) { // Show if not last page ?>
          <a href="<?php printf("%s?pageNum_DetailRS2=%d%s", $currentPage, $totalPages_DetailRS2, $queryString_DetailRS2); ?>">Last</a>
          <?php } // Show if not last page ?>
    </td>
  </tr>
</table>
<div align="center">Records <?php echo ($startRow_DetailRS2 + 1) ?> to <?php echo min($startRow_DetailRS2 + $maxRows_DetailRS2, $totalRows_DetailRS2) ?> of <?php echo $totalRows_DetailRS2 ?>
  </p>
</div>
</body>
</html><?php
mysql_free_result($DetailRS1);

mysql_free_result($DetailRS2);
?>
Anon7 - 2022
AnonSec Team