Divine2aT has asked for the wisdom of the Perl Monks concerning the following question:

This node falls below the community's minimum standard of quality and will not be displayed.
  • Comment on Help with creating Web Database Frontend

Replies are listed 'Best First'.
Re: Help with creating Web Database Frontend
by Improv (Pilgrim) on Apr 26, 2003 at 13:38 UTC
    Ok, here's a cooking list. I'll assume we're starting from scratch:
    • Linux
    • Apache
    • Postgres 7.2 or 7.3 (incl with recent redhat)
    Let's create the database..
      serious ++Improv - what a star. I hereby swallow all my words about "possible volunteers" - and email support to boot! :)
      Cheers,
      Ben
      Thankyou Iprov I will take you up on the offer I emailed you seperately just incase you didn't get the email I will post a copy here for you. Hi this is Tina aka Divine2aT Can you put this up for me if I give you the web URL and Permission to use the file server ect. to my web page. I am scared I don't want to mess everything up. I do not no how to wright scripts like this and I am really bad with directions when it comes to anything to do with HTML CGI PERL the scripts I do have on my page where copies made by others on a shared HTML goodies like page with very simple directions the forms I wanted them to ask Your Name at time of Birth : First M. Last DOB of Adoptee : MM/DD/YYYY City, ST-State of Birth : City Name, ST Abbr.- State Name In Search Of : Bmom, Bdad, Bsis, Bbro, Bson, Bdau, Bpar Current email Address : your email@ your host.com Date of Post Date : MM/DD/YY URL web address if any : your http:// www. url .com and I wanted it to auto post itself to any proper designated page and a script that would search "this database only" for DOB, Names that kinda stuff and it should be able to be accessed for updating, deleting, changing info, ect. by myself, and by the poster. I would also like a link to you for help put on the page since you are the righter and credit to you for the script Just tell me what you need to know if you can help thanks again

        For the love of Dog please add HTML tags to your posts. :)

Re: Help with creating Web Database Frontend
by benn (Vicar) on Apr 26, 2003 at 12:03 UTC
    The good news is that the task you want to perform is a pretty straight-forward and common one. I think you're after ...
    • An HTML 'submit my data' form
    • A 'write the submitted data to a database' script/routine
    • An HTML 'search the data' form
    • A 'search for the submitted item and display the results' script/routine
    The bad news is that this will involve a degree of work. You won't be able to simply 'plug a script in' to your site - you'll need to investigate what databases / languages are available on your server, design a database that's relevant to your needs, and at the very least do some customisation to a pre-written script to enable it to run. There *are* many scripts around that perform the basic functions listed above, but somebody will still have to get their hands dirty writing HTML, connecting to the right DB etc.

    It's *possible* you'll find a volunteer here (and generally, they'd reply to this question rather than emailing you), but failing that, I'd suggest you find some basic perl/database tutorials...here in the Monastery or elsewhere - there's bound to be enough well-explained example code around to let you paste together something that'll suit you.

    Cheers,
    Ben