Solved: Post form to itself with 2D array of check boxes

I have a MySQL table called projects that has 9 fields; a building name and 8 different types of projects for the building. I am trying to create a page with a check box for every project type for each building. The image below shows that table that is properly displaying from the database.

I am trying to have this form post to itself, and when it loads save the checks to the database. I am really having trouble with this, because I can't keep my names correct. I think my problem is that I don't fully understand how the check boxes work- I'm not very experienced with web programming.

I've attached my code, what exactly do I need to include at the top to get the results from the post, update the database, and then display the updated checks?

Thanks!!!

<?


session_start();
if($_SESSION['auth']!="yes")
	{
	header("Location: index.php");
	exit();
	}

$username = $_SESSION['username'];

include("SQLLogin.inc");


// H E R E   I  S   W H E R E   I    N E E D    T O   A D D   C O D E 



?>


<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
</head>

<body>


<? //include("header.inc");  ?>


<form method="post" action="home.php"> <p>


<? 


$query = "SELECT * FROM projects ORDER BY 'order' ";
$result = mysql_query($query) or die ("Could not access the database to read directory");
echo "<table cellspacing='0' cellpadding='0' width='100%' border='0'>	";

$count = 1;

?>

<tr bgcolor='#bfc2ff' >
	<td>
		Building
	</td>
	<td>
		HVAC
	</td>
	<td>
		HVAC
	</td>
	<td>
		Light
	</td>
	<td>
		Envelope
	</td>
	<td>
		Water
	</td>
	<td>
		Special
	</td>
	<td>
		ECM
	</td>
	<td>
		Report
	</td>
	<td>
		Percent
	</td>
	<td>
		Notes
	</td>
</tr>

<?

while($row=mysql_fetch_array($result))
	{
	extract($row);

	if($count % 2 == 0)
		$color ='#bfe2f9';
	else
		$color = '#ECF7FD';
	?>

	<tr bgcolor="<? echo $color; ?>" >
	<td>
		<? echo $building; ?>
	</td>
	<td>
		<input type="checkbox" name="<? echo $ID; ?>" value="hvacA" />
	</td>
	<td>
		<input type="checkbox" name="<? echo $ID; ?>" value="hvacB" />
	</td>
	<td>
		<input type="checkbox" name="<? echo $ID; ?>" value="Light" />
	</td>
	<td>
		<input type="checkbox" name="<? echo $ID; ?>" value="Envelope" />
	</td>
	<td>
		<input type="checkbox" name="<?  echo $ID; ?>" value="Water" />
	</td>
	<td>
		<input type="checkbox" name="<?  echo $ID; ?>" value="Special" />
	</td>
	<td>
		<input type="checkbox" name="<?  echo $ID; ?>" value="ECM" />
	</td>
	<td>
		<input type="checkbox" name="<?  echo $ID; ?>" value="Report" />
	</td>
	<td>
		<input type="checkbox" name="<?  echo $ID; ?>" value="Percent" />
	</td>
	<td>
		<input type="checkbox" name="<?  echo $ID; ?>" value="Notes" />
	</td>
</tr>

<?
	$count = $count + 1;
	}

?>

</table>

<p align="center">
<input type = hidden name = "passedUser" value ="<? echo '$username'; ?>" />
<input type="submit" name="submit" value="Save Changes"/></p>

	</font>
	<p align="center">

&nbsp;</p>
</p> </form>

</body>



<?
mysql_close($connection);
?>

Open in new window

image.JPG

Post form to itself with 2D array of check boxes

Premium Content

Premium Content

Why Experts Exchange?

Ask ANY Question

Did You Know?