Active4 years, 10 months ago

I want to update details in two tables in mysql, the one with the server details is updating correctly, but im struggling to update the checkbox values (try to remove or insert into the checkbox ta. I'm fairly new to PHP, and so have no idea. Update Multiple Rows w/ Checkboxes. And so have no idea how to update multiple rows in a mysql database.

I want to update details in two tables in mysql, the one with the server details is updating correctly, but im struggling to update the checkbox values (try to remove or insert into the checkbox table in mysql) whereby the user selects the checkbox needed to be added or to be removed from the database.

Here is my FORM:

Here is my Update Script:

The server details is updating correctly, but the information from the checboxes from the form is not updating in their mysql table.

Isaac Bennetch

8,2532 gold badges19 silver badges32 bronze badges

Mysql Update Multiple Values

CodecommonCodecommon

1 Answer

The problem is, if you do not check the checkbox, So you need to check like this:

NOTE:

As the other says in the comment. Do not use mysql_* functions, they are deprecated. Use mysqli_* or PDO instead.
Avoid sql injections by escaping your variables in your query!

vaso123vaso123

10.6k2 gold badges23 silver badges54 bronze badges

Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.

Not the answer you're looking for? Browse other questions tagged phpmysqlcheckbox or ask your own question.

Active3 years, 4 months ago

Php Mysql Multiple Select Query

i can update mysql database by one checkbox value 0/1 by ajax, but i don't know how to do this with multiple checkbox,

my code: index.php

ajax.php

above code work only for one checkbox, what to do for 8 or 10 checkbox.

where to make change in script for switch1 switch2 switch3.

nish

nishnish

1 Answer

I have updated the answer:(I will suggest you to use mysqli_(), as mysql_() is depreciated. But I did not change anything regarding that.)

I have changed your index page only, your ajax.php should be the same.

Dipanwita KunduDipanwita Kundu

1,6531 gold badge5 silver badges14 bronze badges

Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.

Mysql Update Multiple Values

1 Answer

Not the answer you're looking for? Browse other questions tagged phpmysqlcheckbox or ask your own question.

Php Mysql Multiple Select Query

1 Answer

Mysql Update Multiple Rows

Not the answer you're looking for? Browse other questions tagged phpjquerymysqlajaxcheckbox or ask your own question.

Php Mysql Multiple Checkbox Update