Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to insert data from site into DB?

0 views
Skip to first unread message

LoobieLouLou

unread,
Dec 20, 2006, 11:21:40 AM12/20/06
to
Hi
Does anyone know how to insert data into a database from a website?
I have created a Registration form for users to register to my web site. With
this I would like the data they have entered to be stored in a MySQL database.
I have created the a form and used the record insertion form wizard. When I
inserted a form, I enetered a name and the method was POST, but it also needed
an action. How do I write in java that it needs to be inserted into the
database?
But when I press on the submit button, it goes to a page saying the website
declined to show this page. The most likely cause is the website requires you
to log in.
What am I doing wrong?
The database is set up correctly, however the log in information is not
storing but I want them to register first then log in every time they come to
the site.
If anyone could help, it would be greatly appreciated,
thanks Lou.

LoobieLouLou

unread,
Dec 20, 2006, 6:12:14 PM12/20/06
to
Would I insert the following statement:-

String insert = "INSERT INTO people(firstname, lastname, email, password)
VALUES(?,?,?,?)";

But where would I place it in the code, so it inserts the data into the db
when I click on the submit button?

Thanks Lou

0 new messages