pdo isn't getting parameter value

Asked Apr 28 '16 at 15:17

Active Apr 28 '16 at 15:25

Viewed 25 times

I'm new to php and pdo. I have the following code.

$buildFormId = 1;
$query = $pdo->prepare("select * from WebsiteBuildForm where id=:id");
$query->bindParam(':id', $buildFormId, PDO::PARAM_INT);
$query->execute();

if ($query->rowCount() == 0){
    echo "found nothing for ".$buildFormId;
    exit;
}

In this case I get the message that nothing was found. However if change the code to this, it works.

$buildFormId = 1;
$query = $pdo->prepare("select * from WebsiteBuildForm where id=".$buildFormId);
$query->execute();

From the examples for pdo that I've seen the first code block "should" work. Any idea what I'm doing wrong? Thanks.

asked Apr 28 '16 at 15:17

geoff swartz

5,437
11
51
75

Does the PDO query work if you remove `PDO::PARAM_INT`? – The Codesee Apr 28 '16 at 15:22
no. I've also tried it without the bindParam line instead using ? in the query and an array in the execute call. – geoff swartz Apr 28 '16 at 15:24
your code worked for me, so you've got some typo and this question is not a real one. – Your Common Sense Apr 28 '16 at 15:29
@YourCommonSense the fact you can't reproduce doesn't mean there is no problem... It may be specific to his config or something else... – Random Apr 28 '16 at 15:32
did you try $query->bindValue() instead of bindParam()? – olibiaz Apr 28 '16 at 15:33
yes, I tried both bindParam and bindValue – geoff swartz Apr 28 '16 at 15:34
I don't see any reason why it should work for one and not the other. – Mike Apr 28 '16 at 15:39
2

Found my answer. http://stackoverflow.com/questions/3828215/using-typed-bound-parameters-with-php-pdo-odbc-unixodbc-and-freetds Changed the FreeTDS version from 8.0 to 7.2 and parameters work now. – geoff swartz Apr 28 '16 at 16:38
@geoffswartz Feel free to flag this one as a duplicate of the other one then, or delete it. – Mike Apr 28 '16 at 16:44

pdo isn't getting parameter value

0 Answers0