X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1918FD1B4E6 for ; Fri, 24 Oct 2003 22:43:29 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 87521-02 for ; Fri, 24 Oct 2003 19:42:59 -0300 (ADT) Received: from mail1.ihs.com (mail1.ihs.com [170.207.70.222]) by svr1.postgresql.org (Postfix) with ESMTP id B4A68D1B51B for ; Fri, 24 Oct 2003 19:42:56 -0300 (ADT) Received: from css120.ihs.com (css120.ihs.com [170.207.105.120]) by mail1.ihs.com (8.12.10/8.12.10) with ESMTP id h9OMfpLD001100; Fri, 24 Oct 2003 16:41:51 -0600 (MDT) Date: Fri, 24 Oct 2003 16:30:01 -0600 (MDT) From: "scott.marlowe" To: Martin Marques Cc: Robby Russell , Stephen , Subject: Re: Support for prepared queries In-Reply-To: <200310241850.56494.martin@bugs.unl.edu.ar> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=ISO-8859-1 Content-Transfer-Encoding: 8BIT X-IHS-MailScanner: Found to be clean X-IHS-MailScanner-SpamCheck: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/22 X-Sequence-Number: 2383 On Fri, 24 Oct 2003, Martin Marques wrote: > El Vie 24 Oct 2003 15:02, Robby Russell escribió: > > Stephen wrote: > > > Hi, > > > > > > Does anyone know if PHP supports prepared queries for PostgreSQL 7.3.x ? > If > > > not, when will prepared queries be supported? > > > > > > Thanks, Stephen > > > > > > > You might want to look at PEAR db. I think it comes with php standard > > now... so pear.php.net. > > Those are not prepared queries (at least in the sence of prepare -> execute). > For prepared queries you have to know how to talk to libpq, and that's > something that is done from the pgsql ext. This hunk of code works fine on my php 4.3.2 / postgresql 7.3.4 box: "; ?> so yes, you can use a prepared queries in PHP. But, they won't live across connections I don't think. Or at least I'm pretty sure you can't count on them living from one page to the next. but if you're gonna have a page where you run the same select with different select parameters over and over it might be a win.