Re: [PHP] prepared statement

thanks for answering my question. I have checked PHP PDO doc. PDO:: query() can send a query to server. my question is, does PDO:: query() generates prepared statement automatically? or I have to explicitly call PDO:: prepare() to use prepared statement? for example: PDO:: query("select name f

Re: [PHP] prepared statement

so only benefit for use prepared statement in Web environment is to prevent SQL injection? regards chris smith-9 wrote: > > ctx2002 wrote: >> >> I mean for each different requests/connection how can i use same prepared >> statements object that was >> gen

Re: [PHP] prepared statement

I mean for each different requests/connection how can i use same prepared statements object that was generated by PDO lib/mysql Server. is Mysql server cache prepared statement plan? for example: client one connect to our site, and send a prepared statement to our mysql DB, now the DB will c

[PHP] prepared statement

Hi all: We are use PHP PDO's Prepared statement to send SQL query to Mysql server. According to PHP PDO doc, Prepared statement are fast for executing multiple SQL queries with same parameters. "by using prepared statement you avoid repeating the analyze/compile/optimize cycle" Our application i