using forms to add records to mysql database - block submit on entering

Hey,

I'm new to php and I'm trying to write some php code so that I can
insert data into a mysql database using html forms.

I've got two text forms and a submit button. When entering data and
selecting 'submit' a new record in my database is created. So far so
good... But when I enter data in only one content and hit the enter
key a new record is created with one empty field. And that something I
don't want to happen.

Is there a way to block the text-forms so only a record is added when
I hit the 'submit' button?

Re: using forms to add records to mysql database - block submit on entering

On 6 Sep, 14:19, dirk wrote:
> Hey,
>
> I'm new to php and I'm trying to write some php code so that I can
> insert data into a mysql database using html forms.
>
> I've got two text forms and a submit button. When entering data and
> selecting 'submit' a new record in my database is created. So far so
> good... But when I enter data in only one content and hit the enter
> key a new record is created with one empty field. And that something I
> don't want to happen.
>
> Is there a way to block the text-forms so only a record is added when
> I hit the 'submit' button?

This is an HTML forms question. Nothing to do with PHP.

Re: using forms to add records to mysql database - block submit on entering

On 6 sep, 15:40, Captain Paralytic wrote:
> On 6 Sep, 14:19, dirk wrote:
>
> > Hey,
>
> > I'm new to php and I'm trying to write some php code so that I can
> > insert data into a mysql database using html forms.
>
> > I've got two text forms and a submit button. When entering data and
> > selecting 'submit' a new record in my database is created. So far so
> > good... But when I enter data in only one content and hit the enter
> > key a new record is created with one empty field. And that something I
> > don't want to happen.
>
> > Is there a way to block the text-forms so only a record is added when
> > I hit the 'submit' button?
>
> This is an HTML forms question. Nothing to do with PHP.

Could be. Does this mean that you don't have the answer to this?

Re: using forms to add records to mysql database - block submit on entering

On Thu, 06 Sep 2007 16:08:35 +0200, dirk wrote:

> On 6 sep, 15:40, Captain Paralytic wrote:
>> On 6 Sep, 14:19, dirk wrote:
>>
>> > Hey,
>>
>> > I'm new to php and I'm trying to write some php code so that I can
>> > insert data into a mysql database using html forms.
>>
>> > I've got two text forms and a submit button. When entering data and
>> > selecting 'submit' a new record in my database is created. So far so
>> > good... But when I enter data in only one content and hit the enter
>> > key a new record is created with one empty field. And that something I
>> > don't want to happen.
>>
>> > Is there a way to block the text-forms so only a record is added when
>> > I hit the 'submit' button?
>>
>> This is an HTML forms question. Nothing to do with PHP.
>
> Could be.

Is so :P

> Does this mean that you don't have the answer to this?

Nobody HAS to, it's just far more likely you'll get a correct, speedy, and
friendly answer in alt.html for instance (or possibly comp.lang.javascript
in case user side scripting is needed).
--
Rik Wasmus

Re: using forms to add records to mysql database - block submit on entering

..oO(dirk)

>I'm new to php and I'm trying to write some php code so that I can
>insert data into a mysql database using html forms.
>
>I've got two text forms and a submit button. When entering data and
>selecting 'submit' a new record in my database is created. So far so
>good... But when I enter data in only one content and hit the enter
>key a new record is created with one empty field. And that something I
>don't want to happen.

Use your PHP script to check that all required values are there and
reject the form submission if something is missing. Show an error
message and the form with all previously entered values again.

>Is there a way to block the text-forms so only a record is added when
>I hit the 'submit' button?

No. Don't even try it. Fix it on the server.

Micha