Zend 2: SQLSRV: $prepareParams is not being set

Question

Can somebody explain me where the

->setPrepareParams(array $prepareParams) 

is called in Zend\Db\Adapter\Driver\Sqlsrv\Statement.php?

Specifically, when I used this:

$this->tableGateway->select(array("Personalnummer = $personalnumber"));

It worked. But when I used this:

$this->tableGateway->select(array("Personalnummer" => $personalnumber));

It did not work.

I tried to debug this and found that the params were not being set with my second method.

Answer 1

Are you looking for this code?

Adapter/Driver/Sqlsrv/Statement::prepare()

Without looking deeper into it, it looks like the way you are calling the select statement, it expects indices that are numbers: 0, 1, 2, 3, ... and so on.

So when you call

array("Personalnummer = $personalnumber")

It is the same as calling

array(0 => "Personalnummer = $personalnumber")

And since code expects a value at index 0, your code works then. When you use parameterized statements, your code fails. Because it does not expect parameterized arrays (your second way).

Look into how you set your initial parameters. There may be a configuration option that sets the code to expect parameterized arrays.

Answer 2

In your database configuration, what is your connection driver? PHP supports parameterized queries only through PDO, and Zend Framework cannot go beyond what PHP is capable of. Therefore, to get array("Personalnummer" => $personalnumber) to work, you need to have configuration driver key be pdo_sqlsrv. Sounds like you have 'driver' => 'Sqlsrv' instead.

Answer 3

It is a public method so it is up to the client programmer to use it.

It is just a setter for the protected property $prepareParams.

Why do you expect it to be called inside the class?