Bug #3374

Postgress in PHP

Details

Submitted	2005-02-03 22:54 UTC
From	dmoore at pbpost dot com
Status	No Feedback
Package	DB_DataObject
PHP Version	4.2.2
OS	Redhat 9.0
Roadmaps	(Not assigned)

Comments

[2005-02-03 22:54 UTC] dmoore at pbpost dot com

Description:
------------
The following works in a old redhat 6.2 with older PHP;

$sql="UPDATE tickets SET closed_date = '$closed_date', email = '$email', notes = '$notes', technotes = '$technotes', assigned = '$assigned', status = '$status', assigned = '$assigned', reqnu m = '$reqnum', repeat = '$repeat', ponum = '$ponum', vender = '$vender', reqtype = '$reqtype', installed = '$installed' WHERE uid = '$uid';";

/*Use the @ symbol here to suppress errors. Then
use your error checking code to handle it your own way*/

@$result_set = pg_Exec ($conn, $sql);

Expected result:
----------------
php to do a pgsql update.

there is a new pg_update but not sure how to use the syntax.

[2005-08-31 01:15 UTC] chriskl at familyhealth dot com dot au

pg_exec has long been deprecated in favour of pg_query.