PHP error while using array

Question

I get this error from the first line of the following code:

    Fatal error: Only variables can be passed by reference in /home/path/file.php on line 36



        if (isset($_POST['id']))
        {
            $ids = array_walk('intval', $_POST['id']);

            $sql = "DELETE FROM table WHERE id IN (' . implode(',', $ids) . ')')";
            //run query here

            $msg->type = "success";
            $msg->text = "Bulk delete has been successful";
        }

Any ideas what it could be?

BTW, the above code is to mass delete items.

Error is caused by $ids = array_walk('intval', $_POST['id']);

use double quotes in this line instead: "DELETE FROM table WHERE id IN (" . implode(',', $ids) . ")')"; — hackartist
– hackartist, Commented Mar 8, 2012 at 23:26
have you got the parameters on array_walk in the wrong order? — Scuzzy
– Scuzzy, Commented Mar 8, 2012 at 23:26
@AndreasStokholm The issue is with the $ids = array_walk('intval', $_POST['id']); line — user962449
– user962449, Commented Mar 8, 2012 at 23:27
@Scuzzy what do you mean? The $_POST['id'] is empty, I moved it inside the if statement (updated the Q), but I still get the error. — user962449
– user962449, Commented Mar 8, 2012 at 23:30

Henesnarfel · Accepted Answer · 2012-03-09 00:56:23Z

2

your call to the function array_walk is incorrect

bool array_walk ( array &$array , callback $funcname [, mixed $userdata = NULL ] )

try this instead and assuming that $_POST['id'] is an array

$ids = array_walk($_POST['id'], 'intval');

http://php.net/manual/en/function.array-walk.php

Also it may be good to check before calling the function to make sure that $_POST['id'] is an array

EDIT

After looking at what you doing a little more the function you need to use is array_map. array_walk returns a boolean while array_map returns an array which is what it looks like you need returned since you are using implode on $ids.

So you need to have

$ids = array_map('intval', $_POST['id']);

edited Mar 9, 2012 at 0:56

answered Mar 8, 2012 at 23:28

Henesnarfel

2,1291 gold badge16 silver badges18 bronze badges

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

Comments

Ben Ashton · Accepted Answer · 2012-03-08 23:30:59Z

1

array_walk calls a function for every array, and takes function as parameter 0. I think you need to change:

array_walk('intval', $_POST['id']); to array('intval', $_POST['id']);

answered Mar 8, 2012 at 23:30

Ben Ashton

1,40512 silver badges15 bronze badges

Comments

dotancohen · Accepted Answer · 2012-03-08 23:27:32Z

0

Which line is line 36? Also, you seem to have an extra close parenthesis in the SQL statement. Furthermore, is the $_POST variable really an array?

answered Mar 8, 2012 at 23:27

dotancohen

31.7k42 gold badges147 silver badges207 bronze badges

1 Comment

user962449 Over a year ago

yes it's an array. The html is <input type="checkbox" name="id[]" value="{$id[$index]}" />

Michal · Accepted Answer · 2012-03-08 23:28:33Z

0

Maybe you have changed the order of arguments in $ids = array_walk('intval', $_POST['id']);? In my opinion it should be $ids = array_walk($_POST['id'],'intval');.

answered Mar 8, 2012 at 23:28

Michal

3,3524 gold badges33 silver badges51 bronze badges

Collectives™ on Stack Overflow

PHP error while using array

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related