Create a form > Submit info > Collects in dB

Discussion in 'MySQL' started by KDAL2007, Sep 15, 2007.

  1. #1
    I've NEVER been successful at creating a custom database...

    I've tried tutorials and didn't get too far, and would like some help.

    I have a website where I have a simple form:

    First name:
    Last name:
    Email Address:
    City:
    State:
    Did you like our event? Yes/No
    Comments: [client writes in description]

    Now when they click submit I want the form to access a database that I create where it inputs the info into the database... Then whenever I want I can access the dB and pull up the info.

    Can anyone help an idiot out?

    Thanks guys! I do not want to buy or use a freeware program. I want to learn it and do it myself. I know I have to create a dB, insert the fields n stuff? and somehow link it all together.

    Any really "in-depth" tutorials?
     
    KDAL2007, Sep 15, 2007 IP
  2. JenniP

    JenniP Peon

    Messages:
    250
    Likes Received:
    15
    Best Answers:
    0
    Trophy Points:
    0
    #2
    To do this you will need some kind of server side code such as PHP or ASP/ASP.NET, and of course you will need a database.

    If you are already using one of these let us know which server side language you are using and which database and I'm sure someone will be able to help you.

    Jen
     
    JenniP, Sep 15, 2007 IP
  3. litebulb1

    litebulb1 Peon

    Messages:
    151
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I have used php with mysql. you should check out the companion website for the book 'php and mysql for dynamic websites'. the site has all the scripts that the book goes through. it demonstrates many scripts that are do exactly what your looking for.
     
    litebulb1, Sep 15, 2007 IP
  4. azoundria

    azoundria Member

    Messages:
    38
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #4
    Do you have PHP on your server? What about PHPmyAdmin? Have you created a database yet? Each database holds multiple tables.
     
    azoundria, Sep 15, 2007 IP
  5. KDAL2007

    KDAL2007 Peon

    Messages:
    127
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Yep all of my sites use PHP, MySQL and have phpMyAdmin
     
    KDAL2007, Sep 16, 2007 IP