| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/Software/ |
Upload File : |
<?php require_once('../Connections/products.php');
ini_set('include_path',ini_get('include_path').PATH_SEPARATOR.$_SERVER['DOCUMENT_ROOT']."/"); // Add the DOCUMENT_ROOT to the include_path.
include('application.phpinc');
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;
}
}
if (isset($_SESSION['userId']) && $_SESSION['userId'] != '') { $sess_ID = $_SESSION['userId'];}
else { $sess_ID ='Error';}
if (isset($_SESSION['userStudentId']) && $_SESSION['userStudentId'] != '') { $userID = $_SESSION['userStudentId'];}
else { $userID ='** Error need to log in.';}
mysql_select_db($database_products, $products);
$query_Recordset_product = "SELECT * FROM product";
$Recordset_product = mysql_query($query_Recordset_product, $products) or die(mysql_error());
$row_Recordset_product = mysqli_fetch_assoc($Recordset_product);
$totalRows_Recordset_product = mysql_num_rows($Recordset_product);
$maxRows_Recordset_Available = 10;
$pageNum_Recordset_Available = 0;
if (isset($_GET['pageNum_Recordset_Available'])) {
$pageNum_Recordset_Available = $_GET['pageNum_Recordset_Available'];
}
$startRow_Recordset_Available = $pageNum_Recordset_Available * $maxRows_Recordset_Available;
// get a recordset of all product descriptions that are available for user to checkout
mysql_select_db($database_products, $products);
$query_Recordset_Available = "SELECT distinct(product.productDescription ) FROM product, productkey WHERE productkey.productkeyAvailable = 'Y'";
$query_limit_Recordset_Available = sprintf("%s LIMIT %d, %d", $query_Recordset_Available, $startRow_Recordset_Available, $maxRows_Recordset_Available);
$Recordset_Available = mysql_query($query_limit_Recordset_Available, $products) or die(mysql_error());
$row_Recordset_Available = mysqli_fetch_assoc($Recordset_Available);
if (isset($_GET['totalRows_Recordset_Available'])) {
$totalRows_Recordset_Available = $_GET['totalRows_Recordset_Available'];
} else {
$all_Recordset_Available = mysql_query($query_Recordset_Available);
$totalRows_Recordset_Available = mysql_num_rows($all_Recordset_Available);
}
$totalPages_Recordset_Available = ceil($totalRows_Recordset_Available/$maxRows_Recordset_Available)-1;
mysql_select_db($database_products, $products);
$query_Recordset_AssignedKeys =
"SELECT *
FROM product
JOIN productkey on product.productID = productkey.productID
JOIN productlocation on productlocation.productkeyID =productkey.productkeyID
WHERE productlocation.userStudentID = '$userID';
";
$Recordset_AssignedKeys = mysql_query($query_Recordset_AssignedKeys, $products) or die(mysql_error());
$row_Recordset_AssignedKeys = mysqli_fetch_assoc($Recordset_AssignedKeys);
$totalRows_Recordset_AssignedKeys = mysql_num_rows($Recordset_AssignedKeys);
?><?
// ProductKey/ProductKey.phpinc
debugTrackBegin();
if (dc()) { echo basename(__FILE__)," line ",__LINE__,": ","<b>".__FILE__."</b><br>\n"; }
if (!isset($courseNumber)) { $courseNumber =""; }
//echo "\$courseNumber=".$courseNumber."<br>\n";
//if (!isset($courseTitle)) { $courseTitle =""; }
$headTitle = '_CST_ - Assigned Product Keys';
$pageTitle = '<br>Product Keys';
//if ($courseNumber != "") { $pageMenu = 'Course/courseMenu.phpinc'; }
include('../common/pageHeader.phpinc');
$sectionTitle = $courseNumber."Product Key";
include('..common/sectionHeader.phpinc');
?>
<link href="<?=$_SESSION['HTTP_ROOT']?>/css/CST.css" rel="stylesheet" type="text/css" />
<script language=javascript>var server = "ridgewater"; var domain = "edu";</script>
<p>
<fieldset>
<legend>Checkout Product Keys </legend>
<br><span class="normal">
Product Keys is a way for students or instructors to check out available product keys.
<br><br>
Product keys that are currently assigned to <?php echo " $userID "; ?>
</span>
<?php $color='#FEFDE9'; $color= rotate_colors($color); ?>
<table style="text-align:center;" align="center" cellpadding="5" cellspacing="0" border="1" >
<tr>
<td>Description</td>
<td>Date Out</td>
<td>StudentID</td>
</tr>
<?php do { ?>
<?php $color= rotate_colors($color); ?>
<tr bgcolor ='<?php echo $color ?>'>
<td><?php echo $row_Recordset_AssignedKeys['productDescription']; ?></td>
<td><?php echo $row_Recordset_AssignedKeys['productlocationDateOut']; ?></td>
<td><?php echo $row_Recordset_AssignedKeys['userStudentID']; ?></td>
</tr>
<?php } while ($row_Recordset_AssignedKeys = mysqli_fetch_assoc($Recordset_AssignedKeys)); ?>
</table>
<br>
<span class="normal">
<!--
$user_ID =$_SESSION['userId'];
SELECT * FROM user where '$user_ID' = userId
-->
<table style="text-align:center;" align="center" cellpadding="15" cellspacing="0" border="0" >
<tr>
<td><p> </p>
<p> </p>
<p> </p></td>
<td><p> </p>
</td>
</tr>
</table>
</fieldset>
<?
include('common/sectionFooter.phpinc');
include('common/pageFooter.phpinc');
// ********************************************************************************************
// ** Rotate colors for table rows
// ********************************************************************************************
function rotate_colors($color)
{
if($color=='#FEFDE9' ) $color='#EDEDED';
else $color='#FEFDE9';
return $color;
}
?>
<?php
mysql_free_result($Recordset_product);
mysql_free_result($Recordset_Available);
mysql_free_result($Recordset_AssignedKeys);
?>