File: C:/xampp/htdocs/PBN/addjob.php
<?php
session_start();
include("functions.php");
if(isset($_SESSION["user_id"])) {
if(isLoginSessionExpired()) {
header("Location:logout.php?session_expired=1");
}
}
?>
<html>
<head>
<title>User Login</title>
<link rel="stylesheet" type="text/css" href="styles.css" />
</head>
<body>
<table border="0" cellpadding="10" cellspacing="1" width="100%">
<tr class="tableheader">
<td align="center">User Dashboard</td>
</tr>
<tr class="tablerow">
<td>
<?php
error_reporting(0);
$jobid='';
if(isset($_SESSION["user_name"]) ) {
$userid=$_SESSION["user_id"];
//echo "jobid here=".$jobid;
$host="127.0.0.1";
$user="root";
$pass="hpwebadmin";
$db="psamember";
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_query("SET NAMES 'utf8'");
mysql_select_db($db) or die ("Unable to select database!");
$jobname=$_POST["jobname"];
$printer=$_POST["printer"];
$ink=$_POST["ink"];
$paper=$_POST["paper"];
$target=$_POST["target"];
$mode=$_POST["mode"];
$device=$_POST["device"];
$email=$_POST["company"];
$queryI = "INSERT INTO PSAjob (job_name, press, ink, paper, target,mode, device, email) VALUES ('$jobname', '$printer', '$ink', '$paper', '$target','$mode','$device','$email') ";
//echo $queryI;
$resultI = mysql_query($queryI) or die ("Error in query: $queryI. " . mysql_error());
}
$account=$_SESSION["user_name"];
$host="127.0.0.1";
$user="root";
$pass="hpwebadmin";
$db="psamember";
$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 PSAjob ORDER BY id DESC LIMIT 1";
//$queryU = "SELECT * from PSAjob where email='$account' and job_name";
//echo $queryU;
$resultU = mysql_query($queryU) or die ("Error in query: $queryU. " . mysql_error());
while($row = mysql_fetch_object($resultU))
{
header("Location: http://210.71.174.66/fred/psa/user_dashboard.php?jobid=.$row->id&jobname=$row->job_name&printer=$row->press&ink=$row->ink&paper=$row->paper&target=$row->target&mode=$row->mode&device=$row->device&email=$row->email");
exit;
}
?>
<p>
</td></tr></table></html>