/    Sign up×
Community /Pin to ProfileBookmark

Form submit to database

Copy linkTweet thisAlerts:
Apr 21.2009

Hello. I posted a question a few weeks ago that was never answered. I thought that it was a simple question and common practice, so I’m going to try again but in different wording.

I designed a web form for people to signup for my businesses’ service and I need it to copy/post all the submitted inputted form data from the user to a database (preferably Access because I know it pretty well, and very new to SQL). I read through most of w3schools.com website several times but still couldn’t figure how to post to a database. What I understood from w3schools.com is how to have that information redisplay to the user on the next page, but how do I save the inputted data and access it for processing later?

to post a comment
HTML

3 Comments(s) ↴

Copy linkTweet thisAlerts:
@TheBearMayApr 21.2009 — What language are you using on the server (i.e. JAVA, ASP.Net, PHP)? If you don't have anything available server side, then you'll probably have to resort to opening up their email client with the data and asking them to hit their email client's send button.
Copy linkTweet thisAlerts:
@jburattiauthorApr 22.2009 — I use Yahoo as my host and they support PHP and SQL but not ASP. So to answer your question I would be using PHP, but I dont know it very well yet.
Copy linkTweet thisAlerts:
@eCatApr 23.2009 — Creating a form that connects to a database is not "simple" - I'm not sure about "common practice" either!

You have use use a language like PHP to code your form fields so that they correspond to database fields; then you have to build your database with something like MySQL; then you have to write the code that connects your form to the database; then you have to use phpMyAdmin (or something like that) to access the information that gets stored in the db.

If you have time & want to learn, I would suggest browsing the PHP/MySQL forums that are on this site.

Or, you could use software designed for such a thing:

http://www.webdeveloper.com/forum/showthread.php?t=186519 ?

There are many other products out there but most of them only do one part of the "package" (that being form, database & admin module). You can do a google search.

Good luck!

eCat
×

Success!

Help @jburatti spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.27,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...