mysql,update multiple rows through an ajax call with primary keys in an array

Question

An array containing the primary key values of a mysql table will be passed through an ajax call to a php page and from the php page, rows with the primary keys in the array will be updated

js snippet:

<script type="text/javascript">

$(document).ready(function(){


    var my_array=[1,2.,4,5,6];

    $.post("array_post.php",{

        my_array:my_array

        },function(response){

            alert(response);
            }

    );



    });


</script>

'id' is the primary key. array_post.php has :

$my_array=$_POST['my_array'];

$sql="UPDATE my_table SET my_col=1 WHERE id IN ($my_array)";

Bu that shows error.

I need the solution.

something like : Sorry the update query could not be executed into table post_comment notification</br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Array' at line 1 — Istiaque Ahmed
– Istiaque Ahmed, Commented Feb 9, 2012 at 10:53

Thorsten · Accepted Answer · 2012-02-09 10:47:24Z

1

You need to transform your array to a string:

$sql="UPDATE my_table SET my_col=1 WHERE id IN (" . implode(',', $my_array) . ")";

And, you should seriously validate your input, not just use $_POST

answered Feb 9, 2012 at 10:47

Thorsten

5,6446 gold badges37 silver badges33 bronze badges

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

2 Comments

Istiaque Ahmed Over a year ago

so, 'IN' key word searches in a comma separated string , not in an array, right?

Thorsten Over a year ago

Yeah, well, you just can't use an PHP array in an SQL String. It need to look like IN (1,2,3).

user1193818 · Accepted Answer · 2012-02-09 10:53:10Z

1

your array must be comma separated so use implode(",",$my_array) instead of using just $my_array

answered Feb 9, 2012 at 10:53

user1193818

1 Comment

Istiaque Ahmed Over a year ago

implode returns a string, not an array

Collectives™ on Stack Overflow

mysql,update multiple rows through an ajax call with primary keys in an array

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related