Re: entrance from php to postgresql

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();