X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A10B253FA2 for ; Thu, 28 Apr 2005 07:53:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 71133-01 for ; Thu, 28 Apr 2005 10:53:33 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.200]) by svr1.postgresql.org (Postfix) with ESMTP id 7124353EE7 for ; Thu, 28 Apr 2005 07:53:32 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 68so602912wri for ; Thu, 28 Apr 2005 03:53:35 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=fF5VzEm5Srsx1++QCXAHU0grW8JckvjbBg7jlH9Ju1jzyMVgf4naoz2KXss90tiwE6kiAm5OIi68dKYZ4zP5IY/HtAVGkDuVmYzGtPSLsYluxkdeweuGORjvQP2Uj0vlG18msExkWIJ7SEcmtSza9lT6wdix0qAF4sinvAD9sbA= Received: by 10.54.121.14 with SMTP id t14mr674435wrc; Thu, 28 Apr 2005 03:53:35 -0700 (PDT) Received: by 10.54.30.31 with HTTP; Thu, 28 Apr 2005 03:53:35 -0700 (PDT) Message-ID: <7104a7370504280353ff053cf@mail.gmail.com> Date: Thu, 28 Apr 2005 13:53:35 +0300 From: Volkan YAZICI Reply-To: Volkan YAZICI To: pgsql-php@postgresql.org Subject: Does php/postgres support placeholder's? In-Reply-To: <7104a73705042714542c1131c2@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <7104a73705042714542c1131c2@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.301 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/30 X-Sequence-Number: 3114 Hi, On 4/27/05, John Mohr wrote: > Does php/postgres support placeholder's in queries and updates. Something > that looks like "select * from x where key=3D?" ? I think you meant parameters by "placeholders". For example: INSERT INTO tbl (f1, f2, f3...) VALUES ($1, $2, $3, ...); SELECT count(oid) FROM tbl WHERE field =3D $1; AFAIC, PHP PostgreSQL API doesn't support any X_params() functions. (Seems like stucked in escapeThatBuggyString() functions.) > I notice that the call > interface doesn't support all of the documented calls, for example pg_que= ry > and pg_send_query, but not pg_query_params (according to pgsql.c, the > postgres php -> postgres interface program). Some of the functions I found that don't exist in both latest release and CVS tree: pg_prepare() pg_query_params() pg_field_type_oid() pg_send_prepare() pg_send_query_params() (CVS checkout for ext/pgsql/pgsql.c: http://cvs.php.net/co.php/php-src/ext/pgsql/pgsql.c?r=3D1.244.2.38) Also, async query functions' interface is new as well. (Committed @ "Sat Mar 19 03:46:55 2005" Related diff: http://cvs.php.net/php-src/ext/pgsql/pgsql.c?r1=3D1.315&onb=3D0) Regards.