I think I'm in over my head here and need some advice. I'm trying to add my fonts collection to my free graphics web site; which I am in the process of redisigning now. There are well over 15,000 fonts that I want to add. I'm looking for several things;

  1. extract the info from the font file
  2. add it to the database
  3. pull info from database
  4. display in HTML page

With my current font manager I can generate the sample gif's and basic html code to list them, so many per page, alphabeticly. I probably will do that just to get them up there. But that's just an interm soulution.

As I don't know ANYTHING about either PHP or MySQL, other than I have them with my host, it will likley take me months to learn how to do what I want. Is there anything out there already that may do some or all of what i need?

Here is a breakdown of what I'd like to do.

On the site
Search:
  • Alpha navagation - A-Z #
  • Catagories - comic, deco, grunge, dings, script, etc.
  • Designer - by name
  • Font Family
  • Font Style - bold, wide, condensed, etc.

Display:
  • Select number of samples to show on each page - 10, 20, 50, 80
  • More info - opens new popup with full character map image & other info

Sample:
  • Font Name : Revision
  • SAMPLE IMAGE


MySQL
Database:
  • font name
  • file name
  • zip name
  • charset name

  • font url
  • sample url
  • zip url
  • charset url

  • family
  • style
  • weight

  • designer
  • copyright info
  • creation date
  • revision
  • vendor

  • type
  • catagories (check list of about 30)
  • keywords-tags
  • other info

  • (anything else that may be needed)


Boy, I sure liked the first breakdown better! I best revise my learning timetable

Any help would be greatly appericated and earn you my undying gratitude.

tazem