Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    Mar 2010
    Posts
    1
    Member #
    21508
    Hello,

    My girlfriend, a computer tutor to seniors, has created a catalog of roughly 800 really basic tutorials that she wrote in html. She has these in a folder hierarchy without any navigation. Each lesson folder has an images folder that contains the screen captures linked in the html file and a rendered pdf file of the lesson with page breaks for printing.

    She now would like to share these lessons online and have an interface to search by keyword, browse by category and browse by application name. She would also like to allow the user to filter the results by the operating system.

    I have considered a few approaches.

    1. making a database of links with fields for title,description, url, application, category, keywords, etc for each record
    2. Loading all the lessons into a Content Management System.
    3. Building an index page of links in each of the folders.

    Any suggestions are welcome and kudos in advance for any generous souls.

  2.  

  3. #2
    WDF Staff mlseim's Avatar
    Join Date
    Apr 2004
    Location
    Cottage Grove, Minnesota
    Posts
    7,724
    Member #
    5580
    Liked
    718 times
    #1 is the way to go, as you don't have to change anything with the way you
    have stored things now. PHP and MySQL would be the programming used.

    Put all of the images in one directory (you call them folders, but online, they are directories).
    Put all of the PDF files in one directory, each with a unique name.
    Put all of the lessons in one directory, each with a unique name.

    You create a MySQL database with one table called "tutorials".
    That table contains the variables (fields) you listed plus any more things you want.

    You already know what the three directories are called, so you only need to
    save the filenames and other information for each tutorial.

    Maybe a list of variables like this in your MySQL table:
    =======================================
    ID (auto increment ID number of each record) Primary ID
    title
    desc
    pdf_filename
    photo1_filename
    photo2_filename
    photo3_filename
    text_filename
    application
    category
    keywords (each word separated by commas)
    rating_qty (how many times it was rated by students)
    rating_sum (accumulating sum of the rating on a 5-star scale 1,2,3,4 or 5)
    downloads (how many times the pdf was downloaded)
    revision (UNIX timestamp of tutorial revision date)
    relation (ID numbers of similar or related tutorials, separated by commas)


    Once a database is made, in which case you'll have about 800 rows in your table,
    you can search, sort, query by an infinite amount of methods and combinations.

    A rating system for students to rate each tutorial (sum / qty = rating).
    A PDF download system that keeps track of how many were downloaded.

    That's the approach I would take anyhow ...



Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 01:37 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com