Checking return value of pg_query_params by PHP

Question

How can you check if a resource is false in PHP`s pg query params?

I run the following code unsuccessfully

 $row = pg_num_rows ( $result );
 if ( $row !== 0 )
        echo "hurray";
 else
        echo "argh";

It gives me the following warnings

Warning: pg_query_params() [function.pg-query-params]: Query failed: ERROR: invalid input syntax for integer: "" in /var/www/codes/index.php on line 120

I use $dbconn which is correct so the the second warning seems to be only a sympton. The cause of this is the invalid type for an integer.

My query is this

$dbconn = pg_connect("host=localhost port=5432 dbname=masi user=masi password=123");
$result = pg_query_params ( $dbconn,
    'SELECT question_id
    FROM questions
    WHERE question_id = $1',
    array ( $question_id )
);

Answer 1

Try this:

$result = @pg_query_params($dbconn, "SELECT * FROM SOME_TABLE", array());
if($result !== FALSE)
{
  $row = @pg_num_rows($result);
  if ( $row !== 0 )
         echo "hurray";
  else
         echo "argh";
}
else
{
  echo "Seems, your query is bad.";
}

Before you use $result, you need check it.

Answer 2

When you say "NULL query" I assume that you mean a query that does not affect or return any result rows.

Any successful query will always result in a valid query result resource, which will always be true, whether or not any rows have been affected/returned. To see whether the query was successfully applied to one or more rows you have to use either pg_affected_rows (UPDATE/INSERT/DELETE) or pg_num_rows (SELECT).