Only variables can be passed by reference - php

Question

i am trying this code, but i get this error:

Only variables can be passed by reference in xxx

script

class page {
  function insert($db, $of, $form, &$arr) {

      $i = 0;

      foreach(array_combine($form['value0'], $arr) as $val=>$v){

          $sql->prepare("mysqli query here");
          $sql->bind_param('ssss', $val, $of, $v[$i][0], $v[$i][1]);//error here
          $sql->execute();
          $i++;

      }
      return true;
  }
}

what is the reason, and how can be solved ? thanks

$of, but for this case, is irrelevant, the problem is about reference (&$arr). — user455318
– user455318, Commented Oct 27, 2011 at 2:31

Community · Accepted Answer · 2023-11-17 20:42:18Z

5

I assume you're using mysqli::bind_param. All arguments except the first are passed by reference. This means they must be variables, and not strings, array elements, etc. I'm actually not sure why it needs to do this by reference, but never mind. You can fix it pretty easily:

$v0 = $v[$i][0];
$v1 = $v[$i][1];
$sql->bind_param('ssss', $val, $of, $v0, $v1);

edited Nov 17, 2023 at 20:42

CommunityBot

11 silver badge

answered Oct 27, 2011 at 2:32

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

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

1 Comment

user166390 Over a year ago

"Silly design decision", but it is what it is.: I suppose "so the value can be assigned to after bind but before execution?" which would allow the same $sql to be re-used repeatedly by only changing the value of the referenced variables... again, not how I would have designed it.

Collectives™ on Stack Overflow

Only variables can be passed by reference - php

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related