checkbox array HELP!!!!

djkanebo

I have a file which produces a form. The form is generated from the database and its purpose is to allow deletion of items from the database. Each item has a checkbox beside it. You check the checkboxes and then click a button to delete the selected items.
This works fine until there are 16 or more items displayed on the form.
I assume there is some kind of limitation on the array. Can anyone help me????

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

             $carID=$carInfo["carID"];
             $origin=$carInfo["origin"];
             $manufacturer=$carInfo["manufacturer"];
             $model=$carInfo["model"];
             $engineSize=$carInfo["engineSize"];
             $numDoors=$carInfo["numDoors"];
             $bodystyle=$carInfo["bodystyle"];
             $mpg=$carInfo["mpg"];
             $zeroToSixty=$carInfo["zeroToSixty"];
             $maxSpeed=$carInfo["maxSpeed"];
             $insuranceGroup=$carInfo["insuranceGroup"];
             $typicalInsuranceQuote=$carInfo["typicalInsuranceQuote"];
             $airbags=$carInfo["airbags"];
             $alarm=$carInfo["alarm"];
             $aircon=$carInfo["aircon"];
             $typicalContractPrice=$carInfo["typicalContractPrice"];
             $price=$carInfo["price"];


             echo "<tr valign=center> \n" .
	      "    <td align=center><input type=checkbox name=carToRemove[] value='$carID'></td> \n"

mogster

Well, this is all well and good, but what happens when you exceed the 16 chkbxes? Error report, please.
And there's no limitations to the array.

But your html is strange:
echo "<tr valign=center> \n" .
" <td align=center><input type=checkbox name=carToRemove[] value='$carID'></td> \n"

should preferrably be:
echo "<tr><td align="center"><input type="checkbox" name="carToRemove[]" value="$carID"></td></tr>\n";

knutm

mogster

And you must end the loop with a }

knutm

djkanebo

i only posted some of the code... sorry!

when u exceed 15, the button labelled 'Remove These' stops working.... there is no error report!

my <html> isn't great!

djkanebo

here is all code!

<html>

<head>

<title>Online Car Recommender System - Remove A Car</title>
<META HTTP-EQUIV="Pragma" CONTENT="no-cache">
<META HTTP-EQUIV="Expires" CONTENT="-1">

  <script language="javaScript">

     function goto(destination) {
        document.location.href=destination;
     }

  </script> 

<link rel=stylesheet href=style.css>

</head>

<body>

<?php

  if($usertypeCookie!="administrator")
  {
          echo " <p>&nbsp;</p><h3> Access Denied <BR><BR><BR> \n" .
               " You are not currently logged in as an administrative user <BR><BR><BR> \n".
               " You do not have privilege to this page</h3><BR><BR> \n ";
      echo "   <center><input type=button value='Back' onClick=\"javascript:history.back()\"> \n";
      echo "           <input type=button value='Login Page' onClick=\"goto('welcome.php')\"></center> \n";
          exit;
  }

<?php

$db = mysql_connect("localhost", "d99kd", "password");
mysql_select_db("d99kd",$db);
$dbQuery="SELECT * FROM cars where manufacturer='Audi' ORDER BY carID";
$result = mysql_query($dbQuery,$db);

<div align=center>

  <input type=button value='Back' onClick="javascript:history.back()">
  <input type=button value='Return To Admin Menu' onClick="document.location.href='administratorHome.php'">
  <input type=button value='Logout' onClick="document.location.href='welcome.php?status=logout'">
</div>

<br>

<table class=border align=center width=75% cellspacing=0 cellpadding=5>
<tr><th>Remove An Audi</th></tr>

<tr><td>
<table width=100% cellpadding=3 cellspacing=3 border=0>
<tr>
<td></td>
<td align=left valign=center class="tabletitles">CarID</td>
<td align=left valign=center class="tabletitles">Manufacturer</td>
<td align=left valign=center class="tabletitles">Model</td>
<td align=left valign=center class="tabletitles">Engine Size (l)</td>
<td align=left valign=center class="tabletitles">Num of Doors</td>
<td align=left valign=center class="tabletitles">Bodystyle</td>
<td align=left valign=center class="tabletitles">Price (£)</td>
</tr>

<?php
while ($carInfo=mysql_fetch_array($result)) {

             $carID=$carInfo["carID"];
             $origin=$carInfo["origin"];
             $manufacturer=$carInfo["manufacturer"];
             $model=$carInfo["model"];
             $engineSize=$carInfo["engineSize"];
             $numDoors=$carInfo["numDoors"];
             $bodystyle=$carInfo["bodystyle"];
             $mpg=$carInfo["mpg"];
             $zeroToSixty=$carInfo["zeroToSixty"];
             $maxSpeed=$carInfo["maxSpeed"];
             $insuranceGroup=$carInfo["insuranceGroup"];
             $typicalInsuranceQuote=$carInfo["typicalInsuranceQuote"];
             $airbags=$carInfo["airbags"];
             $alarm=$carInfo["alarm"];
             $aircon=$carInfo["aircon"];
             $typicalContractPrice=$carInfo["typicalContractPrice"];
             $price=$carInfo["price"];


             echo "<tr valign=center> \n" .
	      "    <td align=center><input type=checkbox name=carToRemove[] value='$carID'></td> \n" .
	      "    <td align=left>  \n" .
                  "       $carID</td> \n" .
                  "    <td align=left>  \n" .
                  "       $manufacturer</td> \n" . 
                  "    <td align=left>  \n" .
                  "       $model</td> \n" . 
                  "    <td align=left>  \n" .
                  "       $engineSize</td> \n" . 
                  "    <td align=left>  \n" .
                  "       $numDoors</td> \n" . 
                  "    <td align=left>  \n" .
                  "       $bodystyle</td> \n" .  
                  "    <td align=left> \n" .
                  "       $price</td> \n" .      
                  "        <input type=hidden name=deleteDatabase value='yes'> " .
                  "        <input type=hidden name=theCARID value='$carID'> \n" . 
                  "        <input type=hidden name=theMANUFACTURER value='$manufacturer'> \n" .
                  "        <input type=hidden name=theMODEL value='$model'> \n" .
                  "        <input type=hidden name=theENGINESIZE value='$engineSize'> \n" .
                  "        <input type=hidden name=theNUMDOORS value='$numDoors'> \n" .
                  "        <input type=hidden name=theBODYSTYLE value='$bodystyle'> \n" .
                  "        <input type=hidden name=thePRICE value='$price'> \n" .
	      "</tr>\n\n" ;                 


         }

      </table>
    </td>
</tr>

  <tr><td colspan=8><center><input type=submit name=submit value='Remove These Audis'></center></td></tr>
</table>

</form>
</body>

</html>

If you want the code for deleteCarProcess.php, let me know although i know that it definetly works!

djkanebo

HELP ME :-(

mogster

Hi there!

Use single quotes, not
$price=$carInfo["price"];
but
$price=$carInfo['price'];

when u exceed 15, the button labelled 'Remove These' stops working.... there is no error report!

But it DOES submit the form? You should also check the source-code for the form once it's loaded, try view source. Is all id's correct?

The form also contain a lot of hidden fields with possibilities for errors. Example: if the code in db for, say, manufacturer, contains a " (or in this case, a '), the hidden-field won't be able to work as a container for the data, even though the data is addslashed. If you're gonna send data in hidden fields like this, do a htmlspecialchars($data) when filling it into the field to avoid the error.

Difficult to say what the error may be, but perhaps one of the above. Check the source 😉

knutm