Discussion:
How to insert data from site into DB?
(too old to reply)
LoobieLouLou
2006-12-20 16:21:40 UTC
Permalink
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
2006-12-20 23:12:14 UTC
Permalink
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

Loading...