How to delete unchecked and insert checked value in database using php?

Question

I have to delete the unchecked value and new checked values into a database. How to achieve this? Already existed checkbox also will be posted again. But if they uncheck I need to delete. This is my below code:

$already_exist_category = array("68","70")
$newly_posted_category = array("124","125","68") or array("124","125");

How to update or delete and insert the newly posted id into the table?

Niranjan N Raju · Accepted Answer · 2015-11-14 07:40:45Z

1

First delete the id which is not there, then insert the data.

delete from table where id not in ($already_exist_category)

insert the new id here.

answered Nov 14, 2015 at 7:40

Niranjan N Raju

12k4 gold badges24 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

markatte team Over a year ago

its duplicating the category id

Niranjan N Raju Over a year ago

make sure you check before inserting the values to db you check if the row is already exista.

Collectives™ on Stack Overflow

How to delete unchecked and insert checked value in database using php?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related