Topic: Questions

[Canuck]

As some of you are aware, I collect hockey autographs through the mail.

http://ttm.kranjcevic.com/recent_successes.php

And I started thinking.... there are forums where people post their successes, but the search on some of these forums never seem to work, and you would have to dig through previous posts to see if someone got a success from a particular player, and when, etc.

My idea is to create a site where people would have to sign up, and would be able to enter their successes into one big database.  Then they would be able to search these successes, similar to how I have it on my site (Search Successes).  I was also thinking of having a section where they can, instead of inputting the data one entry at a time, upload a tab delimited text file, that I would then parse and load into the database.  I would also allow them to edit their entries.

I know this is a lot of work, and it will take some time, but I just wanted some suggestions as to what I should be concerned about (safety of the db), any security issues?

Thanks for the input!

[Perspective]

I was also thinking of having a section where they can, instead of inputting the data one entry at a time, upload a tab delimited text file, that I would then parse and load into the database.

Most databases (including MySQL) support loading data in this type of format, you don't need to write a parser yourself.