PDO::PARAM_INT Param Type gives error

[KarlvonKarton]

function getKappers($limit = 10){	
	$results_array = array();	
	$rs = wire('database')->prepare("SELECT * FROM appointment_kapper WHERE (actief = '1') ORDER BY volgorde LIMIT ?");
	$rs->bindParam(1, $limit, PDO::PARAM_INT);  // ERROR
	$rs->execute([$limit]);	
	while ($row = $rs->fetch()){
		$results_array[] = $row;
	}	
	return $results_array;
}

Gives me this error and I don't understand why.
Error: Class 'ProcessWire\PDO' not found

Anyone?  I suspect PDO::PARAM_INT ?

[szabesz]

Hi,

Namespace issue? http://stackoverflow.com/questions/19699319/php-namespace-pdo-not-found

use \PDO;

[KarlvonKarton]

4 minutes ago, szabesz said:

Hi,

Namespace issue? http://stackoverflow.com/questions/19699319/php-namespace-pdo-not-found

use \PDO;

Tried that already, with no success.
But since I am using namespace, I thought it was not needed:
 

<?php namespace ProcessWire;

 

[adrian]

The problem is that PDO is outside the PW namespace, which is why the "\" is necessary to get you to the global namespace. That change definitely works for me.

But then you'll get an error with the way you have your execute([$limit]);

I would go with this version instead:

function getKappers($limit = 10) {
    $rs = wire('database')->prepare("SELECT * FROM appointment_kapper WHERE (actief = '1') ORDER BY volgorde LIMIT :limit");
    $rs->bindParam(':limit', $limit, \PDO::PARAM_INT);
    $rs->setFetchMode(\PDO::FETCH_ASSOC);
    $rs->execute();
    return $rs->fetchAll();
}

Note that I also used FETCH_ASSOC so you automatically get an array back without needing to iterate the results to build it up.

[KarlvonKarton]

Oh! Silly me... I forgot that the $limit in the execute was still there... (that's what you get with C/P-ing)

And of course yes, now the backslash is the solution.

@adrian: correct, I should use FETCH_ASSOC (and maybe :limit too)