Getting checkbox values

[Anon]

Hi
In my page i am having set of records.And there is a checkbox corresponding to each record.These set of records are fetched from the database and each has its own id.When the user submits i want to have the set of values checked in my next page.
I am using post method in my form.
Suppose if i check three records, in my next page i should get those three values.
In javascript i am able to get the set of values checked with their id's assigned to it.How to get these values in my next page.

My form is like this.

<form method="POST" name="chkform" action="page2.phtml" onSubmit="return func()">
<?
while(list($id,$title)=mysql_fetch_row($statemrnt))
{
?>
<tr>
<td><?echo($title)?></td>
<td><input type="checkbox" name="status" value="<?echo($id)?>"></td>
</tr>
<tr>
<td align="center"><input type="submit" value="Submit" name="submit"><input type="reset" value="Reset" name="reset"></td>
</tr>
</form>
<?
}
?>

Can anyone help me to solve this.

Thanks in advance

srini

[Anon]

If I understand your problem correctly:
When your values are returned from the database, one will indicate whether the checkbox should be checked or not. Use this value as a parameter for setting the HTML flag CHECKED in the form field.

You could make a function:

function checked($statement)
{
if ($statement) echo "&nbsp;CHECKED&nbsp;";
}

Put the function somewhere in your field code:

<input type="checkbox" name="status" value="<?echo($id)?>" <? checked($id_checked);?>>

I assume that the $id_checked variable contains the result from the database. That should render a CHECKED in your HTML if the value is set in the database.

Martin

[Anon]

Hi,
I tried your method.It is not working.I don't know how to proceed with that.
My problem is like this.Each record will have its own checkbox.After submitting the record in my javascript i am able to get the values of the checked one.Suppose if three records are checked,i am able to get all three values associated with that.In my javascript i am getting like this.

function entrycheck(formobj)
{
var checklength;
checklength=formobj.status.length;
for(var i=0;i<checklength;i++)
{
// status is the checkbox name
if(formobj.status.checked)
{
formobj.classtatus.value;
// this is the id value assigned inside the form.
}
}
}
return true;

Now i want to have all these checked id values in my next page.

I hope this will give you more idea about my problem.

Thanks

[Anon]

Now i want to have all these checked
id values in my next page.

If your problem is on the next page - a page linked to from your current page containing the JavaScript - you will have to pass the values through the URL using normal paramater passing like

next_page.html?value_1=checked&value_2=unchecked&value_3=checked

replacing 'checked' and 'unchecked' with whatever your program needs in order to check the value... or what your JavaScript returns. This will give you three variables in the next page, which you can use from PHP like I described in my first reply.

...but I'm not sure I fully understand your problem.

Martin

[Anon]

If I understand this correctly, the problem you are running into is that you can't get the proper values of the assorted checkboxes. This is likely caused by the fact that even though you have a bunch of different checkboxes, they all have the same name. So if you append a numeric value to the end of the checkbox name, then you should get the proper results.

<input type="checkbox" name="status<?print $someincrementer;?>" value="<?echo($id)?>">

hope this helps
Darren

[Anon]

Also, you can use arrays, like so:

for ($i=0;$i<$max;$i++){
echo "Checkbox #$i";
echo "&lt;input type=checkbox name=check[$i]>";
}

Then, just check to see which ones got set. If the checkbox wasn't set, then it won't be set, so you'll have holes in your array.
I.e. if checkboxes for 1,3, 5 and 6 were set, then only $check[1], 3, 5, and 6 will have values, and you can use isset($check[$i]) to see if they are set or not.

[rtaylor]

Subject: PHP processing HTML ARRAYs of CHECKBOXes or RADIO buttons.

I use PHP3 to generate various FORMs containing TABLEs.
The tables may display ARRAYs of TEXT, CHECKBOXes, or RADIO buttons.

The user may type some text, or click some of the checkboxes or
radio buttons as the case may be. The user then SUBMITs the form.
PHP then processes the arrays.

If it were an array of <INPUT TYPE="TEXT" ...
then all elements of the array are present and
are in the index locations that you 'expect'.

However, if it were an array
of <INPUT TYPE="CHECKBOX" ...
or <INPUT TYPE="RADIO" ...
then all elements of the array are not necessarily present;
those that are present 'percolate' to the 'top' of the array.
Thus input values are NOT in the index locations you may 'expect'.

For instance, the following generates a 3 line form
with a checkbox on each line --

printf('<FORM ACTION="process.php3" ...');
echo('<TABLE BORDER=1>');
for ($ix=0 ; $ix<3 ; $ix++)
  printf('<TR><TD><INPUT TYPE="CHECKBOX" NAME="chBox[]" VALUE=%d>Check box</TD></TR>', $ix);
echo('</TABLE>'); 
echo('<INPUT TYPE=submit VALUE="Submit">');
echo('</FORM>');

When the form is submitted, process.php3 will see an array named $chBox.
This array will have 0 to 3 elements depending on how many boxes were checked.

If the user checked $chBox[2] only, then the array will have just 1 element.
It will NOT be in $chBox[2] as you might have expected.
This element will be in position $chBox[0].

The same is true for arrays of RADIO BUTTONS. They percolate to the top.

If "upper" values are not "checked", then "lower" values "percolate" to the top.
At least this is true for Netscape 4.7, Netscape 6.0, and Explorer 4.0 under Window 98.

To process these 'percolated' arrays, I 'expand' the elements back to their
'expected' index locations with the following code --

function maArrayExpand($aIn, $count) {
// the output array is the input array expanded over 'count' elements
for ( $ix=0 ; $ix<$count ; $ix++ ) // create output array as big as instructed
$aOut[$ix]= -1; // initialize output array to -1
$count= count($aIn); // count actual input array
for ( $ix=0 ; $ix<$count ; $ix++ ) // loop through actual input array
$aOut[$aIn[$ix]]= $aIn[$ix]; // put input values in 'input value' slot of output
return($aOut);
}

The input value $count is the desired number of elements in the output array.
It can be ascertained several ways, as follows.

1) In my programs there is another array that accompanies checkboxes.
It is the SQL key of the record that the checkbox applies to.

So I can
$count= count($sqlKey);

2) I suppose you could do a
$count= max( count($inputArray1), count($inputArray2), ...);

3) You could also pass the generated table size in the query string.

Notice that the elements in the checkbox table have a VALUE=%d
that starts at 0 and increments by 1 for each generated checkbox.
This is used to slot the elements that are actually present into
the array positions that they were 'intended for'.

Thus, after using 'maArrayExpand' on all CHECKBOX or RADIO input arrays,
I know that the arrays have the same 'expected' number of elements.

The index locations of the CHECKBOXes in the arrays now match
the index locations of the SQL keys in the accompanying 'data base' array.

Thus it is easy to loop through the input arrays and update the data base.

Robert

[Anon]

i also do have the same problem as srini , pls help

[rtaylor]

RP,

Here is the page I use to display a form of checkboxes. (case 800)
It also processes the input from the form. (case 810)

Many functions or subroutines are not include; but the essential
routine (maArrayExpand) is included.

Robert
............

<?
require ("com.php3");
require ("common.php3");
require ("common-app.php3");

maStart($seId);

$kv= maArrayRead();
$akvPeSt= unserialize($kv['kvPeSt']);

$akvTe= unserialize($kv['kvTe']);
if ($akvTe['kvTeKv'] == 'y') maEchoArray($kv, 'admin');
if ($akvTe['kvTeVa'] == 'y') maEchoVARS('admin');

function maAdminInstr()
{ maEchoGreen('To add or delete privileges toggle the "checkmarks".</B>');
}

function maAdminForm() {
global $maQuery,$erErNo,$erEr,$maQsNa, $seAr, $coGreen, $sqLi,$sqNo,$sqSc;

$sqNo = 10; // display 10 at a time
$maQuery= "SELECT * FROM user LIMIT $sqLi, $sqNo";
$result = @($maQuery);
if (maSqErTest())
return;
$numRows = mysql_num_rows($result);
if ($numRows == 0)
{ $erErNo= mysql_error(); $erEr= 'Error 193 '.mysql_error(); maSqErRecord('q');
die("Sorry. Please try later. Error 193 will be fixed.");
}
else
{ printf('%s%sViewing %d to %d of %d users.</FONT>',
"\n",
$coGreen,
$sqLi+1,
($sqLi+$sqNo<$sqSc)?$sqLi+$sqNo:$sqSc,
$sqSc );
// DISPLAY ROWS FROM DATA BASE, ALTERNATE COLOURS ON EACH ROW
$xqs= "&maCo=810&sqLi=$sqLi&sqNo=$sqNo&sqSc=$sqSc"?>
<form action="admin<?echo $maQsNa.$xqs?>" method="post">
<input type="hidden" name="fseFoSe" value="<?echo $seAr['seFoSe']?>">
<table border="1">
<?
$ixEnd= $sqSc - $sqLi; // how many are left to see
$ixEnd= min($ixEnd, $sqNo); // how many OR maximun
for ($ix=0; $ix < $ixEnd; $ix++) // loop thru them
{ $rUser= mysql_fetch_array($result); // get a user
$xusId= $rUser['usId'];
$xkv= maArrayRead($xusId); // read kv table for this user
$xakvPeSt= unserialize($xkv['kvPeSt']); // get PErmissions for STolen
$xColour= ($ix%2) ?"#ffffdd":"#dddddd";
?>
<tr bgcolor="<?echo $xColour?>">
<td><?echo htmlspecialchars($rUser['usPs'])?>
<input type="hidden" name="fusId[]" value="<?echo $xusId?>">
<td><input type="checkbox" name="fchSu[<?echo $ix?>]" value="<?echo $ix?>" <?echo ($xakvPeSt['kvPeStSubmit']=='y')?'checked':''?>>Submit
<td><input type="checkbox" name="fchCh[<?echo $ix?>]" value="<?echo $ix?>" <?echo ($xakvPeSt['kvPeStChange']=='y')?'checked':''?>>Change
<td><input type="checkbox" name="fchDe[<?echo $ix?>]" value="<?echo $ix?>" <?echo ($xakvPeSt['kvPeStDelete']=='y')?"checked":""?>>Delete
<td><input type="checkbox" name="fchAd[<?echo $ix?>]" value="<?echo $ix?>" <?echo ($xakvPeSt['kvPeStAdmin'] =='y')?"checked":""?>>Admin
</tr>
<?
}
?>
</table>
<br /><input type="submit" value="Save these and show more.">
</form>
<?
} // end printf...Viewing...
} // end maAdminForm

function maArrayExpand($aIn, $count)
{ // output array is input array spread over 'count' entries; brouser percolates values to top.
for ( $ix=0 ; $ix<$count ; $ix++ )
$aOut[$ix]= -1; // init array to -1
$count= count($aIn);
for ( $ix=0 ; $ix<$count ; $ix++ ) // loop thru actual input data
$aOut[$aIn[$ix]]= $aIn[$ix]; // put input values in 'input value' slot
return($aOut);
}

function maAdminSave()
{ global $maQuery,$erErNo,$erEr, $fchSu, $fchCh, $fchDe, $fchAd, $fusId;

// SPREAD ARRAYS INTO PROPER ARRAY SLOTS, USE ARRAY VALUES
$ixRows= count($fusId);
$fchSu= maArrayExpand($fchSu, $ixRows);
$fchCh= maArrayExpand($fchCh, $ixRows);
$fchDe= maArrayExpand($fchDe, $ixRows);
$fchAd= maArrayExpand($fchAd, $ixRows);

// LOOP THRU ARRAYS OF CHECKBOXES, UPDATE USERS
for ($ix=0 ; $ix<$ixRows ; $ix++)
{ $xkv= maArrayRead($fusId[$ix]); // get a user
// echo 'kvPeST'.$xkv['kvPeSt'];
$xakvPeSt= unserialize($xkv['kvPeSt']);
$xakvPeSt['kvPeStSubmit']= ($fchSu[$ix]==$ix) ? 'y':'n';
$xakvPeSt['kvPeStChange']= ($fchCh[$ix]==$ix) ? 'y':'n';
$xakvPeSt['kvPeStDelete']= ($fchDe[$ix]==$ix) ? 'y':'n';
$xakvPeSt['kvPeStAdmin'] = ($fchAd[$ix]==$ix) ? 'y':'n';

$ser= serialize($xakvPeSt);
$kvNew= array('kvPeSt' => $ser);
$xkv= maArrayWrite($kvNew, $xkv, $fusId[$ix]);	// write that user

} // end for
} // end maSaveChange

			// MAIN LINE

switch($maCo) {
case 800: // first time, put up instructions
// only show search instructions first few times
$usAdCo= $kv['usAdCo'];
if ($usAdCo < 5)
{ $usAdCo++;
$kvNew= array('usAdCo'=> $usAdCo );
$kv= maArrayWrite($kvNew, $kv); // save new ADmin COunt
unset($kvNew);
maAdminInstr();
}
$sqLi= 0;
$sqSc = maCount('user');
maAdminForm(); // display some users and permissions (sqNo)
break; // end 800

case 810:
if ( ! (isset($fseFoSe) && $fseFoSe==$seAr['seFoSe'])) // if form sequence missing or wrong
maDuplicateForm(197);
else
maAdminSave(); // save prior users' permissions
seFoSe_bump();
$sqLi+= $sqNo;
if ($sqLi >= $sqSc)
$sqLi= 0;
maAdminForm(); // display some users and permissions (sqNo)
break; // end 810

default: // error
$erErNo= 190; $erEr= "maCo:$maCo out of range."; maSqErRecord('q');
return;

} // end switch(maCo)
?>
</body>

[Anon]

Does anyone know of any good examples of multi checkbox delete php code anywhere? I'd love to see a whole page worth of code to see how it all fits together. I've looked in the Code Library on here but couldn't see anything

[rtaylor]

john,

I am not sure what you meant by "multi checkbox delete php code";
however, here is a page that I call to "add, change, delete" privileges.

Hope it helps,

Robert

---

<?
// Copyright Robert Taylor. Created at Mind Adventures. 2000, 2001
require ("../../hh/st2/com.php4");
require ("../../hh/st2/common.php4");
require ("../../hh/st2/common-app.php4");

maStart($seId);

// for testing
$akvTe= unserialize($kv['kvTe']);
if ($akvTe['kvTeKv'] == 'y') maEchoArray($kv, 'admin');
if ($akvTe['kvTeVa'] == 'y') maEchoVARS();

switch($maCo)
{
  case 'adminFirst':		// first time
  $sqLi= 0;
  $sqSc = maCount('user', " WHERE uslo!='read a lot'");
  maAdminForm();		// display some users and permissions (sqNo)
  break;


  case 'adminLoop':		// second and subsequent
  if ( ! (isset($fseFoSe) && $fseFoSe==$seAr['seFoSe']))	// if form sequence missing or wrong
    maDuplicateForm(197);
  else
    maAdminSave();		// save prior users' permissions
  seFoSe_bump();
  $sqLi+= $sqNo;
  if ($sqLi >= $sqSc)
    $sqLi= 0;
  maAdminForm();		// display some users and permissions (sqNo)
  break;


  default:	// error
  $erErNo= 190; $erEr= "maCo:$maCo out of range."; maSqErRecord('q');
  return;
}

maFooter();



function maAdminForm() {
  global $maQuery,$erErNo,$erEr,$maQsNa, $seAr, $sqLi,$sqNo,$sqSc;

  echo "\n",'<p id="bInstrC">To add or delete privileges toggle the "checkmarks".</p>',
       "\n",'<p id="aWarningC">People with "GRANT" privileges can give any or all privileges to others.</p>';
  $sqNo = 5;		// how many to display each time
//$maQuery= "SELECT * FROM user 			 ORDER BY usId LIMIT $sqLi, $sqNo";
  $maQuery= "SELECT * FROM user WHERE uslo!='read a lot' ORDER BY usId LIMIT $sqLi, $sqNo";
  $result = @mysql_query($maQuery);
  if (maSqErTest())
    return;
  $numRows = mysql_num_rows($result);
  if ($numRows == 0)
  { $erErNo= mysql_error(); $erEr= 'Error 193 '.mysql_error(); maSqErRecord('q');
    maDie("Sorry. Please try later. Error 193 will be fixed."); 
  }
  else
  { echo "\n", '<p id="aSuccessC">Viewing ',$sqLi+1,' to ',($sqLi+$sqNo<$sqSc)?$sqLi+$sqNo:$sqSc,
      ' of ',$sqSc,' users.</p>';
    // DISPLAY ROWS FROM DATA BASE, ALTERNATE COLOURS ON EACH ROW
    ?>

<form action="admin<?echo $maQsNa.$xqs?>" method="post">

<input type="hidden" name="fseFoSe" value="<?echo $seAr['seFoSe']?>">
<input type="hidden" name="maCo" value="adminLoop">
<input type="hidden" name="sqLi" value="<?=$sqLi?>">
<input type="hidden" name="sqNo" value="<?=$sqNo?>">
<input type="hidden" name="sqSc" value="<?=$sqSc?>">

<table align="center" border="1">
<?
$ixEnd= $sqSc - $sqLi;			// how many are left to see
$ixEnd= min($ixEnd, $sqNo);			// how many OR maximun
for ($ix=0; $ix < $ixEnd; $ix++)		// loop thru them
{ $rUser= mysql_fetch_array($result);	//   get a user
  $xusId= $rUser['usId'];
  $xkv= maArrayRead('xus'.$xusId);		//   read kv table for this user
  $xakvPeAp= unserialize($xkv['kvPeAp']);	//   get PErmissions for Application
  echo "\n", '<tr id="fOutDataVer',$ix%2,'">',
       "\n", '  <td id="fOutHeadVer',$ix%2,'">', htmlspecialchars($rUser['usPs']), '</td>';
  ?>

  <input type="hidden" name="fusId[]" value="<?echo $xusId?>">
  <td><input type="checkbox" name="fchAd[]" value="<?echo $ix?>" <?echo ($xakvPeAp['kvPeApGrant'] =='y')?"checked":""?>>Grant</td>
  <td><input type="checkbox" name="fchRe[]" value="<?echo $ix?>" <?echo ($xakvPeAp['kvPeApRegistrar'] =='y')?"checked":""?>>Registrar</td>
  <td><input type="checkbox" name="fchSu[]" value="<?echo $ix?>" <?echo ($xakvPeAp['kvPeApSubmit']=='y')?'checked':''?>>Submit</td>
  <td><input type="checkbox" name="fchCh[]" value="<?echo $ix?>" <?echo ($xakvPeAp['kvPeApChange']=='y')?'checked':''?>>Change</td>
  <td><input type="checkbox" name="fchDe[]" value="<?echo $ix?>" <?echo ($xakvPeAp['kvPeApDelete']=='y')?"checked":""?>>Delete</td>
  <td><input type="checkbox" name="fchEm[]" value="<?echo $ix?>" <?echo ($xakvPeAp['kvPeApBadEm'] =='y')?"checked":""?>>Bad Email</td>
</tr>
      <?
    }
    ?>

</table>
<br /><span id="bClickActYesC"><input type="submit" value="Save these and show more."></span>
</form>
<?
  }
} // end maAdminForm



function maArrayExpand($aIn, $count)
{ // output array is input array spread over 'count' entries; brouser percolates values to top.
  for ( $ix=0 ; $ix<$count ; $ix++ ):
    $aOut[$ix]= -1;			// init array to -1
  endfor;
  $count= count($aIn);
  for ( $ix=0 ; $ix<$count ; $ix++ ):	// loop thru actual input data
    $ix2= (int) $aIn[$ix];
    $aOut[$ix2]= $ix2;			//   put input values in 'input value' slot
  endfor;
  return($aOut);
}



function maAdminSave()
{ global $maQuery,$erErNo,$erEr, $fchAd, $fchRe, $fchSu, $fchCh, $fchDe, $fchEm, $fusId;

  // SPREAD ARRAYS INTO PROPER ARRAY SLOTS, USE ARRAY VALUES
  $ixRows= count($fusId);
  $fchAd= maArrayExpand($fchAd, $ixRows);
  $fchRe= maArrayExpand($fchRe, $ixRows);
  $fchSu= maArrayExpand($fchSu, $ixRows);
  $fchCh= maArrayExpand($fchCh, $ixRows);
  $fchDe= maArrayExpand($fchDe, $ixRows);
  $fchEm= maArrayExpand($fchEm, $ixRows);

  // LOOP THRU ARRAYS OF CHECKBOXES, UPDATE USERS
  for ($ix=0 ; $ix<$ixRows ; $ix++)
  { $xkv= maArrayRead('xus'.$fusId[$ix]);			// get a user
    $xakvPeAp= unserialize($xkv['kvPeAp']);

$xakvPeAp['kvPeApGrant']     = ($fchAd[$ix]==$ix) ? 'y':'n';
$xakvPeAp['kvPeApRegistrar'] = ($fchRe[$ix]==$ix) ? 'y':'n';
$xakvPeAp['kvPeApSubmit']    = ($fchSu[$ix]==$ix) ? 'y':'n';
$xakvPeAp['kvPeApChange']    = ($fchCh[$ix]==$ix) ? 'y':'n';
$xakvPeAp['kvPeApDelete']    = ($fchDe[$ix]==$ix) ? 'y':'n';
$xakvPeAp['kvPeApBadEm']     = ($fchEm[$ix]==$ix) ? 'y':'n';

$ser= serialize($xakvPeAp);
$kvNew= array('kvPeAp' => $ser);
$xkv= maArrayWrite($kvNew, $xkv, $fusId[$ix]);	// write that user
  }
} // end maAdminSave

?>

[Anon]

hi,
my form looks like this.
<form method="post" action="results.php">
<input type="checkbox" name="author" value="1"> Author<br>
<input type="checkbox" name="title" value="1"> Title<br>
<input type="checkbox" name="isbn" value="1"> ISBN<br>
<input type="text" name="search" size="25">
<input type="submit" value="Go">
</form>
This is my search form. I want to make it so people can select any or all of the checkboxes, but no more then 3. Each checkbox is referring to a field in the Database that has a value of 1. They are refering to the same database but different tables. Also when they check on the boxes they have to type what they want to search for on the textbox.

Can you please give me the sourse to process this. I will greatly appreciate it.
Thanking u in advacne.🙂

Pam

[rtaylor]

Pam,
Since there is only one " <input type="text" name="search" size="25"> "
I assume the user should enter an author OR title OR isbn in the text box,
i.e.; they do not enter 2 or 3 search arguments.

Also they select a checkbox to signify 'what they typed'.

If so, it would be better to use a 'radio' rather that a 'checkbox'.
For instance:

<input type="radio" name="choice" value="author"> Author<br> 
<input type="radio" name="choice" value="title"> Title<br> 
<input type="radio" name="choice" value="isbn"> ISBN<br> 

---------------
if ($search == '')
{ send an error message;
   resend form;
}
if ($choice == '')
{ send an error message;
   resend form;
}
switch($choice)
{ case 'author': $sql="select * from authorTable where author='$search'";
   case 'title':    $sql="select * from titleTable where title='$search'";
   case 'isbn':    $sql="select * from isbnTable where isbn='$search'";
}
$result= mysql_query ($sql);

This makes assumptions about your table names and key field names.

You may want to get rid of the checkbox / radio section and
just give them 3 text boxes - 1 for author, 1 for title, 1 for isbn.

Is isbn unique for all books ?
If so, if one is entered, perhaps just search on it.

If author / title is not unique (at least for fiction books)

I guess your SELECT could return multiple records.

Since I have a little site for searching 'book ratings',
I look forward to your answer.

Robert

[Anon]

Ok,

when you read a var ($var) out of your DB, how do you, on form, set the checkbox to CHECKED if the value in $var is 'yes' & not checked if it is 'no'.

Seems like no one can answer this...

[billp]

Sure you want a checkbox and not a radio?

Like this:

Say your form is
<input type="checkbox" name="equip_ohp" value="yes">

You want the form to be checked if your DB call returns a "yes", meaning this box should be checked, right?

if($equip_ohp == "yes")
{
$checked_ohp = " checked";
}
else
{
$checked_ohp = "";
}

Then in your code, it's this:
<input type="checkbox" name="equip_ohp" value="yes" $checked_ohp>

[Anon]

troublemaker,
Hope this helps,
Robert

<?php
// Copyright Robert Taylor. Created at Mind Adventures. 2000, 2001, 2002
require ("../../hh/bw0/com.php4");
require ("../../hh/bw0/common.php4");
require ("../../hh/bw0/common-app.php4");


maStart($seSt);			// start my session
maHeader();			// display header

if ($a['akv']['akvTe']['kvTeKv'] == 'y') maEchoArray($a['akv'], 'admin');
if ($a['akv']['akvTe']['kvTeVa'] == 'y') maEchoVARS();

$sqNoAd = 5;			// how many to display each time, fixed number for now
$sqSc = maCount('user');	// how many in user database
$sqLiAd= $a['akv']['sqLiAd'];	// what 'line' are we at in database

switch($maCo)
{
  case 'adminFirst':		// first time
  $sqLiAd= 0;			// start at begining
  maAdminForm();		// display some users and permissions
  break;


  case 'adminLoop':		// second and subsequent
  maAdminSave();		// save prior users' permissions
  $sqLiAd+= $sqNoAd;
  if ($sqLiAd >= $sqSc)
    $sqLiAd= 0;
  maAdminForm();		// display next users and permissions
  break;


  default:			// error
  maRecordDie(1, "maCo:$maCo out of range.");
}
$a['akv']['sqLiAd']= $sqLiAd;	// save current 'line'
maFooter();



function maAdminForm()
{ global $a, $maQuery, $sqLiAd, $sqNoAd, $sqSc, $maPhp;
  ?>

  <p class="C"><span class="bInstr">To add or delete privileges toggle the "checkmarks".</span></p>
  <p class="C"><span class="aWarning">People with "GRANT" privileges can give any or all privileges to others.</span></p>
  <?
  $maQuery= "SELECT * FROM user ORDER BY usId LIMIT $sqLiAd, $sqNoAd";
//maEchoRed("admin, maQuery:$maQuery");
  $result = mamysql_query($maQuery, 1, 'maAdminForm');
  $numRows = mysql_num_rows($result);
  if ($numRows == 0)
  { maRecordDie(2, 'maAdminForm');
  }
  else
  { ?>

<p class="C"><span class="aSuccess">Viewing <?=$sqLiAd+1?> to <?=($sqLiAd+$sqNoAd<$sqSc)?$sqLiAd+$sqNoAd:$sqSc?> of <?=$sqSc?> users.</span></p>
<form action="admin<?=$maPhp?>" method="post">
  <input type="hidden" name="formName" value="formAdmin">
  <input type="hidden" name="seSt" value="<?=$a['seSt']?>">
  <input type="hidden" name="maCo" value="adminLoop">

  <table align="center" border="1">
<?
$ixEnd= $sqSc - $sqLiAd;		// how many are left to see
$ixEnd= min($ixEnd, $sqNoAd);		// how many OR maximun
for ($ix=0; $ix < $ixEnd; $ix++)	// loop thru them
{ $rUser= mysql_fetch_array($result);	//   get a user
  $xusId= $rUser['usId'];
  $xkv= maArrayRead($xusId);		//   read kv array for this user
      ?>

  <tr class="fOutDataVer<?=$ix%2?>">
    <td class="fOutHeadVer<?=$ix%2?>"><?=htmlspecialchars($rUser['usPs'])?></td>
    <td><input type="hidden"   name="fusId[]" value="<?=$xusId?>"></td>
    <td><input type="checkbox" name="fchAd[]" value="<?=$ix?>" <?=($xkv['akvPeAp']['kvPeApAdmin'] =='y')?"checked":""?>>Admin</td>
    <td><input type="checkbox" name="fchRe[]" value="<?=$ix?>" <?=($xkv['akvPeAp']['kvPeApRegistrar'] =='y')?"checked":""?>>Registrar</td>
    <td><input type="checkbox" name="fchSu[]" value="<?=$ix?>" <?=($xkv['akvPeAp']['kvPeApSubmit']=='y')?'checked':''?>>Submit</td>
    <td><input type="checkbox" name="fchCh[]" value="<?=$ix?>" <?=($xkv['akvPeAp']['kvPeApChange']=='y')?'checked':''?>>Change</td>
    <td><input type="checkbox" name="fchDe[]" value="<?=$ix?>" <?=($xkv['akvPeAp']['kvPeApDelete']=='y')?"checked":""?>>Delete</td>
    <td><input type="checkbox" name="fchEm[]" value="<?=$ix?>" <?=($xkv['akvPeAp']['kvPeApBadEm'] =='y')?"checked":""?>>Bad Email</td>
      </tr>
  <?
}
?>

  </table>
  <table align="center">
    <tr><td><input type="submit" value="Save these and show more.">
    </td></tr>
  </table
</form>
   <?
  }
} // end maAdminForm



function maArrayExpand($aIn, $count)
{ // output array is input array spread over 'count' entries. Browser percolates values to top.
  for ( $ix=0 ; $ix<$count ; $ix++ )
  { $aOut[$ix]= -1;			// init array to -1
  }
  $count= count($aIn);
  for ( $ix=0 ; $ix<$count ; $ix++ )	// loop thru actual input data
  { $ix2= (int) $aIn[$ix];
    $aOut[$ix2]= $ix2;			//   put input values in 'input value' slot
  }
  return($aOut);
}



function maAdminSave()
{ global $fchAd, $fchRe, $fchSu, $fchCh, $fchDe, $fchEm, $fusId,
         $thisKv, $kvPeAp;
  // SPREAD ARRAYS INTO PROPER ARRAY SLOTS, USE ARRAY VALUES
  $ixRows= count($fusId);
  $fchAd= maArrayExpand($fchAd, $ixRows);
  $fchRe= maArrayExpand($fchRe, $ixRows);
  $fchSu= maArrayExpand($fchSu, $ixRows);
  $fchCh= maArrayExpand($fchCh, $ixRows);
  $fchDe= maArrayExpand($fchDe, $ixRows);
  $fchEm= maArrayExpand($fchEm, $ixRows);
  // LOOP THRU ARRAYS OF CHECKBOXES, UPDATE USERS
  for ($ix=0 ; $ix<$ixRows ; $ix++)
  { $xkv= maArrayRead($fusId[$ix]);	// get a user's kv
    $xkv['akvPeAp']['kvPeApAdmin']     = ($fchAd[$ix]==$ix) ? 'y':'n';
    $xkv['akvPeAp']['kvPeApRegistrar'] = ($fchRe[$ix]==$ix) ? 'y':'n';
    $xkv['akvPeAp']['kvPeApSubmit']    = ($fchSu[$ix]==$ix) ? 'y':'n';
    $xkv['akvPeAp']['kvPeApChange']    = ($fchCh[$ix]==$ix) ? 'y':'n';
    $xkv['akvPeAp']['kvPeApDelete']    = ($fchDe[$ix]==$ix) ? 'y':'n';
    $xkv['akvPeAp']['kvPeApBadEm']     = ($fchEm[$ix]==$ix) ? 'y':'n';
    unset($thisKv);
    maArraySave($xkv, $fusId[$ix]);	// Must save that user's kv array now.
  }
}

?>