Search code examples
phpadodb-php

ADOdb gives "Fatal error: Cannot pass parameter 2 by reference"

I've using ADOdb Execute function:

$query = "select * from users where user_id = ? and PWD = ?";
$execute = $conn->Execute($query,array($username, $password));

Which gives the error:

Fatal error: Cannot pass parameter 2 by reference

I have no idea why. Any ideas?

Solution

  • Most likely the Execute method is declared as public function Execute($query, &$params) meaning the second method is expected to be passed by reference. Thus you have to pass a variable. Try this:

    $query = "select * from users where user_id = ? and PWD = ?";
$params = array($username, $password);
$execute = $conn->Execute($query, $params);