[OT] Postgresql and PHP

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: Raw Message | Whole Thread | 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.

Responses

Browse pgsql-general by date

  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