1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

could use some assistance with web design

Discussion in 'Web Design & Development' started by mad-martin, Jan 25, 2013.

Thread Status:
Not open for further replies.
Advertisement
  1. mad-martin

    mad-martin Thread Starter

    Joined:
    Jul 5, 2002
    Messages:
    1,309
    Hi guys,

    I want to create a web page and would appreciate some input.

    The page I would like to create is more about functionality then design (although it won't hurt if it looks good as well as being functional).

    My basic idea…

    I need the functionality of a store locator; however there are a few ifs and buts...
    My version is for a small company that rents vehicles out and ideally I would like to see 2 'input boxes' 1 for vehicle registration and 1 for postcode/town
    Besides that I would require a number of tick boxes*

    What do I expect of the web page...?

    If a vehicle registration has been put in the field and the postcode/town, I would like it to shown me the nearest repair agent (from a database, excel spread sheet), the registration will be verified from an excel spread sheet, which will give vehicle brand.
    (The excel spread sheet will contain info like: vehicle brand, warranty expiry date and any special equipment like: tail lift, fridge etc.).
    If one of the tick boxes has been ticked (tick boxes would be for special equipment, like fridge, tail lift etc.) I would like the web page to display the repair agent’s details for the corresponding specialist equipment. (If for instance the fridge on a Mercedes vehicle is broken down, we need to send a fridge repairer out and not the main Mercedes agent, therefore if a tick box is ticked it should overrule main dealer and go to specialist dealer.

    If the vehicle is still under warranty, a vehicle main dealer warranty number should be displayed, out of warranty the nearest local dealer.
    Security is not a major issue as the web page will be hosted internally only.

    No doubt there will be a few things that I haven't thought about yet ;)
    I have hardly any experience in web design, but I have all the time in the world and you're never too old to learn.

    I hope you guys could give me some pointers in the right direction!
    All help/feedback appreciated!

    mad-martin
     
  2. colinsp

    colinsp

    Joined:
    Sep 5, 2007
    Messages:
    2,257
    First Name:
    Colin
    What you want to do here is achievable with some php and a mysql database.

    I would start a project like this a bit at a time.

    Create a database and initially just have a vehicles table. Get that form functioning properly.

    Then you will need to create a post codes table in the database. Get that bit functioning on the form correctly.

    Then create a repairers table and add that to the form,

    Break it up into manageable chunks and then improve the functionality as you get each piece working properly.

    It doesn't sound like too hard a nut to crack but you will have a fair bit of learning to do.
     
  3. mad-martin

    mad-martin Thread Starter

    Joined:
    Jul 5, 2002
    Messages:
    1,309
    Thanks for your reply Colin! much appreciated.
    You got it spot on, I'm a bit of a noob when it comes to this, but am a quick learner ;)
    Am I right in thinking that firtstly I should create a mysql database with a form, add the vehicles and repairers to that form?
    So to start I would need to purchase sql server (what version would you recommend?) and is there anything else I need to purchase? I have MsAccess and all other basic software I already have an access database of the repairers (work in progress)
    Thanks in advance for your help and patience!!

    mad-martin
     
  4. colinsp

    colinsp

    Joined:
    Sep 5, 2007
    Messages:
    2,257
    First Name:
    Colin
    I presumed that as this question was in the webdesign section you wanted a web based app with a browser front end. Is this correct?

    If this is the case then you will need some hosting space to put the finished application on. Most hosting packages come with php and mysql already installed so you don't have anything to buy.

    For development purposes download a free development environment that includes what you need to run on your PC. I use Wampserver there is also Xamp and others. This will allow you to develop on your PC and visit the "site" in your browser and you then only need to put it on some hosting once it is finished.

    Have a look at the tutorials on http://www.tizag.com/ they should get you going.

    I would create a vehicles table first. Then I would create a form that displays the data from that table. Then I would build from there with the repairers first and finally the post codes as this is potentially the most complicated thing to incorporate.
     
  5. mad-martin

    mad-martin Thread Starter

    Joined:
    Jul 5, 2002
    Messages:
    1,309
    Yes your assumption is correct, I thought of a website, however only hosted locally within a server environment (so only accesible to users that are logged on the server)
    I will install a local server environment for testing like you suggest and have a play!
    Thanks for yoor help once again!

    mad-martin
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1086758

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice