On 12/23/2016 07:44 AM, Alessandro Baggi wrote:
Hi list,
sorry for this OT.
I have a table on postgresql like this:
id serial not null,
srcaddr varchar(16) not null
I use this table to store ip address. I've used also inet type but
changed to see if this solves my problem.
From psql, I run:
select count(*) from bs_ipsource where srcaddr = '192.168.1.1';
and query is performed.
And what is the count?
From php I'm trying to do the same with this code:
$ipsrc = "192.168.1.1";
$query = pg_query_params($dbcon, "SELECT count(*) from bs_ipsource where
srcaddr = $1", array($ipsrc));
if(!$query) { print error...}
I don't understand why this query fails without error. I have searched
How do you know it fails?
error in httpd logs and postgresql log without success.
from postgresql logs i get:
LOG: execute <unnamed>: SELECT count(*) from bs_ipsource where srcaddr
= $1
DETAIL: parameters: $1 = '192.168.1.1'
I've tried also to use pg_last_error and errors are not printed.
Can someone put me on the right way?
Thanks in advance.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
