Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Feb 2013
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Best language for search options and can MS Access be used as a search database

    I’m trying to build my first real website so unfortunately I don’t have any great knowledge of the subject. I can do basic HTML and at one point I could program in Turing but I’m pretty sure that’s worthless. Anyway, I’m trying to build a website that is primarily a search function. It would have a variety of search options (for example, “Price,” “colour,” and other functions). These would then return results that would match all the selected relevant queries. I’m also interested in making the search bars have options (such as for “Price” have a “between” option (eg. Between $10 and $20)). While I have found how to make a search bar in HTML, to my understanding I can’t make a search option this specific in it. So which programming language would you guys recommend for me to approach this in? I’ve heard that PHP is the best for this especially with my very limited skill.

    Another big question is would there be a way for me to link the search options to an MS Access database (or MS Excel, but I would imagine Access would be more likely to work). So basically I’d have a database with each row being a product and along it would be all the information for the search (price, colour…etc) and whenever you’d use the search, it would rely off this database.

    Sorry this is so much to ask, I’m just more at a loss of where to start (other than get educated which goes back to which language I should use :P). Any help is greatly appreciated. Thank you ahead of time

  • #2
    Senior Coder jerry62704's Avatar
    Join Date
    Oct 2007
    Location
    Springfield, IL
    Posts
    1,100
    Thanks
    13
    Thanked 87 Times in 87 Posts
    Your database would have to be on the server, unless your home machine is also a 24/7 server. Most ISPs have mysql on them that you can use.

    PHP will connect the queries you build on your web page with the database. Most ISPs have this as well.

    Depending on the time frame, you can do all this. We all started from nowhere to begin with. If it is time sensitive, you may have to pay someone. There is a place on this forum where you can get prices and such.

    If you have the time, try starting at w3schools.com and take the tutorial on HTML and SQL to start.

    The data entry part (the form on your page) might benefit from javascript to validate the data before you make a server request. They have a tutorial for that too.
    .
    .
    ...and gladly would he learn and gladly teach

    Visit www.LiberalsWin.com for humor and the unique Bush/Obama Approval Polls

  • Users who have thanked jerry62704 for this post:

    matt_b_19 (02-28-2013)

  • #3
    New to the CF scene
    Join Date
    Feb 2013
    Posts
    2
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Oh this is the information that I'm looking for. Thank you very kindly. After looking into your suggestions more, SQL should work perfectly and I looking into this w3school.com and the tutorials seem great. Time isn't a factor for me, it's really just a side thing that I'm doing while I'm bored at work or home, like a hobby I guess.

    Thanks a lot for all your help, you answered my question perfectly


  •  

    Tags for this Thread

    Posting Permissions

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