Google Answers Logo
View Question
 
Q: Webs form to Database ( No Answer,   5 Comments )
Question  
Subject: Webs form to Database
Category: Computers > Internet
Asked by: steven1010-ga
List Price: $2.50
Posted: 14 Oct 2005 16:14 PDT
Expires: 13 Nov 2005 15:14 PST
Question ID: 580405
How do I setup a webform that records the results in a database on my site ? 
I can create the form but am unsure on what to do after that ?
Answer  
There is no answer at this time.

Comments  
Subject: Re: Webs form to Database
From: drakewla-ga on 14 Oct 2005 16:40 PDT
 
Your form has to be sent to a server application or script that will
get the results then will process it by addind the records into a
database. The language will depend on the technology used (PHP, ASP,
Java, ...) and the database (SQL Server, Oracle, MySQL, ...); so
there's no generic answer.
Subject: Re: Webs form to Database
From: sunith-ga on 14 Oct 2005 16:41 PDT
 
Using some kind server side scripting languages(JSP,ASP) recieve the
Data submited by the form and insert into database. To achieve this
you need a server capable for executing JSP or ASP and database
(MS-ACCESS, ORACLE etc..)
Subject: Re: Webs form to Database
From: fredericanand-ga on 15 Oct 2005 04:31 PDT
 
Hi stevan,

1. You need to validate the form (whether all the mandatory fields are entered).
2. Save the details in the Text file/xml/
   OR using Jsp U CAN SAVE THE DATA IN THE DATABASE ORACLE/MDB.

if u need more help reply me.

Regards
Frederic Anand.
Subject: Re: Webs form to Database
From: pensadyne-ga on 17 Oct 2005 13:43 PDT
 
At a conpetual level, you will need to take the form values, connect
to a database and then add a new record into this database - with the
rcord containg the form values.

There are many ways to back-end your website with a database.  Here is
an example of using something called Cold Fusion from Macromedia. The
Cold Fusion server is "known" tp the web server in that whenever the
web server encounters a file with the suffix ".cfm", the web server
passes the file to the Cold Fusion server. The Cold Fusion server then
processes the contents of that file and executes any instructions
found within. The Cold Fusion server in turn connects to many types of
databases - dBase, Foxpro, Oracle, etc.

Here's an example of a simple form called updateRecord.cfm to update a
record about a book in a database - nothing too special, looks like
your normal html markup:

   <form action=updateIt.cfm method=post>
      title: <input type=text name=title maxlength=250 size=20><p>
      Author: <input type=text name=author maxlength=75 size=20><p>
      Publisher: <input type=text name=publisher maxlength=100 size=20><p>
      Cost: <input type=text name=cost maxlength=6 size=6><p>
      Copies: <input type=text name=copies maxlength=3 size=3><p>
      <input type=submit value=enter>
      <input type=reset value=clear>
   </form>

So when someone enters the various field values and clicks on the
submit button, the form values will be passed to the updateIt.cfm file
which in turn is executed by the Cold Fusion server.

The updateIt.cfm file looks like the following - any tag starting with
"<cf" is a Cold Fusion markup tag and will be executed by the Cold
Fusion server. The comments should help explain what's going on:

   <!-- "datasource" refers to a database definition previously       -->
   <!-- setup within the Cold Fusion server admnistration interface.  -->
   <!-- This database is made up of one table and "n" records in that -->
   <!-- table. Each record has the fields, "title", "author",         -->
   <!-- "publisher", "copies" and "cost".                             -->
   <!-- Find the book we want to update based on the name of the book.-->
   <cfquery name="dbase" datasource="books">
      select * from books
      where title="#form.title#"
   </cfquery>

   <!-- Obtain form variable values and set the field values for a    -->
   <!-- record. Then update the record with the new values.           -->
   <cfquery name="dbase" datasource="books">
      update books
      set title="#form.title#",
         author="#form.author#",
         publisher="#form.publisher#",
         copies=#form.copies#,
         cost=#form.cost#
      where title="#form.title#"
   </cfquery>

The above is just one way in which you can back-end your website with
a database. Most ISP providers will provide packaged solutions that
will get you going relativley quickly.

Hope this helps.
Subject: Re: Webs form to Database
From: dmsoft-ga on 15 Apr 2006 01:22 PDT
 
Hello,

You can design database and forms in MS Access and then port them to 
PHP scripts and set up MySQL as a back-end
Look at http://www.data-conversions.net/access-forms-to-web-converter.html

I hope it will help 

Regards,
Dmitry

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy