PDO prepare statement cache problem

The place for general PHP questions and hints for PHP on IBM i
Post Reply
padelaunay
Posts: 3
Joined: Tue Aug 24, 2010 3:01 pm

PDO prepare statement cache problem

Post by padelaunay » Thu Oct 31, 2019 9:58 am

hi ,
we have a probleme with PDO and prepare statement

we are building a web application on php and ibm I V7R3
the php is on linux server and we connect to the IBM I with the unix odbc connecter
and we have a problem when we change structure of file
the resultset of the request seems to take the old description
when we change the request it's work :

example :
we have a file : client

Code: Select all

 client Code |name|surname | 
we make this request :

Code: Select all

 select * from client  where name = :name  
all work fine
we change the file :

Code: Select all

 client Code |name|surname |adresse 
and the same request make resultset "strange"
when we change the request like :

Code: Select all

 select * from client  where 1= 1 and name = :name  
it's work

if we rechange the request like that :

Code: Select all

 select * from client  where name = :name  
it's doesnt work

i think the problem it's the prepare cache

can we clear the cache ?
where is that cache ? on php server ? on IBM I ?

someone have an idea ?
thanks all

Post Reply