Connecting Tech Pros Worldwide Forums | Help | Site Map

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

dirk
Guest
 
Posts: n/a
#1: Sep 6 '07
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?


Captain Paralytic
Guest
 
Posts: n/a
#2: Sep 6 '07

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


On 6 Sep, 14:19, dirk <dirkh...@gmail.comwrote:
Quote:
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.

dirk
Guest
 
Posts: n/a
#3: Sep 6 '07

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


On 6 sep, 15:40, Captain Paralytic <paul_laut...@yahoo.comwrote:
Quote:
On 6 Sep, 14:19, dirk <dirkh...@gmail.comwrote:
>
Quote:
Hey,
>
Quote:
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.
>
Quote:
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.
>
Quote:
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?

Rik Wasmus
Guest
 
Posts: n/a
#4: Sep 6 '07

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


On Thu, 06 Sep 2007 16:08:35 +0200, dirk <dirkheld@gmail.comwrote:
Quote:
On 6 sep, 15:40, Captain Paralytic <paul_laut...@yahoo.comwrote:
Quote:
>On 6 Sep, 14:19, dirk <dirkh...@gmail.comwrote:
>>
Quote:
Hey,
>>
Quote:
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.
>>
Quote:
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.
>>
Quote:
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
Quote:
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
Michael Fesser
Guest
 
Posts: n/a
#5: Sep 6 '07

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


..oO(dirk)
Quote:
>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.
Quote:
>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
Closed Thread