diff options
| author | Matteo Beccati <mbeccati@php.net> | 2014-03-09 14:08:17 +0100 |
|---|---|---|
| committer | Matteo Beccati <mbeccati@php.net> | 2014-03-11 23:10:48 +0100 |
| commit | e378348a316008822737d47cf47a4938cbc07dd6 (patch) | |
| tree | 5f400db6fec449e140eff0738882ee85bf08295e /ext/pdo_pgsql/pgsql_statement.c | |
| parent | d72621ab9e8a6cc89fe1005a83c16249fdc02810 (diff) | |
| download | php-git-e378348a316008822737d47cf47a4938cbc07dd6.tar.gz | |
Added new PDO::PGSQL_ATTR_DISABLE_PREPARES that uses PQexecParams
Faster than prepared statements when queries are run once. Slightly
slower than PDO::ATTR_EMULATE_PREPARES but without the potential
security implications of embedding parameters in the query itself.
Diffstat (limited to 'ext/pdo_pgsql/pgsql_statement.c')
| -rw-r--r-- | ext/pdo_pgsql/pgsql_statement.c | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/ext/pdo_pgsql/pgsql_statement.c b/ext/pdo_pgsql/pgsql_statement.c index 02fc1d6e90..35e69a3c02 100644 --- a/ext/pdo_pgsql/pgsql_statement.c +++ b/ext/pdo_pgsql/pgsql_statement.c @@ -204,7 +204,17 @@ stmt_retry: S->param_lengths, S->param_formats, 0); + } else if (stmt->supports_placeholders == PDO_PLACEHOLDER_NAMED) { + /* execute query with parameters */ + S->result = PQexecParams(H->server, S->query, + stmt->bound_params ? zend_hash_num_elements(stmt->bound_params) : 0, + S->param_types, + (const char**)S->param_values, + S->param_lengths, + S->param_formats, + 0); } else { + /* execute plain query (with embedded parameters) */ S->result = PQexec(H->server, stmt->active_query_string); } status = PQresultStatus(S->result); @@ -234,7 +244,7 @@ static int pgsql_stmt_param_hook(pdo_stmt_t *stmt, struct pdo_bound_param_data * { pdo_pgsql_stmt *S = (pdo_pgsql_stmt*)stmt->driver_data; - if (S->stmt_name && param->is_param) { + if (stmt->supports_placeholders == PDO_PLACEHOLDER_NAMED && param->is_param) { switch (event_type) { case PDO_PARAM_EVT_FREE: if (param->driver_data) { |