[Resolved] Select All Option

[klycette]

I'm building part of a sql query by cycling through the selected entries of a multi-select listbox, but now want to give users an option to select just one "Select All" option from the listbox as a shortcut so they don't have to select each individually if they want to search them all. This is the code I have now, which only looks at the elements they select. What would I have to do to make the shortcut work?

for ($i = 0; $i < sizeof($categories); $i++)
	{
		if ($i != sizeof($categories) - 1)
			$selected_categories .= "'$categories[$i]', ";//if it's not the last in the array, a comma is included
		else $selected_categories .= "'$categories[$i]'";//if it's the last element in the array, there's no comma
	}

[TTT]

<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript">
	function sa() {
	var tempp = "";

	for(a=0;a<document.formi.da.options.length;a++) {
		document.formi.da.options[a].selected = true;
	tempp = tempp + document.formi.da.options[a].value+",";
	}
document.formi.temp.value = tempp;	
document.formi.submit();
}
function chg() {
var tempp = document.formi.temp.value;
	for(a=0;a<document.formi.da.options.length;a++) {
		if(document.formi.da.options[a].selected == true) {

			tempp = tempp + document.formi.da.options[a].value+",";
		}		
	}
document.formi.temp.value = 	tempp;

}
function ripcomma() {
	t = document.formi.temp.value;
	if(t.length > 1) {
		document.formi.temp.value = t.substr(0,t.length-1);
	}
}
</SCRIPT>
<form name="formi" method="post" action="t.php" onsubmit="javascript:ripcomma();">
<input type="text" name="temp" value="">
<select name='da'  multiple size="4" onchange="javascript:chg();">
	<option value='x'>x</option>
	<option value='y'>y</option>
	<option value='z'>z</option>
	<option value='a'>a</option>
</select>


<input type="button" name="CHKall" value="Select all" onclick="javascript:sa();">
<input type="submit" name="res" value="resume">

</form>

<?
if(isset($temp)) {
	echo $temp;
}
?>

[klycette]

I'll work on digesting this..I'm still learning both php and javascript. What if the user has javascript disabled? I know most people don't, but that's why I wanted it to be done in php. Thanks.

[LordShryku]

Seems like you're going through a lot of trouble. With PHP, it's just a matter of checking if "select all" was chosen or not. If it was, add the options to the SQL query. If not, you don't want those options in the SQL query, so it will select all of them.

So say your form looked something like this...

<form name="blah" method="post" action="somepage.php">
 <b>Select ALL</b>: <input type="checkbox" name="select_all" value="1" />
 <br />
 <select name="options[]" multiple>
  <option value="a">A</option>
  <option value="b">B</option>
  <option value="c">C</option>
  <option value="d">D</option>
 </select>
 <br />
 <input type="submit" name="submitButton" />
</form>

You give a checkbox for the "Select All" option, then on the next page, see if it was chosen...

// build sql query
$sql = "SELECT field1, field2
          FROM table
         WHERE 1=1";

if(!isset($_POST['select_all']) || $_POST['select_all'] != 1) {
   // they didn't want all, so we need to add the field
   $sql .= " AND field IN ('".implode("','",$_POST['options'])."')";
}
// otherwise they hit "select all", and we can disregard
// the field, and don't need to add it to the query

$res = mysql_query($sql); 
// and so on

[klycette]

Jeez...never even thought of that. I was so caught up with how to include all of the categories that I forgot that it would amount to the same thing if I just excluded it from the query altogether. I do still want to have the "Select All" option in the select box instead of in a checkbox, for the sake of consistency. I know that I could check to see if the selectedIndex was 0, matching the index of the "Select All" option if it was an ordinary listbox, but does that still work when it's an array (eg categories[])?

[LordShryku]

JS is a waste of time when working with form arrays. Here's the same code I posted before, only using the "Select All" as an option instead of a checkbox

<form name="blah" method="post" action="somepage.php">
 <select name="options[]" multiple>
  <option value="ALL">Select All</option>
  <option value="a">A</option>
  <option value="b">B</option>
  <option value="c">C</option>
  <option value="d">D</option>
 </select>
 <br />
 <input type="submit" name="submitButton" />
</form>

$sql = "SELECT field1, field2
          FROM table
         WHERE 1=1";

if(isset($_POST['options']) &&  !in_array("ALL",$_POST['options'])) {
   $sql .= " AND field IN ('".implode("','",$_POST['options'])."')";
}

$res = mysql_query($sql);