X-Original-To: pgsql-php-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B54A09FB3A8 for ; Tue, 11 Jul 2006 18:38:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 38966-04 for ; Tue, 11 Jul 2006 18:38:39 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.178]) by postgresql.org (Postfix) with ESMTP id 321189FB39C for ; Tue, 11 Jul 2006 18:38:38 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id b36so4042369pyb for ; Tue, 11 Jul 2006 14:38:37 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=gp7lzS8lTHrQk4QYlLzwQH0uJKCqq2ca4q0vc80JEf0+RH0Uiqo+6e8t93d+tTj38uTXkbrdn7rC6+lSnSn+22ahR5uGB4SbJXG1rcBHpE8zBc2WDCEbaokbvkunJlL+nZj+y7OcDhFKFaBkE6k2q9lwAUnf6Wf6TYD7fxt4s7U= Received: by 10.35.106.15 with SMTP id i15mr7203529pym; Tue, 11 Jul 2006 14:38:37 -0700 (PDT) Received: by 10.35.68.16 with HTTP; Tue, 11 Jul 2006 14:38:37 -0700 (PDT) Message-ID: <5887d1f40607111438m2ad6553dh97cf944680c0dab9@mail.gmail.com> Date: Tue, 11 Jul 2006 17:38:37 -0400 From: DCarrero To: "John DeSoi" Subject: Re: entrance from php to postgresql Cc: pgsql-php@postgresql.org In-Reply-To: <5887d1f40607111350x6c9be991r3af87942591f895@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <5887d1f40607110739g6de31636n8a6a18d7159cc646@mail.gmail.com> <2D22D53B-4658-4976-B26D-41279B229350@pgedit.com> <5887d1f40607111023n6d95d0a4r8d0a2658800bd2ef@mail.gmail.com> <7EFA12A7-3CC7-49CC-AF2C-6AC681B33F7C@pgedit.com> <5887d1f40607111049i545d7207u284ed61b5934b31d@mail.gmail.com> <5887d1f40607111350x6c9be991r3af87942591f895@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/7 X-Sequence-Number: 3561 2006/7/11, DCarrero : > Hi again... > I'm confused > I have this table: > CREATE TABLE jugeninno > ( > nrt_nino rut NOT NULL, > dgv_ninno char(1), > nom_ninno varchar(50), > ape_ninno varchar(50), > num_mesna int4, > num_annon int4, > gls_sexo char(1), > nrt_adult varchar(10), > dgv_adult char(1), > nom_adult varchar(50), > gls_domic varchar(50), > num_orgso int4, > flg_inclu char(1), > CONSTRAINT jugeninno_pkey PRIMARY KEY (nrt_nino) > ) > > Then in php a query like this??? > $query="PREPARE agregar_data(varchar(10), char(1), varchar(50), > varchar(50), int4, int4, char(1), varchar(10), char(1), > varchar(50), varchar(50), int4, char(1)) AS > INSERT INTO jugeninno(nrt_nino, dgv_ninno, nom_ninno, ape_ninno, > num_mesna, num_annon, gls_sexo, > nrt_adult, dgv_adult, nom_adult, gls_domic, num_orgso, flg_inclu) > VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13);" > > take the post variables and execute with pg_execute() > > pg_execute ($conn1,"select > agregar_data($rutninno,$dgvninno,$nomninno,$apeninno, > $nummesna,$numannona,$glssexo,$nrtadult,$dgvadult,$nomadult,$glsdomic, > $numorgsoc,$flginclu);"); > This is ok??? > After what???? > Is not better pg_prepare(); ??? and later pg_execute();