Dynamic Checkbox Insert

Static_Cling

First off, thanks to all here for the help you have given me so far. I've learned so much in such a short time...

My current problem, is actually a couple of problems I'm having. First, I have a page that lists users in my database, by dynamic checkbox. What I am trying to do is simply just insert those users that are checked into the table...seems easy, but for some reason, I can't seem to get it right. Basically taking this first page and then want to pass it to another that will do the insert...this is where my second problem comes in. I'm passing a variable along with this and am able to get it to the 1st page, but it will not go to the 2nd page..here is my code (what it is now) and I would appreciate any help...(you'll notice that right now I'm just trying to echo my variables so I know I'm on the right track)

assign.php

<?
include('db_connect.php');
$GET['coursename'];
$SESSION['username'];
$sql = "SELECT * FROM users;";
$result = mysql_query( $sql );
while ($a_row = mysql_fetch_array($result) ) {
echo "<br><input type='checkbox' name='Num" . $a_row["username"] . "' value='1'>" . $a_row["name"];
}
$username = $a_row["username"]

?>
<form action="insertcourse.php" method="post" name="insertcourse">
<input type="submit" name="Submit" value="Submit">
</form>

?>

insert.php

<?php
include('db_connect.php');
$GET['coursename'];
$GET['username'];
$today = date("m-d-y");

echo "$coursename, $users, $today";

?>

devinemke

you should return the list of checked users as an array. here is a simple exmaple:

<?php
include('db_connect.php');

if (!isset($_POST['submit']))
{
	echo '<form action="" method="post">';

$result = mysql_query('SELECT * FROM users') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	echo '<input type="checkbox" name="users[]" value="' . $row['username'] . '">' . $row['name'] . '<br>'; 
} 

echo '
<input type="submit" name="submit" value="submit">
</form>
';
}
else
{
	if (isset($_POST['users']))
	{
		echo 'you checked the following users:<br><br>';
		foreach ($_POST['users'] as $value)
		{
			echo $value . '<br>';
		}
	}
	else
	{
		echo 'you did not check any users';
	}
}
?>

Static_Cling

so using the following code (thnks again for the hlp) I am now able to insert multiple rows into the db....
Problem I"m having now, just goes to a blank page after insertion, how do I get it to go to a page that would tell them assignment was sucessful...thanks

<?php
include('db_connect.php');
$GET['coursename'];
$SESSION['username'];
$date = date('m-d-Y');
if (!isset($_POST['submit']))
{
echo '<form action="" method="post">';

$result = mysql_query('SELECT * FROM users') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
    echo '<input type="checkbox" name="users[]" value="' . $row['username'] . '">' . $row['name'] . '<br>'; 
} 

echo '
<input type="submit" name="submit" value="submit">
</form>
';

}
else
{
if (isset($POST['users']))
{
//echo 'you checked the following users:<br><br>';
foreach ($POST['users'] as $value)
{
//echo $coursename .'<br>';
//echo $value . '<br>';
$sql = "INSERT into Assignments

VALUES ('$value','$coursename','','$date')";
mysql_query($sql) or die (mysql_error());
}
}
}
?>

topsub

header redirect Just put it after the insert stuff

$site = "http://www.yourwebsite.com/uploadcomplete.html";
header("Location:".$site);

Static_Cling

problem is I've already sent header info, so that won't work...I've tried this:

print ("<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=http://www.yoursite.com\">");

method by putting this code at the bottom of my page, but it goes to the assign page and and then directly goes to the the site I put in the print script...doesn't give me the chance to do an insert...so whats' the best way to do a redirect if you've already sent header info?

topsub

if you have that code on its own page when you post to that page the headers won't be sent yet.

But if you include that script on the page that the form is on then yes the headers will already be sent.

devinemke

you should really read up on Output Control Functions

Weedpacket

But why would you be sending page output to the client if you're just going to redirect the client to another page anyway? Seems like a bit of a waste of effort if you ask me.