Re: PHP and inet data type
Seems like the cleanest answer would be to
teach PHP about inet data
type (not to mention other extension types).
I'd like to do that, but I don't even know
where to begin.
I am currently using 'inet' fields in an
application that uses PHP 3.0.14, and it
works fine, e.g:
select session_ip from acct where session_ip is not null;
pg_FieldType() says the column is 'inet' and the results print like this w/o any special effort:
10.0.0.3
10.0.0.4
10.0.0.54
10.0.0.158
Updates work just as easily:
if (! ($update = pg_exec( $conn,
"update acct set session_ip = '$REMOTE_ADDR', \
last_login = 'now'::text where account = $data[0]")))
Join 18 million Eudora users by signing up for a free Eudora Web-Mail account at http://www.eudoramail.com
On Wed, Jun 07, 2000 at 11:47:49AM -0700, K Parker wrote:
Seems like the cleanest answer would be to
teach PHP about inet data
type (not to mention other extension types).I'd like to do that, but I don't even know
where to begin.I am currently using 'inet' fields in an
application that uses PHP 3.0.14, and it
works fine, e.g:
Hmm. PHP complained when I did it, claiming it didn't support that data
type. Thanks for this, though. It must be more incompetence on my part.
I'm getting tired of learning from experience!
--
Andrew Sullivan Computer Services
<sullivana@bpl.on.ca> Burlington Public Library
+1 905 639 3611 x158 2331 New Street
Burlington, Ontario, Canada L7R 1J4
just a curiosity question...is the pg_FieldType() function
something you wrote yourself? i was unable to find it and,
as i'm new to postgres, want to know everything yesterday... :)
mikeo
pg_FieldType() says the column is 'inet' and the results print like
this w/o any special effort:
10.0.0.3
10.0.0.4
10.0.0.54
10.0.0.158Updates work just as easily:
if (! ($update = pg_exec( $conn,
"update acct set session_ip = '$REMOTE_ADDR', \
last_login = 'now'::text where account = $data[0]")))Join 18 million Eudora users by signing up for a free Eudora Web-Mail
account at http://www.eudoramail.com
