transfer all values of listbox

sd1

Hi All!
i'm using this script, which populate a listbox from the mySql db, and with the up and down buttons, change the place of all items.

now, what i need to do is to submit the listbox, but i need that all of the listbox values will be submitted.

is that possible?

<?php
require ("../../../mySqlCon.inc.php");
?>
<html dir=rtl>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1255">
<title>position</title>
</head>
<body>
<?php 
if ($mode == "doReOrder") {
echo $_GET[ro_lsttest];

} else {
 ?>
<SCRIPT>

function outputList(ar, name, size) {
 var strIDs = "<SELECT SIZE=\"" + size + "\" NAME=\"ro_lst" + name + "\">"
 var sel = " SELECTED"
 for (var i=0;i<ar.length;i++) {
  strIDs += "<OPTION " + sel + " VALUE=\"" + ar[i][0] + "\">" + ar[i][1]
  sel = ""
 }
 strIDs+="</SELECT>"
 strIDs+="<INPUT NAME=\"" + name + "\" TYPE=hidden>"
 return strIDs
}

function outputButton(bDir,name,val) {
 return "<INPUT TYPE=button VALUE=\"" + val + "\" ONCLICK=\"move(this.form," + bDir + ",'" + name + "')\">"
}

function move(f,bDir,sName) {
 var el = f.elements["ro_lst" + sName]
 var idx = el.selectedIndex
 if (idx==-1) 
  alert("You must first select the item to reorder.")
 else {
  var nxidx = idx+( bDir? -1 : 1)
  if (nxidx<0) nxidx=el.length-1
  if (nxidx>=el.length) nxidx=0
  var oldVal = el[idx].value
  var oldText = el[idx].text
  el[idx].value = el[nxidx].value
  el[idx].text = el[nxidx].text
  el[nxidx].value = oldVal
  el[nxidx].text = oldText
  el.selectedIndex = nxidx
 }
}

function processForm(f) {
 for (var i=0;i<f.length;i++) { 
  var el = f[i]
  if (el.name.substring(0,6)=="ro_lst") {
   var strIDs = ""
   for (var j=0;j<f[i].options.length;j++)
     strIDs += f[i].options[j].value + ", "
   f.elements[f.elements[i].name.substring(6)].value = strIDs.substring(0,strIDs.length-2)
  }
 }
}
</SCRIPT>
<FORM METHOD=get ONSUBMIT="processForm(this)"><input type=hidden name=mode value=doReOrder>
<SCRIPT>
  var arrList = new Array()
  <?php
  $querySubCats = "SELECT * FROM tblProductsCats JOIN tblProducts on (tblProducts.id=tblProductsCats.productID) WHERE catID='$catID' ORDER BY 'position'";
$resultSubCats = mysql_query($querySubCats)or die($querySubCats);
$myI = "0";
$myI1 = "1";
while ($rowSubCats = mysql_fetch_array($resultSubCats)) {
  echo "arrList[$myI] = new Array(\"$myI1\",\"$rowSubCats[title]\")\n";

  $myI++;
  $myI1++;
  }
?>
  document.write(outputButton(true,"test","Up") + "<BR>")
  document.write(outputList(arrList,"test",10) + "<BR>")
  document.write(outputButton(false,"test","Down"))
</SCRIPT>
<BR>

<INPUT TYPE=submit VALUE="Next">
</FORM>

<?php
}
?>

</body>
</html>

Merve

I guess you could use JavaScript to select all the items in the listbox when the user clicks on submit, and then the form is submitted.

(BTW, don't ever ask the question "Is this possible?" or any other yes or no question on the forum or you most probably won't get an answer. I'm just nice 😉)

sd1

Hi.
i took your advice and now it selects all the fields and submit them.

but - how i can get the values of the fields after the submission?

<?php
require ("../../../mySqlCon.inc.php");
?>
<html dir=rtl>
<head>
<script language=javascript>

var arrOldValues;

function SelectAllList(CONTROL){
for(var i = 0;i < CONTROL.length;i++){
CONTROL.options[i].selected = true;
}
}

function DeselectAllList(CONTROL){
for(var i = 0;i < CONTROL.length;i++){
CONTROL.options[i].selected = false;
}
}


function FillListValues(CONTROL){
var arrNewValues;
var intNewPos;
var strTemp = GetSelectValues(CONTROL);
arrNewValues = strTemp.split(",");
for(var i=0;i<arrNewValues.length-1;i++){
if(arrNewValues[i]==1){
intNewPos = i;
}
}

for(var i=0;i<arrOldValues.length-1;i++){
if(arrOldValues[i]==1 && i != intNewPos){
CONTROL.options[i].selected= true;
}
else if(arrOldValues[i]==0 && i != intNewPos){
CONTROL.options[i].selected= false;
}

if(arrOldValues[intNewPos]== 1){
CONTROL.options[intNewPos].selected = false;
}
else{
CONTROL.options[intNewPos].selected = true;
}
}
}


function GetSelectValues(CONTROL){
var strTemp = "";
for(var i = 0;i < CONTROL.length;i++){
if(CONTROL.options[i].selected == true){
strTemp += "1,";
}
else{
strTemp += "0,";
}
}
return strTemp;
}

function GetCurrentListValues(CONTROL){
var strValues = "";
strValues = GetSelectValues(CONTROL);
arrOldValues = strValues.split(",")
}
</script>


<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1255">
<title>position</title>
</head>
<body>



<?php 
if ($mode == "doReOrder") {
echo $ro_lsttest[1];

} else {
 ?>
<SCRIPT>

function outputList(ar, name, size) {
 var strIDs = "<SELECT multiple SIZE=\"" + size + "\" NAME=\"ro_lst" + name + "\">"
 var sel = " SELECTED"
 for (var i=0;i<ar.length;i++) {
  strIDs += "<OPTION " + sel + " VALUE=\"" + ar[i][0] + "\">" + ar[i][1]
  sel = ""

 }
 strIDs+="</SELECT>"
 strIDs+="<INPUT NAME=\"" + name + "\" TYPE=hidden>"
 return strIDs
}

function outputButton(bDir,name,val) {
 return "<INPUT TYPE=button VALUE=\"" + val + "\" ONCLICK=\"move(this.form," + bDir + ",'" + name + "')\">"
}

function move(f,bDir,sName) {
 var el = f.elements["ro_lst" + sName]
 var idx = el.selectedIndex
 if (idx==-1) 
  alert("You must first select the item to reorder.")
 else {
  var nxidx = idx+( bDir? -1 : 1)
  if (nxidx<0) nxidx=el.length-1
  if (nxidx>=el.length) nxidx=0
  var oldVal = el[idx].value
  var oldText = el[idx].text
  el[idx].value = el[nxidx].value
  el[idx].text = el[nxidx].text
  el[nxidx].value = oldVal
  el[nxidx].text = oldText
  el.selectedIndex = nxidx
 }
}

function processForm(f) {
 for (var i=0;i<f.length;i++) { 
  var el = f[i]
  if (el.name.substring(0,6)=="ro_lst") {
   var strIDs = ""
   for (var j=0;j<f[i].options.length;j++)
     strIDs += f[i].options[j].value + ", "
   f.elements[f.elements[i].name.substring(6)].value = strIDs.substring(0,strIDs.length-2)
  }
 }
}
</SCRIPT>
<script language=javascript>
function selectAll(formObj, isInverse) 
{
   for (var i=0;i < formObj.length;i++) 
   {
      fldObj = formObj.elements[i];
      if (fldObj.type == 'select')
      { 
         if(isInverse)
            fldObj.checked = (fldObj.checked) ? false : true;
         else fldObj.checked = true; 
       }
   }
}
</script>
<FORM name=checkboxes METHOD=get ONSUBMIT="processForm(this)"><input type=hidden name=mode value=doReOrder>
<SCRIPT>
  var arrList = new Array()
  <?php
  $querySubCats = "SELECT * FROM tblProductsCats JOIN tblProducts on (tblProducts.id=tblProductsCats.productID) WHERE catID='$catID' ORDER BY 'position'";
$resultSubCats = mysql_query($querySubCats)or die($querySubCats);
$myI = "0";
$myI1 = "1";
while ($rowSubCats = mysql_fetch_array($resultSubCats)) {
  echo "arrList[$myI] = new Array(\"$myI1\",\"$rowSubCats[id]_$rowSubCats[title]\")\n";

  $myI++;
  $myI1++;
  }
?>
  document.write(outputButton(true,"test","Up") + "<BR>")
  document.write(outputList(arrList,"test",10) + "<BR>")
  document.write(outputButton(false,"test","Down"))
</SCRIPT>
<BR>
<?PHP

$querySubCats1 = "SELECT * FROM tblProductsCats JOIN tblProducts on (tblProducts.id=tblProductsCats.productID) WHERE catID='$catID' ORDER BY 'position'";
$resultSubCats1 = mysql_query($querySubCats)or die($querySubCats1);

while ($rowSubCats1 = mysql_fetch_array($resultSubCats1)) {
echo "<input type=hidden name=item[] value=$rowSubCats1[id]>";
}

?>
<INPUT TYPE=submit VALUE="Next" onClick="SelectAllList(document.forms[0].ro_lsttest)">
</FORM>

<?php
}
?>

</body>
</html>

Merve

The name of your select list, ro_lst, should be ro_lst[]

That way, you can get all the items selected as an array.