Creating a database of project descriptions

Discussion in 'Web Design and Development' started by Dookieman, Oct 30, 2013.

  1. Dookieman macrumors 6502

    Joined:
    Oct 12, 2009
    #1
    Hi,

    My boss wants me to create a database of project descriptions for future proposals so they are all in one place and easy to find. I'm a beginner web developer so I'm looking for advice. I have a basic site set up with accordion menus that drop down like so:

    Project -> Project Description Type (Each one with an emphases on something we did on the project) -> Actual project description.

    Currently I just have all the data placed in HTML with some CSS to make it look nice and easy to navigate. Is this an acceptable way of doing this? Would you suggest a better way?

    Thanks!
     
  2. 960design macrumors 68000

    Joined:
    Apr 17, 2012
    Location:
    Destin, FL
    #2
    I'd keep your HTML / CSS structure but throw all the data in a database ( kinda like your boss asked ). This will make searches easy and fast.

    Build a simple front end for the admin ( you ) to update via a web form. All you need is simple CRUD.

    Have the page pull the active projects or whatever you need to display. Click on the list link to take you to a details page.

    Get rid of the accordion stuff ( that's just a personal design opinion of mine ).
     
  3. Dookieman thread starter macrumors 6502

    Joined:
    Oct 12, 2009
    #3
    Thanks for the info. Do you have any links to examples that I can learn from? I'm not familiar with SQL/CRUD yet. Though, I did sign up for a Udemy course that teaches you SQL.

    Thanks!
     
  4. 960design macrumors 68000

    Joined:
    Apr 17, 2012
    Location:
    Destin, FL
    #4
    http://net.tutsplus.com/tutorials/php/real-world-oop-with-php-and-mysql/

    It was a lot harder than I thought to find. Does anyone else have any good online tutorials?

    Lynda.com is bound to have some, but that requires a subscription. Although you can sign up for a 30 day free trial and learn like a zombie until your free trial is up.

    There are tons of good books. Check amazon and search with something like beginning PHP.
     
  5. Dookieman thread starter macrumors 6502

    Joined:
    Oct 12, 2009
    #5
    Thanks! Is PHP still the most recommended language for what I want to do? I've heard Ruby/Python are becoming more popular in the past few years. Just curious.

    Thanks!
     
  6. 960design macrumors 68000

    Joined:
    Apr 17, 2012
    Location:
    Destin, FL
    #6
    Python has been around forever and will probably always be relevant.
    Ruby is a fantastic language, but my clients seem to always need PHP work. So my Python skills fallen to the wayside and I never developed into someone with enough knowledge about Ruby to comment fully on it. I can say that I really like it for what little I've done with it.

    Most (90%) of my work is PHP based now; ObjectiveC, C++ and Java filling in the rest.
     
  7. blaster_boy, Nov 4, 2013
    Last edited: Nov 6, 2013

    blaster_boy macrumors 6502

    blaster_boy

    Joined:
    Jan 31, 2004
    Location:
    Belgium
    #7
    A very good book that taught me a lot about php and mysql was the following one : "PHP and MYSQL Web Developement" by Luke Welling and Laura Thomson.

    You can find it on Amazon, and in it's days (now I am more into python) it was my bible to do anything PHP / MYSQL related. Quite a hefty tome, but they explained *everything*.
     
  8. 960design macrumors 68000

    Joined:
    Apr 17, 2012
    Location:
    Destin, FL
    #8
    I have that exact same book and many others; amazon and lynda.com should be your best friend.
     
  9. Dookieman thread starter macrumors 6502

    Joined:
    Oct 12, 2009
    #9
    Yep, I'm going to buy this book tonight. How big a difference will 4th vs 5th Edition make? I would like to keep it as cheap as possible, so I was leaning towards a used copy of 4th edition.

    Nevermind, 5th isn't out till 2014.

    Thanks for the help!
     
  10. Dookieman thread starter macrumors 6502

    Joined:
    Oct 12, 2009
    #10
    I just bought a copy of PHP and MySQL. Hopefully this will be a nice learning experience so I can add it to my resume.
     
  11. 960design macrumors 68000

    Joined:
    Apr 17, 2012
    Location:
    Destin, FL
    #11
    It should be a fantastic start. I haven't pulled it off my shelf in over a year, most often if I have to recall any keyword usage I just google it from the PHP online doc ( I'm talking about you DATE ).

    If you run into any problems, just create a new thread in this section. There are quite a few VERY intelligent and friendly people here that can help. Don't Panic!
     

Share This Page