From: | Ângelo Marcos Rigo <angelo_rigo(at)yahoo(dot)com(dot)br> |
---|---|
To: | pgsql-php(at)postgresql(dot)org |
Subject: | Update script |
Date: | 2003-08-14 13:46:46 |
Message-ID: | 20030814134646.77797.qmail@web14805.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
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'";
$result = pg_query($db, $query);
if (!$result) {printf ("ERROR"); exit;}
print ("Estes valores foram atualizados:<P> -
$titulo<BR>- $texto<BR>");
pg_close($db);
?>
This is a snip from modificar_1.php
<?php
$id = $_POST['id'];
$titulo = $_POST['titulo'];
$texto = $_POST['texto'];
include 'db.php';
$query = "SELECT id, titulo, texto FROM table WHERE
id='$id'";
$result = pg_exec($db, $query);
if (!$result) {printf ("ERROR"); exit;}
$numrows = pg_numrows($result);
$row=0;
?>
<table border=0 style="border: 1px solid black;">
<?php
do {
$myrow = pg_fetch_row ($result, $row);
//print_r($myrow);
print ("<tr><td>ID</td><td>$myrow[0]</td></tr>");
print ("<tr><td>Título</td><td><input type=text
value=$myrow[1] name=titulo size=150
maxlength=150></td></tr>");
print ("<tr><td>Texto</td><td><textarea cols=90
rows=20 value=$myrow[2]
name=texto>$myrow[2]</textarea></td></tr>");
$row++;
}
while ($row < $numrows);
?>
Thanks in advance
=====
Â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(at)yahoo(dot)com(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Viorel Dragomir | 2003-08-14 13:57:41 | Re: Update script |
Previous Message | Lynna Landstreet | 2003-08-13 23:12:43 | Re: Paging results |