WEB Need help with a database

Discussion in 'OT Technology' started by Chris90210, Dec 14, 2007.

  1. Chris90210

    Chris90210 New Member

    Joined:
    Nov 7, 2004
    Messages:
    22,530
    Likes Received:
    0
    Location:
    Utah
    I am still pretty new in college majoring in Networking. Well I am apart of a OHV club and they want me to create a nice site(and since I am in college I should know every field that a computer is used for:hsugh:.... Thank god for people who know nothing about IT..... you are a god for anything that needs to be done.) . Well I have that out of the way but now they want a way for all of the officers to get online and be able to access a database to add/delete members. What do I need to do? They do not really care for the idea of me uploading a access and excel file with all members and adding them when needed. What do I need to do? What are my options?
     
  2. 95vr4

    95vr4 OT Supporter

    Joined:
    Oct 6, 2004
    Messages:
    2,513
    Likes Received:
    0
    Location:
    Weddington, NC
    Access would probably be your best bet for something this simple (mysql or mssql would be overkill). You can use asp to modify your access database. Google it, there's plenty of good tutorials out there for something simple like this. Make sure you have permissions correct on your mdb file.
     
  3. LOLZILLA

    LOLZILLA New Member

    Joined:
    Jul 11, 2004
    Messages:
    97,923
    Likes Received:
    0
    Access is absolute shit. Don't waste your time with that crap.

    mysql ftw.
     
  4. 95vr4

    95vr4 OT Supporter

    Joined:
    Oct 6, 2004
    Messages:
    2,513
    Likes Received:
    0
    Location:
    Weddington, NC
    It's fine for what he's doing and it's much simpler than getting a mysql server running and configured. It's one or two fields on one table, I say mysql is a waste of time there :hsugh:
     
  5. Chris90210

    Chris90210 New Member

    Joined:
    Nov 7, 2004
    Messages:
    22,530
    Likes Received:
    0
    Location:
    Utah
    I agree even though it would be fun to play with sql I really do not have the time. Basically my access file(that will be uploaded) is not as complex as the one I keep for myself.
     
  6. niwtsol

    niwtsol always question

    Joined:
    Nov 23, 2006
    Messages:
    456
    Likes Received:
    0
    well there is probably already a database that came with the hosting, so why not just do a sql one?
     
  7. Chris90210

    Chris90210 New Member

    Joined:
    Nov 7, 2004
    Messages:
    22,530
    Likes Received:
    0
    Location:
    Utah
    I do not know much about sql
     
  8. LOLZILLA

    LOLZILLA New Member

    Joined:
    Jul 11, 2004
    Messages:
    97,923
    Likes Received:
    0
    Srsly...


    That was my angle too.
     
  9. 95vr4

    95vr4 OT Supporter

    Joined:
    Oct 6, 2004
    Messages:
    2,513
    Likes Received:
    0
    Location:
    Weddington, NC
    Either way will be fine for what you're doing and there's plenty of good tutorials out there for both
     
  10. crazybenf

    crazybenf Active Member

    Joined:
    Nov 14, 2001
    Messages:
    15,575
    Likes Received:
    2
    The cheap and easy way?

    Setup a database with the required fields labelled clearly.

    Install phpmyadmin, populate with a few demo values... show them how to "edit" and "delete" rows. (dont give them full perms, just insert/sel/update)
     
  11. 95vr4

    95vr4 OT Supporter

    Joined:
    Oct 6, 2004
    Messages:
    2,513
    Likes Received:
    0
    Location:
    Weddington, NC
    ehh...u still gotta write a ui for the end user, easy enough to just go ahead and write a simple ui for admin too
     
  12. crazybenf

    crazybenf Active Member

    Joined:
    Nov 14, 2001
    Messages:
    15,575
    Likes Received:
    2
    no way.. just teach them how to use the edit and delete buttons in phpmyadmin, along with the search tab.


    The only tricky part is % as a wild card...
     

Share This Page