[RESOLVED] More then one select box in single page...

[palak]

hi...

i m trying to get values of more then one select box on same page..

i am showing list of all users with select box..so per user there is one select box...

i want to get the value of all select box...which is select or not select...

here is my code...

include '../dbconnect.php';

$result = mysql_query("SELECT MatriID,Email,Name,Gender,Regdate,Status FROM user where Status = 'Active' LIMIT $from, $max_results ");

$nomod = mysql_num_rows($result);

<table width="98%" border="0" align="center" cellpadding="4" cellspacing="0">

            <tr>
              <td width="4%" bgcolor="#FFFFCC" class="HeadText1">&nbsp;</td>
              <td width="8%" bgcolor="#FFFFCC" class="HeadText1"><strong>ID</strong></td>
              <td width="17%" bgcolor="#FFFFCC" class="HeadText1"><strong>Email</strong></td>
              <td width="17%" bgcolor="#FFFFCC" class="HeadText1"><strong>Name</strong></td>
              <td width="10%" bgcolor="#FFFFCC" class="HeadText1"><strong>Gender</strong></td>
              <td width="15%" bgcolor="#FFFFCC" class="HeadText1"><strong>Reg On</strong></td>
              <td width="13%" bgcolor="#FFFFCC" class="HeadText1"><strong>Status</strong></td>
              <td width="16%" bgcolor="#FFFFCC" class="HeadText1"><strong>Full View </strong></td>
			  <td width="16%" bgcolor="#FFFFCC" class="HeadText1"><strong>Moderators </strong></td>
              </tr>
			 <?php while($row = mysql_fetch_array($result)){ ?>
            <TR bgcolor="#FFFFFF" onMouseOver="this.bgColor='gold';" onMouseOut="this.bgColor='#FFFFFF';">
              <input type="hidden" name="matriid" id="matriid" value="<?php echo $row['MatriID'] ?>" />
			  <td class="smalltextgrey">&nbsp;</td>

              <td class="smalltextgrey"><?php echo $row['MatriID']?></td>
              <td class="smalltextgrey"><?php echo $row['Email']?></td>
              <td class="smalltextgrey"><?php echo $row['Name']?></td>
              <td class="smalltextgrey"><?php echo $row['Gender']?></td>
              <td class="smalltextgrey"><?php echo $row['Regdate']?></td>
              <td class="smalltextgrey"><?php echo $row['Status']?></td>
              <td class="smalltextgrey"><a href="viewprofile.php?ID=<?php echo $row['MatriID']?>">View</a></td>
			  <td class="smalltextgrey">
			  	<select name="mod[]" onchange="func(this);">
					<option value="">Select Moderator</option>
				<?php
					$mod = mysql_query("select * from moderators");
					$nomod = mysql_num_rows($mod);

					while($modrow = mysql_fetch_array($mod))
					{ ?>
						<option value="<?php echo $modrow['modid'] ?>"><?php echo $modrow['username'] ?></option>
				<?php	}
				?>
				</select>
			  </td>
              </tr>
            <tr>
              <td height="2" colspan="10" background="images/dot.gif" class="smalltextgrey"></td>
              </tr>
			<?php }  ?>
          </table>

<table width="98%" border="0" align="center" cellpadding="2" cellspacing="2">
<tr>
<td><div align="right">
<input name="Submit" type="submit" class="green-button" value="Assign Refral" />
</div></td>
</tr>
</table>

When i click on Assign Refral....then it will get select box value which is with perticular user....

does any one know how to get the values of all select box with its user id...

Thnx in advance.....🙂

[bradgrafelman]

It would be a lot easier if you tied each select box to some unique data that identified each user.. in other words: the user id. I would recommend using the user id as the array index of the HTML form element, e.g.:

<select name="mod[<?php echo $row['MatriID']; ?>]">

That way, you could process the select boxes like so:

foreach($_POST['mod'] as $MatriID => $value) {
    // do something
}

Also, get rid of this code:

<input type="hidden" name="matriid" id="matriid" value="<?php echo $row['MatriID'] ?>" />

since a) it's invalid HTML markup (both 'name' and 'id' attributes must be unique), and b) isn't useful (you can only retrieve the last value from PHP).

[Ashley_Sheridan]

You've only got one select box on the page, so I'm not sure what your problem is. You can have as many select boxes in a form as you like, and only the selected values will be sent to the server from the browser.

You don't mention what your Javascript function func() does, but if you're using it to populate some sort of array which is then sent to the server, don't! Select boxes have an attribute called multiple="multiple" (this is how you set it in XHTML and causes no problems with any browsers) If this is set, all the selected values are sent to the server as an array. With PHP, your form elements need the square brackets like you've used in order for PHP to correctly receive the values.

Within PHP, the data is just captured as an array.

[palak]

bradgrafelman;10941394 wrote:

It would be a lot easier if you tied each select box to some unique data that identified each user.. in other words: the user id. I would recommend using the user id as the array index of the HTML form element, e.g.:

<select name="mod[<?php echo $row['MatriID']; ?>]">

That way, you could process the select boxes like so:

foreach($_POST['mod'] as $MatriID => $value) {
    // do something
}

Also, get rid of this code:

<input type="hidden" name="matriid" id="matriid" value="<?php echo $row['MatriID'] ?>" />

since a) it's invalid HTML markup (both 'name' and 'id' attributes must be unique), and b) isn't useful (you can only retrieve the last value from PHP).

Thanks very muchhh.........🙂

Its working and i got what i want...🙂

bt its making problem with javascript validation...i want to check if no select box selected....

here its validation code....bt its not workin nw..😕..after change name to

name="mod[<?php echo $row['MatriID']; ?>]"

n here is my javascript code...

function checkselect()
{
var no = document.form1.nomod.value;

for(i=0; i <= no ; i=i+1)
{
	if(document.form1.mod[i].value == '')
	{
		alert("Select any Moderator");
		return false;
	}
	else if(document.form1.mod[i].value != '')
	{
		self.location = 'refrals_user_submit.php?modid=' + no;
	}
}

return true;
}

i m tryin to do this validation wid php validation may b it will work......🙂

Thanks again....🙂

[palak]

Ashley Sheridan;10941649 wrote:

You've only got one select box on the page, so I'm not sure what your problem is. You can have as many select boxes in a form as you like, and only the selected values will be sent to the server from the browser.

You don't mention what your Javascript function func() does, but if you're using it to populate some sort of array which is then sent to the server, don't! Select boxes have an attribute called multiple="multiple" (this is how you set it in XHTML and causes no problems with any browsers) If this is set, all the selected values are sent to the server as an array. With PHP, your form elements need the square brackets like you've used in order for PHP to correctly receive the values.

Within PHP, the data is just captured as an array.

i just wrote that function to get the selected value of a select box..only for test..

if u want to see that function here it is,...

function func(obj)
{
var aSel=document.getElementsByName(obj.name);
for(var i=0; i<aSel.length; i++) {
if(aSel==obj) {
alert(' SELECTION: '+obj.value);
break;
}
}
}

and another function to check the if the check box is selected or not... here it is...

function checkselect()
{
var no = document.form1.nomod.value;
for(i=0; i <= no ; i=i+1)
{
if(document.form1.mod.value == '')
{
alert("Select any Moderator");
return false;
}
else if(document.form1.mod.value != '')
{
self.location = 'refrals_user_submit.php?modid=' + no;
}
}
return true;
}

hope now u got my whole code with functions.......🙂

[palak]

@ bradgrafelman

i tried to validate select boxes with javascript n php validation...

bt its nt workin wid ny one...

cn u tel me hw cn i do validation on tht ?? wid javascript or php ??

i want to validate tht if user didnt select ny select box thn it wil show msg to select atleast one select box..

Thanks.....🙂

[palak]

does any one know how to validate this all select boxes ???

pls help me out....😕

thanks...🙂

[Ashley_Sheridan]

Are you trying to validate in Javascript or PHP? Javascript is for the users benefit, PHP validation is so you don't get hurt.

[halojoy]

palak;10941984 wrote:

does any one know how to validate this all select boxes ???

pls help me out....😕

thanks...🙂

Was posted up there:

foreach($_POST['mod'] as $MatriID => $value) {
    // do something
} 

for example you can try this
for a test

foreach($_POST['mod'] as $MatriID => $value) {
    echo 'MatriID= '.$MatriID.' ----- $value= '.$value. '<br />';
} 

[palak]

halojoy;10941987 wrote:

for example you can try this
for a test

foreach($_POST['mod'] as $MatriID => $value) {
    echo 'MatriID= '.$MatriID.' ----- $value= '.$value. '<br />';
} 

i tried it ...when i select only 1 MatriID and one Moderator thn also i got all MatriID...

and as a value i got only 1 value i.e. moderator id...

i tried to validate that if none select box is selected thn it shows a msg to select atleast one select box...

i tried like this also bt still its not workin.....:mad:

include('protect.php');
include '../dbconnect.php';

$mod = $POST['mod'];
$plan = $POST['plan'];

if(isset($mod) && isset($plan))
{

foreach($_POST['mod'] as $MatriID => $value) 
{
	if(!empty($value))
	{

		$sql1 = mysql_query("insert into refral values('','$value','$MatriID','','Panding')");
		$user1 = mysql_query("update user set modid = '$value' where MatriID = '$MatriID'");
	}
}

foreach($_POST['plan'] as $MatriID => $value)
{
	if(!empty($value))
	{
		$sql2 = mysql_query("update refral set planid = '$value' where MatriID = '$MatriID'");
		$user2 = mysql_query("update user set Planid = '$value', Status = 'Panding' where MatriID = '$MatriID'");
	}
}

if($sql1 && $sql2 && $user1 && $user2)
{
	print "<script>";
	print "self.location = 'refrals_to_user.php?Action=success'";
	print "</script>";
}

}
else
{
echo "array is empty";
exit;
}

in this code it didn't show the msg "Array is empty" bcz if i didnt' select any select box thn also it send all MatriID to the $mod and $plan...

so i didnt validate this way....😕

ny idea how to validate this ???

Thanks..🙂

[palak]

Ashley Sheridan;10941985 wrote:

Are you trying to validate in Javascript or PHP? Javascript is for the users benefit, PHP validation is so you don't get hurt.

wid ny one....i didnt mean that its validate through javascript or php...

bt i give preference to php.....

do u have ny idea wid php ?? or javascript ????

if u hv thn pls help me...😕

Thanks...🙂

[palak]

ny one know how to validate it ??? 😕

pls help me out....😕

thanks.....🙂

[Ashley_Sheridan]

Just iterate through the $POST or $GET arrays which contain all your form elements once the visitor has submitted the form. From there, you can determine if any values sent are within the correct ranges, etc.

[palak]

Ashley Sheridan;10942801 wrote:

Just iterate through the $POST or $GET arrays which contain all your form elements once the visitor has submitted the form. From there, you can determine if any values sent are within the correct ranges, etc.

i done it like this...

include '../dbconnect.php';

$mod = $POST['mod'];
$plan = $POST['plan'];

print_r($mod);
print_r($plan);

if(isset($mod) && isset($plan))
{

foreach($_POST['mod'] as $MatriID => $value) 
{
	if(!empty($value))
	{
		$sql1 = mysql_query("insert into refral values('','$value','$MatriID','','Panding','')");
		print "insert into refral values('','$value','$MatriID','','Panding')".'<br>';
		$user1 = mysql_query("update user set modid = '$value' where MatriID = '$MatriID'");
		print "update user set modid = '$value' where MatriID = '$MatriID'".'<br>';
	}
}[/QUOTE]

it checks the empty value bt cnt show any msg... :queasy:

i also tried like this....

foreach($_POST['mod'] as $MatriID => $value)
{
if($value == '')
{
Error Message..
//redirect to another page to show message
}
}

but it breaks the loop when it got empty value in middle...then it will not go for another rest of values... :queasy:

how to solve this ???

[Ashley_Sheridan]

Your first example is missing a closing brace, and you're only checking to see if a value is NOT empty. If it is empty, you don't have an else clause to deal with it and send a redirect.

Also, you should note that a redirect won't work until you take out those print_r() statements, as you'll get a headers already sent error.

[palak]

Ashley Sheridan;10942803 wrote:

Your first example is missing a closing brace, and you're only checking to see if a value is NOT empty. If it is empty, you don't have an else clause to deal with it and send a redirect.

Also, you should note that a redirect won't work until you take out those print_r() statements, as you'll get a headers already sent error.

sry i mistake in code posting..

here is the code...

include '../dbconnect.php';

$mod = $POST['mod'];
$plan = $POST['plan'];

if(isset($mod) && isset($plan))
{

foreach($_POST['mod'] as $MatriID => $value) 
{
	if(!empty($value))
	{
		$sql1 = mysql_query("insert into refral values('','$value','$MatriID','','Panding','')");
		print "insert into refral values('','$value','$MatriID','','Panding')".'<br>';
		$user1 = mysql_query("update user set modid = '$value' where MatriID = '$MatriID'");
		print "update user set modid = '$value' where MatriID = '$MatriID'".'<br>';
	}
}

foreach($_POST['plan'] as $MatriID => $value)
{
	if(!empty($value))
	{
		$sql2 = mysql_query("update refral set planid = '$value' where MatriID = '$MatriID'");
		print "update refral set planid = '$value' where MatriID = '$MatriID'".'<br>';
		$user2 = mysql_query("update user set Planid = '$value', Status = 'Panding' where MatriID = '$MatriID'");
		print "update user set Planid = '$value', Status = 'Panding' where MatriID = '$MatriID'".'<br>';
	}
}

if($sql1 && $sql2 && $user1 && $user2)
{
	print "<script>";
	print "self.location = 'refrals_to_user.php?Action=success'";
	print "</script>";
}

}
else
{
echo "array is empty";
exit;
}

here i wrote the message that array is empty it didnt show tht msg..... :queasy:

[Ashley_Sheridan]

OK, there are still mismatched braces in there (you have two closing ones before that else statement) which will cause problems.

Also, if the queries are never run, you'll get an error for attempting to use variables that haven't been defined in your if statement at the bottom.

Lastly, you don't have any validation in this at all, just a check to see if a variable equates to true, which it will either always be, or you'll get an error, so the else part will never ever be run.

You need to validate your data before trying to use it in a query. Go through each $_POST variable that you plan to use and check to make sure it's something you expect. Use mysql_real_escape_string() to create variables that are safe to use in a query, or in short order you'll find yourself hacked by someone looking to have some fun.

Also, you should move the $mod= and $plan= lines to inside of the first if statement, otherwise you'll get another error if the script never receives those $_POST values.

[palak]

Ashley Sheridan;10942808 wrote:

OK, there are still mismatched braces in there (you have two closing ones before that else statement) which will cause problems.

Also, if the queries are never run, you'll get an error for attempting to use variables that haven't been defined in your if statement at the bottom.

Lastly, you don't have any validation in this at all, just a check to see if a variable equates to true, which it will either always be, or you'll get an error, so the else part will never ever be run.

You need to validate your data before trying to use it in a query. Go through each $_POST variable that you plan to use and check to make sure it's something you expect. Use mysql_real_escape_string() to create variables that are safe to use in a query, or in short order you'll find yourself hacked by someone looking to have some fun.

Also, you should move the $mod= and $plan= lines to inside of the first if statement, otherwise you'll get another error if the script never receives those $_POST values.

they 2 closing bracket is rite i checked it...the first one is for last if and the second one is for first if...

yeah i know i have to validate it before the sql query bt i dnt kno hw to validate it...

n hw can i check both $mod and $plan in same if ??

i also tried like this

foreach($_POST['mod'] as $MatriID => $value)
{
if($value == '')
{
echo 'Emptry';
}
if(!empty($value))
{
$sql1 = mysql_query("insert into refral values('','$value','$MatriID','','Panding','')");
print "insert into refral values('','$value','$MatriID','','Panding')".'<br>';
$user1 = mysql_query("update user set modid = '$value' where MatriID = '$MatriID'");
print "update user set modid = '$value' where MatriID = '$MatriID'".'<br>';
}
}

bt when it got empty value it exit from a loop........ 🙁

it will not check the rest of values of array..

i only want to exit it when all values are empty...if there is one value is not empty then it not show any msg....

hope u got me... 🙁

thanks... 🙂

[Ashley_Sheridan]

Please try to mark up PHP code with the right PHP BBCode tags, as it's hard to read like it is.

This is what you have in your code simplified:

include '../dbconnect.php';

$mod = $_POST['mod'];
$plan = $_POST['plan'];


if(isset($mod) && isset($plan))
{
	// some code here
}
else
{
	echo "array is empty";
	exit;
} 

The else part of your code will never run because you are declaring $mod and $plan outside of your if, so they always exist! Move them to the inside of the if part, and in the if, do this:

if(isset($_POST['mod']) && isset($_POST['plan']))

[palak]

Ashley Sheridan;10942812 wrote:

Please try to mark up PHP code with the right PHP BBCode tags, as it's hard to read like it is.

This is what you have in your code simplified:

include '../dbconnect.php';

$mod = $_POST['mod'];
$plan = $_POST['plan'];


if(isset($mod) && isset($plan))
{
	// some code here
}
else
{
	echo "array is empty";
	exit;
} 

The else part of your code will never run because you are declaring $mod and $plan outside of your if, so they always exist! Move them to the inside of the if part, and in the if, do this:

if(isset($_POST['mod']) && isset($_POST['plan']))

yeahhhhhhh....... its done....wt i want to do ...... 😃

thank u very much.... 🙂