SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    SitePoint Member
    Join Date
    Dec 1999
    Location
    Middlebury, CT, USA
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm looking to create and manage a simple online database. I need to have some kind of web based form interface where I could add, view and update items. I've been tearing my hair out trying to do it in Access. Does anyone know of any resources that could point me in the right direction? Am I wrong for trying to do it in Access? Should I be looking for a shrink-wrapped perl or cgi application? Thanks in advance for you help!

    kirk

  2. #2
    Just Blow It bronze trophy
    DaveMaxwell's Avatar
    Join Date
    Nov 1999
    Location
    Mechanicsburg, PA
    Posts
    7,267
    Mentioned
    116 Post(s)
    Tagged
    1 Thread(s)
    What type of environment are you using? It is relatively easy to do in ASP if you're site is on a NT machine. I would assume the same would be true for PHP on a UNIX site, but I'm not too sure of that since I have no experience with that.

    What type of environment are you using? I think that will enable people to help you more as it will enable those with certain areas of expertise to be able to step up and help you.



    ------------------
    Dave Maxwell
    www.keystonecapitalchorus.org
    www.trademarkquartet.com

  3. #3
    SitePoint Member
    Join Date
    Dec 1999
    Location
    Middlebury, CT, USA
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm currently using a LINUX server. I do have access to an NT box though, if that would mean an easier setup.

  4. #4
    SitePoint Guru Vincent Puglia's Avatar
    Join Date
    Feb 2000
    Location
    where the World once stood
    Posts
    700
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    There's a database forum at: http://www.webmaster-forums.com
    People there are knowledgeable about access, but will try to steer you towards some form of sql (whether you need it or not).
    Also, if your dbms needs are very simple, you can consider a simple flatfile dbms, using javascript & perl.

    Vinny


    ------------------
    GrassBlade: cut&paste javascript

  5. #5
    SitePoint Addict
    Join Date
    Feb 2000
    Location
    District of Columbia
    Posts
    373
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I just did one like that in Access/SQL/ColdFusion. I would guess that on Linux you are probably better off with something like PHP. (I'd love to gove more advice, but I'm just learning it)

  6. #6
    SitePoint Zealot
    Join Date
    Nov 1999
    Location
    Manhattan!
    Posts
    107
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    I use php and mySQL a lot on my site. The only tricky part in getting it to work is installing the software on the server (installing anything on Linux is always an issue...).

    If you host your own site, then there is a how-to at http://www.linuxnewbie.org/nhf/intel...hp_apache.html that deals with the installation of the above software.

    If you are on a hosted site, ask your provider if you have access to php and mySQL.

    Once you hace the software installed, writing the scripts to connect to the DB is a piece of the proverbial cake.

    More info on php can be found at: http://www.php.net http://www.phpbuilder.com
    any many other places.

    Christian

  7. #7
    SitePoint Member
    Join Date
    Dec 1999
    Location
    Middlebury, CT, USA
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the help guys, much apprieciated!

  8. #8
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    And of course watch for SitePoint's weekly series on database-driven site design using PHP and MySQL beginning in the next two weeks!


    ------------------
    -Kevin Yank.
    http://www.SitePoint.com/
    Helping Small Business Grow Online!


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •