pg_prepare()/pg_execute() and pg_query_params()

From: Date: Tue, 26 May 2009 18:30:22 +0000
Subject: pg_prepare()/pg_execute() and pg_query_params()
Groups: php.db 
Request: Send a blank email to php-db+get-46201@lists.php.net to get a copy of this message
I'm fairly new to PHP but have a great deal of Perl experience for what it's worth. I'm having a problem where if I try to use a parameterized query it fails but pg_last_error() returns nothing. For example, $result = pg_query_params($pgconn, $update, array($foo, $bar)); if (! $result) { fwrite($fp, "before"); fwrite($fp, pg_last_error()); fwrite($fp, "after"); } The strings "before" and "after" are showing up in $fp, but nothing from pg_last_error(). Similarly, if I use pg_prepare() and pg_execute(), pg_prepare() fails but nothing is returned from pg_last_error(). Using pg_query() works, but I need to parameterize the SQL. The versions I'm using are $ php --version PHP 5.2.4-2ubuntu5.5 with Suhosin-Patch 0.9.6.2 (cli) (built: Feb 11 2009 20:09:52) Copyright (c) 1997-2007 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies and PostgreSQL 8.3.6. What am I missing? -- Brandon

« previous php.db (#46201) next »