Database

Discussion in 'Web Design and Development' started by jsm4182, Sep 16, 2006.

  1. jsm4182 macrumors 6502

    Joined:
    Apr 3, 2006
    Location:
    Beacon, NY
    #1
    I'm working on a website and i need a way to integrate a database. I just need to simply have people enter data in a form and it gets posted in a database and possibly a page to give a summary of whats been posted in the database. Can anyone help or give a point to start working?
     
  2. MagicBez macrumors newbie

    Joined:
    Sep 13, 2006
    #2
    Here's how I would do it,

    First you will need to create the form in html, then a separate (doesn't have to be but it's easier if it is) php script that handels the form inputs, adding records to the sql database as it goes. There will be plenty of tutorials on writing a script to add records on somewhere like sitepoint. If this is user entered data pay particulat attention to security..you never know what people will try and put in a text box.

    There are also a few good forums out there for php/mysql integration,

    phpbuilder
    devshed

    also if you want to get a book about it I believe Larry Ul(l)man (sp?) wrote a rather good one that explains the basics very well. It's on peachpit press and is called something completely obvious like..learning php and mysql.

    Hope this helps a litte. Also be sure that your host allows for a mysql database to be set up and php scripts to run. If it does not I would recommend dreamhost (sign up with this link and I get some cash, http://www.dreamhost.com/donate.cgi?id=4318 )
     
  3. ValGor macrumors newbie

    Joined:
    Feb 20, 2005
    #3
    Macromedia Dreamweaver 8

    This piece of software has an ability to generate record insert , record update , record list php code automatically. You just select a mysql database and table...
    Nice for lazy people who don't want to write it all in text editor. And good starting point for looking at php->mysql code structure. Plus 30 days eval. version is there...

    Have Fun
     
  4. jsm4182 thread starter macrumors 6502

    Joined:
    Apr 3, 2006
    Location:
    Beacon, NY
    #4
    thanks for the response. Is this feature also in Dreamweaver MX2004?
     
  5. ValGor macrumors newbie

    Joined:
    Feb 20, 2005
    #5
    I am sorry, i don't really know anything about MX2004.

    Val
     
  6. mnkeybsness macrumors 68030

    mnkeybsness

    Joined:
    Jun 25, 2001
    Location:
    Moneyapolis, Minnesota
    #6
    What piece of software?
     
  7. ValGor macrumors newbie

    Joined:
    Feb 20, 2005
    #7
    Macromedia Dreamweaver 8
     

Share This Page