Re: [IBMiOSS] PHP and db2_prepare

[Pete Helgren <pete@xxxxxxxxxx>]

You may want to output the parameter value and see what it is. Something 
at the back of my head tells me it is a data type mismatch (string for 
numeric) but I can't rightly remember.  PHP is an untyped language but 
that lack of type can come back to haunt you.  I am not sure if this is 
one of those cases.....

Pete Helgren
www.petesworkshop.com
GIAC Secure Software Programmer-Java
LinkedIn - www.linkedin.com/in/petehelgren
Twitter - Sys_i_Geek  IBM_i_Geek

On 10/31/2016 11:50 AM, Jason Aleski wrote:
> Attempting to perform a simple select using a PHP and db2_prepared 
> statements.  Running the query directly works fine (first part of 
> code).  When I run the db2_execute($stmt, $params), I get an error 
> saying "Statement Execute Failed" with a SQL Error Code of 22023.  Can 
> anyone see what I'm doing wrong here?
>
> PHP Code Below
>
> <?php
> $conn = db2_connect($database, $username, $password, $options);
>
> $sql = "SELECT count(*) FROM CUSTOMERS WHERE acctnbr = ". 
> $_REQUEST['accountNumber'];
> $stmt = db2_exec($conn, $sql);
> while ($row = db2_fetch_array($stmt)) {
>   print "$row[0]\n";
> }
> print "THIS WORKS <hr />";