List Box

[christiane]

I am writing a program that allows teacehrs/ administrators for the school distrct I am employeed with to send email to students and parents. I have the program working fine at the moment but I would like to impliment a feature that allows the faculty member to see who their message is going to be sent to then by using alist box select/ deselect those that they do not wish to receive it. I have gottent he list box to be populated from the announcement db, but I cannot get the information out of the list box to go back into the DB to select only the users listed. Can some one help me out here?? Thanks admins this site rocks.

Erick C.

[kevinsequeira]

could you post the code for what you have done till now so we can suggest how to implement what u want
reg
kevin

[christiane]

<?php
if (!IsSet($_POST["test"]))
{
//form that displays users that are in the database currently available to the end user
?>
<FORM METHOD=POST ACTION="hello.php">
  <p>
    <SELECT NAME="test" SIZE=5 MULTIPLE>
      <?php
/* Open connection to the database */
mysql_connect("localhost", "user", "password") or die("<OPTION>Database error!</OPTION></SELECT>");
mysql_select_db("announcementdb");

/* Download list of users */
$query = "SELECT * FROM announcedb ORDER BY SLNAME";
$result = mysql_query($query);
while($myrow = mysql_fetch_array($result))
    {
    //displays the results of the query
	print("<OPTION VALUE=\"$myrow[0]\" SELECTED>$myrow[1], $myrow[2], $myrow[3],$myrow[4],$myrow[5],$myrow[6]\n");
    }
?>
    </SELECT>
  </p>
  <p> 
    <INPUT TYPE=SUBMIT>
    <input name="test" type="hidden" value="">
  </p>
</FORM>
<?php
}
if (IsSet($_POST["test"]))
{
//this oortion of the code I grabbed from the php 4 bible. this is the only portion I am having problems with.
while(list($key, $val) = each($_POST["test"]))
    {
    /*this was just so I could see what format it was going to spitting the information from 
the select box out and then create a mysql query around it*/
	print $val.', '.$email."another test";
    }

}
?>

[kevinsequeira]

try this

<?php
if (!IsSet($_POST["test"])){
//form that displays users that are in the database currently available to the end user
?>
<FORM METHOD=POST ACTION="hello.php">
  <p>
      <?php
/* Open connection to the database */
mysql_connect("localhost", "user", "password") or die("<OPTION>Database error!</OPTION></SELECT>");
mysql_select_db("announcementdb");
/* Download list of users */
$query = "SELECT * FROM announcedb ORDER BY SLNAME";
$result = mysql_query($query);
?>
    <SELECT NAME="user[]" SIZE=5 MULTIPLE>
<?php
while($myrow = mysql_fetch_array($result)){
?>
    <OPTION VALUE="<?php print($myrow[0]);?>"><?php print($myrow[1]); ?>
<?php
    }
?>
    </SELECT>
  </p>
  <p> 
   <INPUT TYPE=SUBMIT>
    <input name="test" type="hidden" value="yes">
  </p>
</FORM>
<?php
}
if (IsSet($_POST["test"])){
	for ($i = 0; $i < sizeof($user); $i++) {
		echo $user[$i]."<BR>";
	}
}
?>

reg
kevin

[christiane]

It is giving me an error sayign that the variable "user" is undefined?

[kevinsequeira]

on what line of code is it giving the error ? have u changed the name of the select box to user[] ??

reg
kevin

[christiane]

The error is on line 47. The select box is still named user[]. 😕

[kevinsequeira]

what code is there on line 47 ???
is it for ($i = 0; $i < sizeof($user); $i++) {

also try changing

<SELECT NAME="user[]" SIZE=5 MULTIPLE>
to
<SELECT NAME="user[]" MULTIPLE="MULTIPLE">

reg
kevin

[christiane]

Sorry, that should have been included on my reply... Yes, that is the code on line 47.

[laserlight]

Maybe try:

<?php
if (!isset($_POST["test"])) {
	//form that displays users that are in the database currently available to the end user
?>
<form action="hello.php" method="post">
<p>
<?php
	/* Open connection to the database */
	mysql_connect("localhost", "user", "password") or die("Database error!");
	mysql_select_db("announcementdb");
	/* Download list of users */
	$query = "SELECT * FROM announcedb ORDER BY SLNAME";
	$result = mysql_query($query);
?>
<select name="user[]" size="5" multiple>
<?php
	while($myrow = mysql_fetch_array($result)) {
		echo '<option value="' . $myrow[0] . '">' . $myrow[1] . "</option>\n";
	}
?>
</select>
</p>
<p> 
<input type="submit" value="Submit">
<input name="test" type="hidden" value="yes">
</p>
</form>
<?php
}
else {
	$user = $_POST['user'];
	$size = count($user);
	for ($i = 0; $i < $size; $i++) {
		echo $user[$i] . '<br>';
	}
}
?>

didnt really check the logic though

[christiane]

That got it. It makes sense now, thanks a lot guys!

[kevinsequeira]

try this

if (IsSet($POST["test"])){
$user = $POST('user');
for ($i = 0; $i < sizeof($user); $i++) {

    echo $user[$i]."<BR>";

}

[Moonglobe]

$user = $_POST['user'];

[/b]

korekshun.