miltiple checkboxes

[Anon]

Second attempt for this:

I have generated an array of accounts waiting to be authorised from the database which gives the ID and other details of the record.

what i want to be able to do is have a check box for each record and each record that is ticked gets passed through to be updated.

Firstly I\'m having difficulties with the unique numbering of each checkbox.

I also cannot work out how to run the sql for each of the records that was ticked.

anyone PLEASE help???

[Anon]

Firstly I\'m having difficulties with the unique numbering of each
checkbox.

what sort of difficulties?

how about something like

for ($i=0;$i<count($accounts);$i++) {
echo "<input type=checkbox name=choice[".$i."] value=".$accounts[$i]." >";
}

I also cannot work out how to run the sql for each of the records that was
ticked.

well, you're getting an array of some kind from the form, yes?

while (list($key, $val)=each($choice)) {
mysql_query("do something where bob= ".$choice);
}

[Anon]

Rad,

Basically the count just returns "0" for each record.

the $auth i am using is returning a number as the "there are currently..." does return the correct number.

Im very new to PHP so the code below might not make sence, but any help in solving it would be great.

$sql = "select * from users where authorised=0";
$result = mysql_query($sql);
$numrows = mysql_num_rows($result);
$auths = $numrows;

              if ($numrows > 0) {
                  echo "<h3>Authorisation List</H3><P>\n";
                  echo " There are currently $auths new accounts needing authorising";
                  echo "<FORM method=\"post\" action=\"$PHP_SELF?command=runauth\"> ";                 

                  echo "<TABLE width=\"100%\" border=\"0\">";
                  echo "<TR>\n";
                  echo "<TH width=10>Authorise</TH>\n";
                  echo "<TH>Company Name</TH>\n";
                  echo "<TH>Contact Name</TH>\n";
                  echo "<TH>Telephone</TH>\n";
                  echo "<TH>City</TH>\n";
                  echo "<TH>Options</TH>\n";
                  echo "</TR>\n";



                while ($auth =mysql_fetch_array($result)) {

                    $clientsql = "select * from landlords where ID='" . $auth["ID"] . "'";
                    $cresult = mysql_query($clientsql);




                     for ($i=0;$i<count($auths);$i++) {

                    while ($client = mysql_fetch_array($cresult))  {


                    ECHO "<input type=\"hidden\" name=\"ID".$i."\" value=\"" . $auth["ID"] . "\">\n";
                    echo "<TR>";
                    echo "<TD><input type=\"checkbox\" name=\"authorised".$i."\" value=\"1\" class=\"dsinput\"></TD>\n";
                    echo "<TD>\n";
                    echo "" . $client["company_name"] . "</TD>\n";
                    echo "<TD>" . $client["contact_name"] . "</TD>\n";
                    echo "<TD>" . $client["contact_tel"] . "</TD>\n";
                    echo "<TD>" . $client["city"] . "</TD>\n";
                    echo "<TD align=middle><a href=\"$PHP_SELF?command=modifyclient&ID=" .$auth["ID"] . "\">MODIFY</a>\n | <a OnClick=\"if (confirm('Are you sure you wish to delete this record?') != true) return false;\" href=\"$PHP_SELF?command=removeclient&ID=" .$auth["ID"] . "\">REMOVE</A></TD>\n";
                     }
                    }
                }

                echo "<TR><TD colspan=6>\n<INPUT type=\"submit\" value=\"Authorise\" class=\"button\" style=\"background: #003399; width: 100;\" onMouseOver=\"this.style.background='#FF9900'\" onMouseOut=\"this.style.background='#003399'\"></TD>\n";
                echo "<TABLE>\n";
              }else{

              echo "nothing to authorise";
              }
                break;

   case "runauth":




                $sql = "update users set authorised='" . $authorised[$x] . "' , date_added='" . date("Ymd",time()) . "' where ID= '" . $ID[$x] . "'";
                $result = mysql_query($sql);
                echo $sql;

#echo "<P>";


echo "<BR>The selected users have now been authorised</B>!<P>";

echo "<a href=\"Javascript:history.go(-1);\">Back to list</a>";


break;

[Anon]

for readability, my comments are prefaced with '####'

$sql = "select * from users where authorised=0";
$result = mysql_query($sql);
$numrows = mysql_num_rows($result);

what's this line for? why not $auths = mysql_num_rows($result); ?

$auths = $numrows;

if ($numrows > 0) {
echo "<h3>Authorisation List</H3><P>\n";
echo " There are currently $auths new accounts needing authorising";
echo "<FORM method=\"post\" action=\"$PHP_SELF?command=runauth\"> ";

echo "<TABLE width=\"100%\" border=\"0\">";
echo "<TR>\n";
echo "<TH width=10>Authorise</TH>\n";
echo "<TH>Company Name</TH>\n";
echo "<TH>Contact Name</TH>\n";
echo "<TH>Telephone</TH>\n";
echo "<TH>City</TH>\n";
echo "<TH>Options</TH>\n";
echo "</TR>\n";

while ($auth =mysql_fetch_array($result)) {
$clientsql = "select * from landlords where ID='" . $auth["ID"] . "'";
$cresult = mysql_query($clientsql);

for ($i=0;$i<count($auths);$i++) {

ah-ha! count() is used for the elements of an array.

you just need $i<$auths

while ($client = mysql_fetch_array($cresult)) {

ECHO "<input type=\"hidden\" name=\"ID".$i."\" value=\"" . $auth["ID"]
. "\">\n";
echo "<TR>";
echo "<TD><input type=\"checkbox\" name=\"authorised".$i."\"
value=\"1\" class=\"dsinput\"></TD>\n";
echo "<TD>\n";
echo "" . $client["company_name"] . "</TD>\n";
echo "<TD>" . $client["contact_name"] . "</TD>\n";
echo "<TD>" . $client["contact_tel"] . "</TD>\n";
echo "<TD>" . $client["city"] . "</TD>\n";
echo "<TD align=middle><a href=\"$PHP_SELF?command=modifyclient&ID="
.$auth["ID"] . "\">MODIFY</a>\n | <a OnClick=\"if (confirm('Are you
sure you wish to delete this record?') != true) return false;\"
href=\"$PHP_SELF?command=removeclient&ID=" .$auth["ID"] .
"\">REMOVE</A></TD>\n";
}
}
}

echo "<TR><TD colspan=6>\n<INPUT type=\"submit\" value=\"Authorise\"
class=\"button\" style=\"background: #003399; width: 100;\"
onMouseOver=\"this.style.background='#FF9900'\"
onMouseOut=\"this.style.background='#003399'\"></TD>\n";
echo "<TABLE>\n";
}else{

echo "nothing to authorise";
}
break;

case "runauth":

$sql = "update users set authorised='" . $authorised[$x] . "' ,

assuming this $authorised[$x] is the result of the form above, won't you

instead be getting $authorised1, $authorised2 etc?

date_added='" . date("Ymd",time()) . "' where ID= '" . $ID[$x] . "'";
$result = mysql_query($sql);
echo $sql;
#echo "<P>";

echo "<BR>The selected users have now been authorised!<P>";
echo "<a href=\"Javascript:history.go(-1);\">Back to list</a>";

break;
....

[Anon]

what's this line for? why not $auths = mysql_num_rows($result); ?

$auths = $numrows;

OK altered this!

for ($i=0;$i<count($auths);$i++) {

ah-ha! count() is used for....

now altered to
for ($i=0;$i<$auths;$i++) {

but still all returning with
<input type="checkbox" name="authorised0"
for each entry

[Anon]

that's extremely odd.

<pause>

what's that for loop actually doing? you're already cycling through the auths with the

while ($auth =mysql_fetch_array($result)) {

statement

either way, $i isn't being incremented until after the central while loop is finished, either.

and in any event, you're trying to span a dataspace with two orthogonal bases (landlord and client) with one variable ($i). you're going to have to think of a different way to do it.

--
rad