Update multiple rows in MySQL with checkboxes with jquery datatable php sql

Question

I was using simple multiple rows update using checkboxes,php and sql, but now i am moving to jquery.datatables http://www.datatables.net/

I am not able to get checkbox values in it. Any one can tell me is there any method or i am doing any mistake ?

Following is method i am using :

if (isset($_POST['checkbox'])) {
    $checkbox = $_POST['checkbox'];
    $id = "('" . implode( "','", $checkbox ) . "');" ;
    mysql_query ("update value1 from table where id in '$id'");
}

Thanks

Your update query is wrong have a look at dev.mysql.com/doc/refman/5.0/en/update.html. You should also escape your vars to prevent sql injection. Or better use PDO or mysqli. — flec
– flec, Commented Feb 3, 2013 at 14:48

Hamza · Accepted Answer · 2017-05-31 12:37:55Z

1

I have updated the new version of data-tables and it fixed that.

answered May 31, 2017 at 12:37

Hamza

1115 bronze badges

Wow, 4 years since the original question and you just posted a solution! +1 for never giving up!

Gyrocode.com
– Gyrocode.com

05/31/2017 13:04:37
Commented May 31, 2017 at 13:04

Add a comment |

Collectives™ on Stack Overflow

Update multiple rows in MySQL with checkboxes with jquery datatable php sql

1 Answer 1

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related