Re: PHP form Creates Blank DB entries

[Frank Bax <fbax@xxxxxxxxxxxx>]

At 12:16 PM 6/30/03, Michael Hanna wrote:
> // error checks on form submission go here
> // generate and execute a query
> $query = "INSERT INTO addressbook VALUES (nextval('addressbook_id_seq'), 
> '$name', '$address', '$tel', '$email')";
> $result = pg_query($connection, $query)
>         or die("Error in query: $query. " . pg_last_error($connection));
> echo "Data successfully added.";
> // close database connection
> pg_close($connection); } ?>


Probably because "register globals" is off (default changed since 4.2.0).
        http://ca3.php.net/register_globals

Insert the following lines before "$query = ..." line:

$name = $_POST[name];
$address = $_POST[address];
$tel = $_POST[tel];
$email = $_POST[email];