[KJdesign]

Hello!


Right i am fairly new with web stuff, i dabbled with it a fair bit over the past year, but now just help friends out with their sites occaisionally.

I am helping a friend with his music production website...

What i need is the following:

An online form with various text fields: Name, Age, Country, Location, Email Address, Do you dj?

Then this information needs to be submitted to some sort of online database where it can be stored and viewed by administrators.

How would i go about doing this, the best, easiest and most reliable way?

Thanks very much

Kj

[Advertisements]

Hello!
Right i am fairly new with web stuff, i dabbled with it a fair bit over the past year, but now just help friends out with their sites occaisionally.

I am helping a friend with his music production website...

What i need is the following:

An online form with various text fields: Name, Age, Country, Location, Email Address, Do you dj?

Then this information needs to be submitted to some sort of online database where it can be stored and viewed by administrators.

How would i go about doing this, the best, easiest and most reliable way?

Thanks very much

Kj

Hello!

The form is the easy part. Use a basic HTML form like this:

<FORM METHOD=post ACTION="/cgi-bin/input.cgi">
<INPUT type="text" size="10" maxlength="30">
<INPUT type="Submit" VALUE="Submit">
</FORM>

or something like this would email the input to wherever you specify:

<FORM action="mailto:[email protected]">
Name: <INPUT name="Name" value="" size="10"><BR>
Email: <INPUT name="Email" value="" size="10"><BR>
<CENTER><INPUT type="submit"></CENTER>
</FORM>

or try this:

<FORM METHOD="POST" ACTION="/cgi-bin/input.cgi">
<PRE>
First Name <INPUT TYPE="text" NAME="fname" MAXLENGTH=15 SIZE=15>
Last Name <INPUT TYPE="text" NAME="lname" MAXLENGTH=20 SIZE=20>
E-Mail Addr <INPUT TYPE="text" NAME="email" MAXLENGTH=35 SIZE=35>
<INPUT TYPE="submit" VALUE="Send Mail!">
<INPUT TYPE="reset" value=" Clear-Form">
</PRE>
</FORM>


You'll want to set the path to your CGI script properly in the action attribute. Just save an empty input.cgi file somewhere on your site and add in the address. You can add pretty much anything to a line, location, age, etc...Do an internet search for cgi scripting or cgi processing forms for more detailed info. There are a lot of free sites.

I am not aware of a good program to help you with this, but there is a ton of free info available online. Good luck, maybe another member here will have a site you could check out?

[katkat92]

Hello!
Right i am fairly new with web stuff, i dabbled with it a fair bit over the past year, but now just help friends out with their sites occaisionally.

I am helping a friend with his music production website...

What i need is the following:

An online form with various text fields: Name, Age, Country, Location, Email Address, Do you dj?

Then this information needs to be submitted to some sort of online database where it can be stored and viewed by administrators.

How would i go about doing this, the best, easiest and most reliable way?

Thanks very much

Kj

Hello!

The form is the easy part. Use a basic HTML form like this:

<FORM METHOD=post ACTION="/cgi-bin/input.cgi">
<INPUT type="text" size="10" maxlength="30">
<INPUT type="Submit" VALUE="Submit">
</FORM>

or something like this would email the input to wherever you specify:

<FORM action="mailto:[email protected]">
Name: <INPUT name="Name" value="" size="10"><BR>
Email: <INPUT name="Email" value="" size="10"><BR>
<CENTER><INPUT type="submit"></CENTER>
</FORM>

or try this:

<FORM METHOD="POST" ACTION="/cgi-bin/input.cgi">
<PRE>
First Name <INPUT TYPE="text" NAME="fname" MAXLENGTH=15 SIZE=15>
Last Name <INPUT TYPE="text" NAME="lname" MAXLENGTH=20 SIZE=20>
E-Mail Addr <INPUT TYPE="text" NAME="email" MAXLENGTH=35 SIZE=35>
<INPUT TYPE="submit" VALUE="Send Mail!">
<INPUT TYPE="reset" value=" Clear-Form">
</PRE>
</FORM>


You'll want to set the path to your CGI script properly in the action attribute. Just save an empty input.cgi file somewhere on your site and add in the address. You can add pretty much anything to a line, location, age, etc...Do an internet search for cgi scripting or cgi processing forms for more detailed info. There are a lot of free sites.

I am not aware of a good program to help you with this, but there is a ton of free info available online. Good luck, maybe another member here will have a site you could check out?

[KJdesign]

Hi there, thankyou for your response; sorry to sound dumb, but cgi, would that store it to a database once the user has submitted the information?

Thanks

[TaNkZ101]

in my opinion it would be easiest using mysql but for that you need a mysql database and i don't think they're free (legally).

[ScHwErV]

MySQL is free.

Microsoft SQL server is not.

[KJdesign]

I dont mind spending £ if its gonna cost

[TDXkev]

This is dependent on what your host supports and what features are available.

What does your host offer? In terms of database support, page support (asp, php, etc).

Once you know that, you can then determine how you want to go about implementing your idea.

[KJdesign]

It supports most things, MySql, asp, php,

[TDXkev]

If you're using php and mysql, here is a tutorial that I think will help you out:

http://webmonkey.wir.../tutorial4.html

It looks like Lesson 2 would be what you are looking for. (disclaimer: I didn't read the whole thing, but I skimmed it and I think it would help you out)

Let me know if that helps, good luck!