how to update record based on checkbox selection

[mukeshrasm]

Hi

I want to update records in database based on selected records using checkbox. if user does not select a record and clicks update button it should show the message please select record to be update
if user selects say 3 records then there should be message are you sure to update 3 records and when clicks ok records should get updated.

since records are coming dynamically so how can I get the number of checkboxes selected or not to display message using javascript. and then when i will write query to update then how will I retrieve the value of checkbox based on which records will be updated.

in checkbox I am passing the id of the records

[Markus]

To pass an array of checkboxes (checkboxes that a grouped by some definition) you must name them suffixed with brackets (name="checkboxes[]"). Then, I assume you're POSTING, you retrieve them via $_POST['checkboxes']. Use a count() on the array to see if any checkboxes were passed.

[mukeshrasm]

@Markus
Yes I am using $_POST to retrieve but how will retrieve the value of checkbox means should I use loop or it will be display all checkboxes value since it is array.

[Markus]

@mukeshrasm
Yes, a loop.

if ( count ( $_POST['checkboxes'] ) > 0 )
{
    foreach ( $_POST['checkboxes'] as $key => $val )
    {
        // $val holds the value of your checkbox
        // $key is the index in the array of said checkbox.
    }
}
 

[mukeshrasm]

@Markus
Thanks! for this and I think this will solve my purpose..

[Markus]

@mukeshrasm
You're welcome.

Post back with any problems.

- Mark.

[mukeshrasm]

@Markus
Hi

using javascript I tried to find the no. of checkboxes selected. I used like

var lengthh=document.getElementsByName("chk[]").length            var j=0;
            for (i=0, l=lengthh; i<l; i++)
            {
                               if (document.getElementsByName("chk[]").checked==true)  //here I don't know how I will loop through to find the number of checkboxes selected.
                {
                     j++;
               }
           }
          if (j==0)
          {
             alert("Please Select Record to delete!")
          }
    else     {
     confirm("Do you really want to remove selected "+ j +" items" )
     }
   }
 
 

and one more interesting thing when I click "Cancle" button of Confirm message event also get fired i.e. it deletes the record.