Best Tools for Development

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
SevenX
Forum Newbie
Posts: 1
Joined: Wed Dec 28, 2005 5:58 pm

Best Tools for Development

Post 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: :?:
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post 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)
)
Post Reply