Error when using bindParam: Only variables should be passed by Reference

Question

I’m getting an error when I use the bindParam from the PDO, code:

Connectionpdo class:

function __construct($dsn, $username = NULL, $password = NULL, $options = NULL) {
  parent::__construct($dsn, $username, $password, $options);
  $this->LoadDriverMethods();
}

public function insert($table, $data) {
  $this->lastSQL = $this->driver->insert($table, $data);

  $stmt = $this->prepare($this->lastSQL);

  $this->driver->setParams($this->stmt);

  return $this->stmt;
}

private function LoadDriverMethods(){
  $driver = __DIR__ . DIRECTORY_SEPARATOR . 'drivers' . 
                      DIRECTORY_SEPARATOR . 'sqldriver.' . 
                      strtolower($this->getAttribute(PDO::ATTR_DRIVER_NAME)) . '.php';

  if (!is_file($driver))
     throw new Exception('Não foi possível carregar os métodos do driver', 1);

  require_once $driver;
  $this->driver = new SQLDriver();
}

Sqldriver class:

public function setParams(PDOStatement $stmt){
  $params = $this->getParams();
  if (is_array($params) && !empty($params))
     foreach ($params as $param => $value)
     $stmt->bindParam($param, $this->prepareParam($value), $this->getParamType($value));
}

Error:

Strict Standards: Only variables should be passed by Reference in Connectionpdo drivers sqldriver.mysql.php

Which refers to the following line in class Sqldriver:

$stmt->bindParam($param, $this->prepareParam($value), $this->getParamType($value));

Answer 1

You cannot pass values or feedback from futions/methods to bindParam() because it expects references(variables) in this case just exchange for bindValue().

I see you’re riding a lib, bindParam() will only make a difference in the use of stored procedures that return value, in which the return goes to the specified variable

Can mount a dynamic bind with that suggestion

What is the difference between bindParam and bindValue?