Req #32977 [Opn->Wfx]: Alternative pg_query_params returning query
| From: | yohgaki@php.net | Date: | Sat, 31 Mar 2012 05:28:23 +0000 |
| Subject: | Req #32977 [Opn->Wfx]: Alternative pg_query_params returning query | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-169068@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=32977&edit=1
ID: 32977
Updated by: yohgaki@php.net
Reported by: direvus at gmail dot com
Summary: Alternative pg_query_params returning query
-Status: Open
+Status: Wont fix
Type: Feature/Change Request
Package: PostgreSQL related
Operating System: Debian Linux
PHP Version: 5.0.4
Block user comment: N
Private report: N
New Comment:
pg_query_params() relies on real prepared query feature in PostgreSQL.
Use new pg_escape_literal()/pg_escape_identifier() for escaping strings.
Previous Comments:
------------------------------------------------------------------------
[2005-05-08 11:46:28] direvus at gmail dot com
Description:
------------
pg_query_params is a neat function, and I think it would be useful to have a separate function which
resolves the statement (makes all the parameter substitutions) and then returns the completed SQL
statement string, rather than immediately executing it and returning the result set.
You could, for example, have pg_resolve_params return the query string, and then have
pg_query_params which essentially returns pg_query( pg_resolve_params( [...args...] ) );
Thoughts?
BJ
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=32977&edit=1