php - pg_query 有效但 pg_query_params 无效

Question

多年来我一直在努力解决这个问题，但我似乎无法弄清楚哪里出了问题。

这按预期工作:

$query = "SELECT DISTINCT(name) FROM customers WHERE name IS DISTINCT FROM NULL ORDER BY name ASC";
$result = pg_query($dbconn, $query);

但这根本行不通。它甚至不返回 false。渲染之后什么也没有。

$query = "SELECT DISTINCT(name) FROM customers WHERE name IS DISTINCT FROM $1 ORDER BY name ASC";
$result = pg_query_params($dbconn, $query, $array(NULL));

我正在使用 PHP 5.3 和 Postgresql 8.4。

Answer 1

$query = "SELECT DISTINCT(name) FROM customers WHERE name IS DISTINCT FROM $1 ORDER BY name ASC";
$result = pg_query_params($dbconn, $query, $array(NULL));
                                           ^
                                           ^

你的意思是 pg_query_params(..., array(NULL)) 而不是。