I have this code that is allocating tasks to users on the system. At the moment the only thing being written to the database is one row that contains '0' in the 'taskID' column, '0' in the 'empID' column, and nothing in the 'emptaskweekDay' column.
I want it to write all the users tasks into the database so think i need to implement a loop in the taskAdminQuery page or something but not entirely sure.
Any help would be great. Thanks.
TaskAdmin.php
Code: Select all
<?php
session_start();
if (isset($_SESSION['username']) == false && ($_SESSION['type']) == 'user' && ($_SESSION['type']) == 'manager'){
header("Location: login.php");
exit();
}
require "connect.php";
$query = "select * from task where weekday = 'Monday' OR weekday = 'Everyday' ORDER BY taskID";
$result = mysql_query($query, $connection) or die ("Unable to perform query $query");
$query2 = "select * from employee where active = 'y'";
$result2 = mysql_query($query2, $connection) or die ("Unable to perform query $query2");
?>
<!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=iso-8859-1" />
<title>Task Allocation</title>
<link rel="stylesheet" type="text/css"
href="mystylelogin.css" />
</head>
<body>
<?php
include ("headerAdmin.php");
include ("TasksHeaderAdmin.php");
?>
<div id="Adminheader">Monday Task Allocation</div>
<div id="AdminMainTable">
<table width="860" >
<hr />
<tr>
<th width="142"><div align="left" class="style2">Task Name</div></th>
<th width="262"><div align="left" class="style2">Description</div></th>
<th width="140"><div align="left" class="style2">Weekday</div></th>
<th width="140"><div align="left" class="style2">Assign</div></th>
</tr>
<?php
//Build Select Menu
$employee_list = '<select name="empName"><option>Select an Employee</option>';
while ($row2 = mysql_fetch_array($result2))
$employee_list .= '<option>'.$row2['fName'].' '.$row2['sName'].'</option>';
$employee_list .= '</select>';
while($row = mysql_fetch_array($result))
{ ?>
<tr>
<td height="27"><?php echo $row['taskName']; ?></td>
<td><?php echo $row['taskDescription']; ?></td>
<td><?php echo $row['weekday']; ?></td>
<td>
<form><?php echo $employee_list; ?></form></td>
</tr>
<?php } ?></td>
</tr>
</table>
<form action="taskAdminQuery.php">
<input name="Save" type="submit" value="Allocate Tasks" />
</form>
</div>
</body>
</html>Code: Select all
<?php
require "connect.php";
//$empName = $_GET['empName'];
$empID = $_GET['empName'];
$emptaskweekDay = $_GET['weekday'];
$taskID = $_GET['taskID'];
$query = "insert into emptask values ('".$taskID."','".$empID."','".$emptaskweekDay."','N')";
$result = @mysql_query($query, $connection)
or die ("Error:".mysql_error());
$message1 = "Tasks Allocated Successfully.";
header("Location: TaskAdmin.php?message1=$message1");
exit();
//}
?>