Re: entrance from php to postgresql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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


[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux