Multi Update Via Checking Box

[Kleidi]

Hello there,
I'm looking forward for a way on updating multi rows in my database.
I have a table with many fields and 4 of them are ENUM fields with values YES or NO (IsActive, Index, Hot, New). If the value of "IsActive=YES' the row is active (Index=is showin in index; hot=is showing a hot image; new=is showing a new image). When i list all the rows of that db, for those field i have made a checkbox that is checked if the value is YES and unchecked if the value is NO. What i need to do now, is a way to modify multi rows of db only the field affected by checking or unchecking option and pressing a submit button.
When i press the submit button, will be updated only rows that has any changes on it and other rows will remain intact.

I have attached an print screen of my page to gett a better idea on what i want to do.

Hope that someone will help me on this!

Thank you in advance!

[donboe]

When you use IN in your SQL/mySql Where statement you are able to update multiple values. I.E.

  UPDATE
  yourTable
  SET yourField = yourValue
  WHERE yourField IN ( 1, 3, 5, 8, 9 )

[Kleidi]

When you use IN in your SQL/mySql Where statement you are able to update multiple values. I.E.

  UPDATE
  yourTable
  SET yourField = yourValue
  WHERE yourField IN ( 1, 3, 5, 8, 9 )

But, since i'll have 4 fields for update which of them should be on

... SET 
yourField = yourValue
  WHERE ...

In place of your number what should be? Field names or values?

thank you for your help and sorry for my stupid questions

[Kalon]

The first thing you need to do is make sure all the checkboxes for each ID in your form have the same name. Then each ID will send an array of checked checkboxes.

The name should include the ID value to make it easier in the php script to see which ID the checkbox values belong to.

Your php script will then receive an array of checked checkbox values for each ID.

You then loop thorough each set of checkboxes for each ID and build your update query based on the values of the checkboxes for that ID. The value of each checkbox will tell you which columns you need to include in your update query.

After you build an update query for each ID, then run it to update the selected columns for that ID.

[Kleidi]

The first thing you need to do is make sure all the checkboxes for each ID in your form have the same name. Then each ID will send an array of checked checkboxes.

The name should include the ID value to make it easier in the php script to see which ID the checkbox values belong to.

Your php script will then receive an array of checked checkbox values for each ID.

You then loop thorough each set of checkboxes for each ID and build your update query based on the values of the checkboxes for that ID. The value of each checkbox will tell you which columns you need to include in your update query.

After you build an update query for each ID, then run it to update the selected columns for that ID.

Thank you for your help, but, since i'm new in php i don't know how to do that.
Field Names are:

PakIndex
PakHot
PakNew
PakAktiv

And the html list looks like this:

<span class="result_column" style="width: 7%;"><center><input type="checkbox" style="checkbox" name="PakAktiv" value="2" /></center></span>
<span class="result_column" style="width: 6%;"><center><input type="checkbox" style="checkbox" name="PakAktiv" value="2" /></center></span>
<span class="result_column" style="width: 6%;"><center><input type="checkbox" style="checkbox" name="PakAktiv" value="2" checked="checked" /></center></span>
<span class="result_column" style="width: 8%;"><center><input type="checkbox" style="checkbox" name="PakAktiv" value="2" checked="checked" /></center></span>

Where value=ID of the row. In this case, the row have ID 2

I have changed the type of field for this fields to TINYINT with values 1 and 0 from ENUM.
The tablename is paketa.
Now, having all this details, can you help me to build that query and function, PLEASE?

Thank you in advance!

[Kalon]

to give checkboxes the same name, you do it like this

 
<input type="checkbox" name="chkBox_1[]" value="val_1" />
<input type="checkbox" name="chkBox_1[]" value="val_2" />
<input type="checkbox" name="chkBox_1[]" value="val_3" />
<input type="checkbox" name="chkBox_1[]" value="val_4" />

and then each checkbox that is checked will have its value sent to the server side script.

assuming you used method="post" in your form then $_POST['chkBox_1'] in your php script will contain the checked values.

these general coding and debugging principles might help you build your code.