Check Box Submision

sizemik

I have a form with a checkbox in it and everything works except the checkbox to submit to a database.

do I need to do anything different for a text box (like is it 0 for blank, 1 for checked?)

<?
// form not yet submitted
// display initial form
if (!$submit)
{
include("addform.php");
}
else
{
	// includes
	include("config.php");
	include("functions.php");

// open database connection
dbcon();

// select database
selectdb();

//Set new values for input
parse2();

// generate and execute query
$sql = "INSERT INTO $database(ID, Department, Full Name, Sex, Position, Salaried, Salary, Full Time, Hours, Rate, Tax Rate, NI Number, NI Cont, Telephone, Address1, Town, Country, Post Code) VALUES('$ID', '$Department', '$Full Name', '$Sex', '$Position', '$Position', '$Salaried', '$Salary', '$Full Time', '$Hours', '$Rate', '$Tax Rate', '$NI Number', '$NI Cont', '$Telephone', '$Address1', '$Town', '$Country', '$Post Code')";
ececq();

// print result
echo "<font size=-1>Update successful. <a href=index.php>Go back to the main menu</a>.</font>";

// close database connection
close();
}
?>

<html>

<head>
</head>

<body>

<form method="POST" action="<?php echo $PHP_SELF; ?>">
  <p>Full Name:<input type="text" name="Full Name" size="20">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>
  <p>
  Sex:<select size="1" name="Sex">
    <option selected value="Male">Male</option>
    <option value="Female">Female</option>
  </select>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>
  <p>Department:<select size="1" name="D2">
    <option selected value="Admin">Admin</option>
    <option value="Footwear">Footwear</option>
    <option value="Sports">Sports</option>
    <option value="Casual">Casual</option>
    <option value="Smart">Smart</option>
  </select>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>
  <p>
  Position:<input type="text" name="Position" size="20">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>
  <p>Salaried:<input type="checkbox" name="Salaried" value="ON">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>
  <p>
  Salary (£):<input type="text" name="Salary" size="9"></p>
  <p>Full Time:<input type="checkbox" name="Full Time" value="ON">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>
  <p>
  Hours:<input type="text" name="Hours" size="4">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>
  <p>Rate (£):<input type="text" name="Rate" size="4">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>
  <p>
  Tax Rate:<input type="text" name="Tax Rate" size="5">%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>
  <p>NI Number:<input type="text" name="NI Number" size="13">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>
  <p>
  NI Cont (£):<input type="text" name="NI Cont" size="7"></p>
  <p>Telephone:<input type="text" name="Telephone" size="15">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>
  <p>
  Address 1:<input type="text" name="Address 1" size="23">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>
  <p>Town: <input type="text" name="Town" size="20">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>
  <p>County: <input type="text" name="County" size="20"></p>
  <p>Post Code: <input type="text" name="Post Code" size="13"></p>
  <p><input type="submit" value="Submit" name="Submit"><input type="reset" value="Reset" name="Reset"></p>
</form>

</body>

</html>

<?php
	/**********************************
	 functions.php - Script to define functions
	*/

//Print a home page link
function homelink()
	{
	global $home = $home;

	echo("<a href=$home>Go Home</a>");
	}

//Connect to the database
function dbconn()
	{
	global $host = $host;
	global $user = $user;
	global $pass = $pass;

	$conn = mysql_connect($host, $user, $pass) or die("Could not connect to the database. Reason: mysql_errno(); mysql_error();");

	return $conn;
	}

//Select the database
function selectdb()
	{
	global $database = $database;

	mysql_select_database($database);

	return $db;
	}

//Execute a query
function execq()
	{
	global $sql = $sql;
	global $conn = $conn;

	$result = mysql_query($sql, $conn);
	return $result;
	}

//Close Connection
function close()
	{
	global $conn = $conn;

	mysql_close($connection);
	}

//Parse the $row["*"] values to $*
funtion parse()
	{
	global $row["ID"] = $ID
	global $row["Full Name"] = $Full Name
	global $row["Sex"] = $Sex
	global $row["Department"] = $Department
	global $row["Position"] = $Position
	global $row["Salaried"] = $Salaried
	global $row["Salary"] = $Salary
	global $row["Full Time"] = $Full Time
	global $row["Hours"] = $Hours
	global $row["Rate"] = $Rate
	global $row["Tax Rate"] = $Tax Rate
	global $row["NI Number"] = $NI Number
	global $row["NI Cont"] = $NI Cont
	global $row["Telephone"] = $Telephone
	global $row["Address 1"] = $Address 1
	global $row["Town"] = $Town
	global $row["County"] = $County
	global $row["Post Code"] = $Post Code
	}

//Parse the numerical values to text 
function parse1()
	{
	if ($Department = 0)
		{
		$Department = Admin
		}
	else if ($Department = 1)
		{
		$Department = Footwear
		}
	else if ($Department = 2)
		{
		$Department = Sports
		}
	else if ($Department = 3)
		{
		$Department = Casual
		}
	else if ($Department = 4)
		{
		$Department = Casual
		}

	if ($Sex = 0)
		{
		$Sex = Male
		}
	else if ($Sex = 1)
		{
		$Sex = Female
		}

	if ($Salaried = 0)
		{
		$Salaried = No
		}
	else if ($Salaried = 1)
		{
		$Salaried = Yes
		}

	if ($FullTime = 0)
		{
		$FullTime = No
		}
	else if ($FullTime = 1)
		{
		$FullTime = Yes
		}
	}

//Parse text values to numerical
function parse2()
	{
	if ($Department = Admin)
		{
		$Department = 0
		}
	else if ($Department = Footwear)
		{
		$Department = 1
		}
	else if ($Department = Sports)
		{
		$Department = 2
		}
	else if ($Department = Casual)
		{
		$Department = 3
		}
	else if ($Department = Smart)
		{
		$Department = 4
		}

	if ($Sex = Male)
		{
		$Sex = 0
		}
	else if ($Sex = Female)
		{
		$Sex = 1
		}

	if ($Salaried = No)
		{
		$Salaried = 0
		}
	else if ($Salaried = Yes)
		{
		$Salaried = 1
		}

	if ($FullTime = No)
		{
		$FullTime = 0
		}
	else if ($FullTime = Yes)
		{
		$FullTime = 1
		}
	}	
?>

lnxgeek

Try changing the value of 'Salaried' in your form to '1'.

sizemik

thanks
will try that tomorrow