Jump to content

Inserting a number of records into a database with one button click

almystersv

By almystersv
in PHP Coding Help

Recommended Posts

almystersv Member

almystersv

Posted
Posted

Hi Guys,

 

I have a page that allows the admin to allocate a number of different tasks to employees via a number of drop down menus reading from an mySQL database.

 

I have the drop down menus functioning fine but am encountering problems when trying to get the data written into the database

 

here is my code...

<?php
session_start();
if (isset($_SESSION['type']) == 'admin'){
	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");
?>
  <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 value=" '.$row2['empID'].' "> '.$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 action="taskAdminQuery.php"><?php echo $employee_list; ?></td>
  	</tr>
<?php
}
?>
<input name="Save" type="submit" value="Allocate Tasks" />
</form>
</table>
<?php if(isset($_GET['message1']))
{
	echo $_GET['message1'];
} ?>
</body>
</html>

 

Here is the taskQuery page...

<?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 ("Unable to perform query<br>$query");
header("Location: TaskAdmin.php");

$message1 = "Tasks Allocated Successfully.";
header("Location: TaskAdmin.php?message1=$message1");
exit();
//}
?>

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.