Hello everyone, I'm trying to get create a php script using a MYSQL backend that will produce a ranking system for music tracks. I want users to be able to input their own song title and artist to vote on it then the backend will take that information and put it in a database and rank which songs have the most votes. Here is a picture of what I'm trying to achieve:
I want it to have the same columns and these features:
-
User input (so that users can type in any song that they want)
-
Duplicate input recognition (so that if a user puts in a song title that is already been put in the database, it will merge with it and add to its votes)
-
Comments (users can leave comments [preferably a pop up window])
-
A "Thank you for submitting" page (so that when a user types in their vote, it will redirect them to a thank you page)
-
IP logging/block (so that users can't vote more than once a month)
Any help would be appreciated. Are there any tutorials or free scripts I could use to help me achieve this?
Thanks in advance!