2006/7/11, DCarrero <dcarreroc@gmail.com>:
> 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();