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 7 of 7
  1. #1
    New to the CF scene
    Join Date
    May 2011
    Location
    USA
    Posts
    5
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Beginner: First Project

    Here is what I am looking for and what I am trying to do:
    1. What programs do I need to create such a program?
    2. How hard is this project going to be? Beginner? Pro?

    1. User selects a “keyword” from a list on a drop down menu.
    *The first word selected provides the program with which database to use.
    Example: User selects “Cat” from the list, the program now knows to use only the cat database from now on.

    2. User selects another “keyword” from a list of sub-categories of “Cat.”
    *The program is now searching for this word in the “Cat” database but under a different sub-category. The list has been pre-determined and only appears
    because the user selected “Cat.”
    Example: User selects “Short-Haired” from a list of descriptions of “Cat.”

    3. User selects another “keyword” from a list of sub-categories of “Short-Haired”
    *The program searches for this word in the “Short-Haired” database.


    I know my example is somewhat lacking but it’s the best I can do at this point. Here is an outline of what I am trying to do:
    1. Use keywords to pinpoint a database that contains items as closely related to the search words as possible.
    2. There will be more than one option for the user’s inputs but I need the program to only display one at the very end.
    3. There will be a set number of user inputs.

    Any information you guys can throw out would be extremely helpful, I mean absolutely anything. Thanks.

  • #2
    Senior Coder
    Join Date
    Aug 2010
    Location
    High Point, NC
    Posts
    3,338
    Thanks
    5
    Thanked 363 Times in 360 Posts
    Cat is a Field in a database table correct?

    You would use a server side language such as php, in conjunction with a database such as MySQL. Then your database queries would return results depending on the "first" user selection. Then this selection would in turn populate the second selection options with yet another SQL query, so the user can select and narrow down their results.

    All similar to how ebay for example, "drills" down a category like Golf>Clubs>Irons>Left Handed>Price....and so forth.

    Is this what your talking about?


    BTW, this is a pretty advanced "first project" if you've never designed or worked with a database or website before.
    Last edited by teedoff; 05-13-2011 at 05:53 PM.
    Teed

  • Users who have thanked teedoff for this post:

    watty4 (05-13-2011)

  • #3
    Senior Coder DanInMa's Avatar
    Join Date
    Nov 2010
    Location
    Salem,Ma
    Posts
    1,577
    Thanks
    13
    Thanked 248 Times in 248 Posts
    <-- smells a homework assignment

  • #4
    New Coder
    Join Date
    May 2011
    Posts
    19
    Thanks
    0
    Thanked 4 Times in 4 Posts
    If I understand correctly what your wanting to achieve then this is the extension from joomla you would want. http://extensions.joomla.org/extensi...irectory/16649

    I dont know if you are in intrested in lessening your work load, but i suggest a content management system. I use joomla. There are others like drupal, ruby on rails, wordpress. But being your first project and a rather large one at that. I strongly suggest a little assistance.

  • #5
    New to the CF scene
    Join Date
    May 2011
    Location
    USA
    Posts
    5
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Haha no homework DanInMa.

    teedoff, that is very close to what I am looking to do, if not exactly. I think the only difference might be is when the final keyword is searched there will be several items in the database that match the keywords, but I only need one to display at a time.

    I realize that this is going to be pretty tough but I can't afford to pay someone to do it for me so I'll figure it out

    Any suggestions on where I can get some good tutorials on php and MySQL?

  • #6
    Senior Coder
    Join Date
    Aug 2010
    Location
    High Point, NC
    Posts
    3,338
    Thanks
    5
    Thanked 363 Times in 360 Posts
    Quote Originally Posted by watty4 View Post
    Haha no homework DanInMa.

    teedoff, that is very close to what I am looking to do, if not exactly. I think the only difference might be is when the final keyword is searched there will be several items in the database that match the keywords, but I only need one to display at a time.

    I realize that this is going to be pretty tough but I can't afford to pay someone to do it for me so I'll figure it out

    Any suggestions on where I can get some good tutorials on php and MySQL?
    http://www.w3schools.com is a good start. Also the php website has great tutorials a well as the MySQL website.

    If you havent already, download and install WAMP or XAMP(windows) or MAMP for Macs. This will install MySQL database, Apache web server, and PHP server all in one package.
    Teed

  • #7
    Senior Coder alykins's Avatar
    Join Date
    Apr 2011
    Posts
    1,739
    Thanks
    41
    Thanked 191 Times in 190 Posts
    does this have to be a web app? you can accomplish same tasks using other coding languages

    I code C hash-tag .Net
    Reference: W3C W3CWiki .Net Lib
    Validate: html CSS
    Debug: Chrome FireFox IE


  •  

    Posting Permissions

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