Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

help please.. asp / php / database / online form related


  • Please log in to reply

#1
KJdesign

KJdesign

    New Member

  • Member
  • Pip
  • 8 posts
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
  • 0

Advertisements


#2
katkat92

katkat92

    Member

  • Member
  • PipPipPip
  • 165 posts

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:you@yourdomain.com">
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. :whistling:

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?
  • 0

#3
KJdesign

KJdesign

    New Member

  • Topic Starter
  • Member
  • Pip
  • 8 posts
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
  • 0

#4
TaNkZ101

TaNkZ101

    Member

  • Member
  • PipPipPip
  • 327 posts
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).
  • 0

#5
ScHwErV

ScHwErV

    Member 5k

  • Retired Staff
  • 21,285 posts
  • MVP
MySQL is free.

Microsoft SQL server is not.
  • 0

#6
KJdesign

KJdesign

    New Member

  • Topic Starter
  • Member
  • Pip
  • 8 posts
I dont mind spending £ if its gonna cost
  • 0

#7
TDXkev

TDXkev

    Member

  • Member
  • PipPip
  • 24 posts
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.
  • 0

#8
KJdesign

KJdesign

    New Member

  • Topic Starter
  • Member
  • Pip
  • 8 posts
It supports most things, MySql, asp, php,
  • 0

#9
TDXkev

TDXkev

    Member

  • Member
  • PipPip
  • 24 posts
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! :whistling:
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP