note 70129 added to function.pg-query-params

If you are trying to replicate the function pg_query_params, you might also want to support NULL values. While is_int returns true for a NULL value, the formatting for the SQL. function pg_query_params( $db, $query, $parameters ) { // Escape parameters as required & build parameters for callback function global $pg_query_params__parameters; foreach( $parameters as $k=>$v ) { if ( is_null($v) ) { $parameters[$k] = 'NULL'; } else { $parameters[$k] = ( is_int( $v ) ? $v : "'".pg_escape_string( $v )."'" ); } } $pg_query_params__parameters = $parameters; // Call using pg_query return pg_query( $db, preg_replace_callback( '/\$([0-9]+)/', 'pg_query_params__callback', $query)); } ---- Server IP: 216.194.113.175 Probable Submitter: 24.98.248.10 ---- Manual Page -- http://www.php.net/manual/en/function.pg-query-params.php Edit -- https://master.php.net/note/edit/70129 Del: integrated -- https://master.php.net/note/delete/70129/integrated Del: useless -- https://master.php.net/note/delete/70129/useless Del: bad code -- https://master.php.net/note/delete/70129/bad+code Del: spam -- https://master.php.net/note/delete/70129/spam Del: non-english -- https://master.php.net/note/delete/70129/non-english Del: in docs -- https://master.php.net/note/delete/70129/in+docs Del: other reasons-- https://master.php.net/note/delete/70129 Reject -- https://master.php.net/note/reject/70129 Search -- https://master.php.net/manage/user-notes.php