Jump to content

Inserting variables Error


almystersv

Recommended Posts

Hi Guys,

 

I am gettins stuck on this section of my website. Its function is to alocate users specific tasks. At the moment though, the code does not seem to carry across the variables 'taskID', 'empID', emptaskweekDay'. As i am getting the error message "Unable to perform query

insert into emptask values ('','','','N')"

 

It is probably something very simple but I have tried a number of things and cannot get it to work.

 

Here is my taskadmin page code

<?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>

 

Here is my taskAdminQuery code

<?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");

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

 

Any help will be greatly appreciated.

 

Thanks

Link to comment
https://forums.phpfreaks.com/topic/90560-inserting-variables-error/
Share on other sites

Your Problem is HERE

 

<?php $query =  "insert into emptask values ('".$taskID."','".$empID."','".$emptaskweekDay."','N')"; ?>

 

 

Should be

 

<?php $query =  "INSERT INTO `emptask` (`field1`,`field2`,`field3`,`field4`) VALUES ('$taskID','$empID','$emptaskweekDay','N')"; ?>

 

Replace Field1, Field2,Field3,Field4 with your mysql fields, each value asigned to the field in the order given for both sides.

this just made me laugh

 

<?php
$query =  "insert into emptask values ('".$taskID."','".$empID."','".$emptaskweekDay."','N')";
$result = @mysql_query($query, $connection) 
or die ("Unable to perform query<br>$query");
?>

 

@ to suppress it but then an or die to push the error ?

And Some Good Resources Next Time:

 

http://www.google.ca/search?hl=en&q=PHP+mysql+INSERT&btnG=Google+Search&meta=

http://www.w3schools.com/php/php_mysql_insert.asp

http://www.php-mysql-tutorial.com/mysql-insert-php.php

http://www.tizag.com/mysqlTutorial/mysqlinsert.php

 

Note: As Cooldude(still laughing) said, you should add a

or die(mysql_error());

to "push" the error right out of the query, and into the browser.

InnoDB also supports foreign key constraints. The syntax for a foreign key constraint definition in InnoDB looks like this:

InnoDB rejects any INSERT  or UPDATE operation that attempts to create a foreign key value in a child table if there is no a matching candidate key value in the parent table. 

Archived

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

×
×
  • 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.