File: C:/xampp/htdocs/PBN/joblist.php
<?php session_start();
include("functions.php");
if(isset($_SESSION["user_id"])) {
if(isLoginSessionExpired()) {
header("Location:logout.php?session_expired=1");
}
}
?>
<?php
if(isset($_SESSION["user_name"])) {
$userid=$_SESSION["user_id"];
$host="127.0.0.1";
$user="root";
$pass="fredsql";
$db="pbnmember";
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_query("SET NAMES 'utf8'");
//$link = mssql_connect("MACBOOK7", "sa", "fred5697");
mysql_select_db($db) or die ("Unable to select database!");
$queryU = "UPDATE registered_users set ldate= now() where id='$userid'";
// echo $queryU;
$resultU = mysql_query($queryU) or die ("Error in query: $queryU. " . mysql_error());
}
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>PBN Tool</title>
<link rel="stylesheet" type="text/css" href="styles.css" />
</head>
<body>
<table align="center">
<?php
if(isset($_SESSION["user_name"])) {
?>
<form action="addjob.php" method="post"
enctype="multipart/form-data">
</tr>
<br>
<table border="0" cellpadding="10" cellspacing="1" width="100%" class="tblLogin">
<tr class="tableheader">
</tr>
</table>
<table align="center">
<tr>
<td valign="top"><b><font size="-1">Create a new job name to activate PSA-tool function </font></b> </td>
</tr>
<tr>
<td valign="top"><b><font size="-1">Enter new job name: </font></b>
<input size="25" maxlength="80" type="text" name="jobname" > </td>
</tr>
<tr>
<td valign="top"><b><font size="-1">Select target: </font></b>
<SELECT NAME="target">
<OPTION VALUE=Fogra39 >Fogra 39
<OPTION VALUE=CRPC6 SELECTED>CRPC6
<OPTION VALUE=GRACoL2006>GRACoL2006
</SELECT>
</tr>
<tr>
<td valign="top"><b><font size="-1">acccount: </font></b>
<input size="25" maxlength="80" type="text" name="company" value=<?php echo $_SESSION["user_name"];?> > </td>
</tr>
<tr>
<td colspan="2" scope="row"><font size="-1">(printer): </font>
<input size="15" maxlength="50" type="text" name="printer" /></td>
<td> </td>
</tr>
<tr>
<td valign="top"><b><font size="-1">(paper): </font></b>
<input size="15" maxlength="50" type="text" name="paper"></td>
</tr>
<tr>
<td valign="top"><b><font size="-1">(ink): </font></b>
<input size="15" maxlength="50" type="text" name="ink"></td>
</tr>
<tr>
<td valign="top"><b><font size="-1">measuring device: </font></b>
<input size="15" maxlength="50" type="text" name="device"></td>
</tr>
<tr>
<td valign="top"><b><font size="-1">measuring mode: </font></b>
<SELECT NAME="mode">
<OPTION VALUE=M0 >M0
<OPTION VALUE=M1 SELECTED>M1
<OPTION VALUE=M2 >M2
</SELECT>
</tr>
<tr><td>
<input type="submit" name="submit" value="Submit">
</td>
</tr>
<tr><td>======================================</td></tr>
<tr><td> Job History: </td></tr>
<?php
$account=$_SESSION["user_name"];
$host="127.0.0.1";
$user="root";
$pass="fredsql";
$db="pbnmember";
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_query("SET NAMES 'utf8'");
//$link = mssql_connect("MACBOOK7", "sa", "fred5697");
mysql_select_db($db) or die ("Unable to select database!");
$queryU = "SELECT * from Pbnjob where email='$account'";
//echo $queryU;
$resultU = mysql_query($queryU) or die ("Error in query: $queryU. " . mysql_error());
while($row = mysql_fetch_object($resultU))
{ ?>
<tr><td><a href="user_dashboard.php?jobid=<?php echo $row->id;?>&jobname=<?php echo $row->job_name;?>&printer=<?php echo $row->press;?>&ink=<?php echo $row->ink;?>&paper=<?php echo $row->paper;?>&target=<?php echo $row->target;?>&mode=<?php echo $row->mode;?>&device=<?php echo $row->device;?>&email=<?php echo $row->email;?> " /a> <?php echo $row->job_name; ?> </td></tr>
<?php
}
?>
<tr><td><br><br>Click here to <a href="logout.php" tite="Logout">Logout.</a></td></tr>
<p>
<tr align="center">
<td>
<!-- GoStats Simple HTML Based Code -->
<a target="_blank" title="site stats" href="http://gostats.com"><img alt="site stats"
src="http://c3.gostats.com/bin/count/a_327001/t_7/i_12/z_0/show_hits/counter.png"
style="border-width:0" /> </a>
<!-- End GoStats Simple HTML Based Code -->
</td></tr>
<tr>
<td align="center"><font size="-2"> © <a href="http://www.fredkuo.idv.tw/wordpress">Fred Kuo</a>, 2015. All rights reserved.<br><br>
</td>
</tr>
</form>
<?php }
else {
echo "Session expired.";?>
<a href="../PBN">Please Login Again</a><br>
<?php }
?>
</table>
</body>
</html>