Re: Update script - Mailing list pgsql-php

From Ângelo Marcos Rigo
Subject Re: Update script
Date
Msg-id 20030815105352.63670.qmail@web14802.mail.yahoo.com
Whole thread Raw
In response to Re: Update script  (CoL <col@mportal.hu>)
List pgsql-php
Hi Col

Thank´s for the postgre version note
my problem was that i just forget the name=id atribute
in the textfield

Best regards


 --- CoL <col@mportal.hu> escreveu: > Hi,
>
>
> Ângelo Marcos Rigo wrote, On 8/14/2003 3:46 PM:
> > Hi
> >
> > I have a script to update some records in a
> postgresql
> > database. when i do modify what i have to modify
> it
> > give me the warning:
> >
> > Warning: pg_query() query failed: ERROR: pg_atoi:
> > zero-length string in
> > /var/www/html/adm/modificar_2.php on line 24
> > ERROR
> >
> > this is line 24:
> >     $result = pg_query($db, $query);
> >
> > this is modificar_2.php :
> >
> > <?php
> >     $id = $_POST['id'];
> >     $titulo = $_POST['titulo'];
> >     $texto = $_POST['texto'];
> >
> >     include 'db.php';
> >     $query = "UPDATE table SET titulo='$titulo',
> > texto='$texto' WHERE id='$id'";
> print $query; You will get:
> UPDATE table SET titulo='somthing',texto='text'
> WHERE id=''
>
> And your pg version is >= 7.2, where you can not
> insert '' string in
> integer type. cast $id as integer, '".($id+0)."' or
> intval or others.
>
> C.
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

=====
Ângelo Marcos Rigo
AMR Informática
(51) 3348 0870
Rua Pe. Alois Kades 400/210
Porto Alegre /RS/Brasil
http://amr.freezope.org
angelo_rigo@yahoo.com.br



_______________________________________________________________________
Conheça o novo Cadê? - Mais rápido, mais fácil e mais preciso.
Toda a web, 42 milhões de páginas brasileiras e nova busca por imagens!
http://www.cade.com.br

pgsql-php by date:

Previous
From: CoL
Date:
Subject: Re: Update script
Next
From: DeJuan Jackson
Date:
Subject: PHP and COPY