Page 1 of 1

Best Tools for Development

Posted: Wed Dec 28, 2005 6:45 pm
by SevenX
Hi guys... I'm calling on your expert opinions. I'm rather new to this but I have a daunting task ahead of me. I would love your imput since I'm drowning in a sea of information. I'd like your ideas on a project i'm to create. I'd like the best tools and implementations you can think of. Links are most important.

I'm to create a site where there is a top 100 list. the list is to be voted on(in a form)and adjusted based on those votes. I'd like to be able to have users add new items to the database using a form(new items would need to be validated). I'd like safeguards to ensure the sanctity of the ratings(log-in?). I'd like to display the biggest gainers/losers monthly.

I'm very much a noob to this whole process. I have some programming experience but I'm rusty. What are your suggestions for attacking this project. Do i need to learn all of php and mysql? are there resources where a project like this has been made open source? are there easy ways to make this and then code it into a nice looking site?

what is the best site for learning this from the ground up?

your help is very much appreciated.

-Erik Ferguson. :wink: :?:

Posted: Wed Dec 28, 2005 6:58 pm
by Chris Corbyn
OK so essentially you need to run a poll where people can't vote twice.

For that you'll need:

a) A database (MySQL/PostgreSQL ??)
b) Username or User's IP

As you can see the primary things needed are not much.

When a given user (or IP -- less reliable, given dynamic IP addresses and proxies) submits a vote a we log them as inelligible to vote as well as recording the vote. That's it.


A simple database table may be:

Code: Select all

CREATE TABLE `votes` (
    `id` int(5),
    `userid` INT(5),
    `option_number` int (1)
)

CREATE TABLE `options` (
   `id` int(5),
    `color` varchar(25)
)