From: | CoL <col(at)mportal(dot)hu> |
---|---|
To: | pgsql-php(at)postgresql(dot)org |
Subject: | Re: Update script |
Date: | 2003-08-14 23:22:32 |
Message-ID: | bhh5fj$1jua$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Ângelo Marcos Rigo | 2003-08-15 10:53:52 | Re: Update script |
Previous Message | David Busby | 2003-08-14 20:07:19 | Re: Update script |