| From: | Alessandro Baggi <alessandro(dot)baggi(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | [OT] Postgresql and PHP |
| Date: | 2016-12-23 15:44:33 |
| Message-ID: | 7f7bb3fa-3499-e083-07d4-86fe422cd3a5@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
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
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2016-12-23 15:51:09 | Re: [OT] Postgresql and PHP |
| Previous Message | Tom Lane | 2016-12-23 15:15:21 | Re: Bug? Netmask of CIDR as TEXT has trailing masklen |