DaniWeb Forum Index > Web Development > PHP

Updating selected Checkbox problem

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Apr 2008

Posts: 496

Reputation: veledrom is an unknown quantity at this point

Solved Threads: 0

veledrom

Offline

Posting Pro in Training

Updating selected Checkbox problem

Aug 3rd, 2008

Hi,
When i click one checkbox code below workes fine but, more than one, noo. I cant find the problem. Can you help me please?
Thnaks

1st page.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<td><input type="checkbox" name="checkboxReceipt<?php echo "[$newArray[id]]"; ?>" value="<?php echo $newArray['id']; ?>" id="checkboxReceipt"></td>
<td><input type="checkbox" name="checkboxReceipt<?php echo "[$newArray[id]]"; ?>" value="<?php echo $newArray['id']; ?>" id="checkboxReceipt"></td>

2nd page.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
if (isset($_POST['checkboxReceipt'])){
   $sql="UPDATE payment SET";
      foreach ($_POST['checkboxReceipt'] as $key=>$value)
         $sql.=" Ref='xxx', date='xx-xx-xxxx' WHERE id='$checkedReceipt[$key]',";
         $sql=substr($sql,0,-1);
         $sql.=";";
   $run = mysql_query($sql);
if (isset($_POST['checkboxReceipt'])){
   $sql="UPDATE payment SET";
      foreach ($_POST['checkboxReceipt'] as $key=>$value)
         $sql.=" Ref='xxx', date='xx-xx-xxxx' WHERE id='$checkedReceipt[$key]',";
         $sql=substr($sql,0,-1);
         $sql.=";";
   $run = mysql_query($sql);

•

Join Date: Nov 2007

Posts: 596

Reputation: buddylee17 has a spectacular aura about

Solved Threads: 125

buddylee17 buddylee17 is offline

Offline

Posting Pro

Re: Updating selected Checkbox problem

Aug 3rd, 2008

Just by breezing over the code, it looks like you are trying to update one row with two or more values. If so, you'll have to concatenate them before the update.

Lost time is never found again.
- Benjamin Franklin

•

Join Date: Jul 2008

Posts: 1,072

Reputation: Shanti Chepuru is on a distinguished road

Solved Threads: 98

Shanti Chepuru Shanti Chepuru is offline

Offline

Veteran Poster

Re: Updating selected Checkbox problem

Aug 4th, 2008

i think you have use check box in this way....

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<input name="checkboxReceipt[]" value="<?php echo $frow['id']; ?>" type="checkbox"  />
<input name="checkboxReceipt[]" value="<?php echo $frow['id']; ?>" type="checkbox"  />

Last edited by Shanti Chepuru; Aug 4th, 2008 at 4:23 am.

Be intelligent, But Don't try to cheat.. Be innocent But Don't get cheated..

•

Join Date: Apr 2008

Posts: 496

Reputation: veledrom is an unknown quantity at this point

Solved Threads: 0

veledrom

Offline

Posting Pro in Training

Re: Updating selected Checkbox problem

Aug 4th, 2008

Solved with code below.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
    foreach ($checkedReceipt as $key=>$value) {
     $sql="UPDATE payment SET Ref='xxx', date='xxxx-xx-xx'  WHERE id='$checkedReceipt[$key]'";	
  $run = mysql_query($sql);
    foreach ($checkedReceipt as $key=>$value) {
     $sql="UPDATE payment SET Ref='xxx', date='xxxx-xx-xx'  WHERE id='$checkedReceipt[$key]'";	
  $run = mysql_query($sql);