TOP voting system

itworks

hi i was hoping anyone could point me to a tutorial or a script or just maybe give me a few tips in how to make a php script.

what i want is, a list with top movies in which you have a checkbox for each one and the user can select 10 of the movies and vote for them or point other movies that aren't on the list and vote for it.

here and example site of what i want

http://www.oscarworld.net/top100project.asp

suntra

I don't have time to write the code because it would be too big, but I can give you the base...

Of course, you must have access to a database. You create a database and a table for the movies... It could have 4 fields : id, title, year, number of votes.

When you want to display all the movies, you query MySQL with something like "SELECT * FROM movie_table SORT BY num_votes DESC" (it will select everything, and will sort result according to the number of votes, more votes at top, less votes at bottom...)

When you print result, you put a checkbox with the id of the movie... when submitted, you check which ID have been submitted, then add 1 to the number of votes, ...

To add movies, it's again MySQL queries...

I know this doesn't really help, but that's all I can do...

itworks

thanks a lot suntra?!

it's not like you've given it to me on a plate but at least you've made it more clear to me now, thanks a lot!! 😉

i'd still like to see if anyone else can give me some more help.

itworks

i have to ask you to reconsider the option of writing the code.

you would have all credits at the bottom of the page.

this goes for anyone who would be able to do this script.

come on! please 🙁

itworks

anyone please, i'm desperate man?!

i have to finish the site and the only thing that i haven't did is this page.

just make a little scratch of the code so i can see a glimpse on how to do this.

i'm new to PHP and i still need a little push to see how it's done.

planetsim

Not to sound like im flaming. But
1)Dont post the same post in multiple forums. You will be answered

2)No one will just code it for you. You may however get lucky. But i dont think too many people have the time on there hands to just quickly do a script like this. Its a little more complex then it meets the eye. Espeacially for a person beginning.

Now is this really important.
If so theres plently of ways to do this

Simply get every option and do if and elses
Or use a loop

Now with something as big as this you will wanna use a loop.

For loop is probably best but you could also use a do while. But i suggest using a for loop

now you will need to count how may votes have been placed.
From there a loop requires a number of times to go through it. Now using the number of votes is what you'll need. From there a query update will probably do the trick.

Instead of using SET column1 = column1 + 1 try something like this for it

$_POST['name'] = $POST['name'] + 1

Now i hope that helps a little more

itworks

anyway thank you for your help, but i must tell you that i don't understand why wouldn't anybody just code this for me, if it was the other way around i would do it for you. you probrably don't need it but if you ever have a problem with flash just go to flashkit forum and i'll solve it for you, i can proudly say that even today i helped at least 4 or 5 of my fellow companions and in some cases i just opened flash, did what they asked for and sented to them 'cause they couldn't understand all those advanced things the experts talk about.

i know that this kind of behavior is not the best and believe me i normally wouldn't do this, but as i said i am desperate and desparate men do crazy things.

i'm really sorry.

cgraz

Here's a quick example

$query = mysql_query("SELECT bla FROM your_table ORDER BY votes DESC");

echo "<table width='250'>\n";

while($row = mysql_fetch_array($query)) {
  print "<tr>\n";
  print "<td width='200'> /* put data here */ </td>\n";
  print "<td width='50'><input type='checkbox' name='assign_name[]' value='" . $row["id"] . "'></td>\n";
  print "</tr>\n";
}

echo "</table>\n";

Best way to do this in my opinion is make the name be an array using [], and the value to be the id or something unique to each record.

YOu can probably make sure they don't fill out more than 10 using javascript, but I have no idea how to do it. What you could do on the processing page is

if (count($assign_name) <= '10') { // $assign name being the array name you gave the checkboxes 
   // They chose 10 or less
} else {
   // they chose ten or more
}

As planetsim mentioned, you'd have to be pretty lucky to get someone to code somethign like that for you. The jist of how it works (like i showed you above) is probably the best you'd get. It's not because people on this forum are mean, but because if everyone came here and just asked people to write code for their projects, it would be like working for free. 😉 Everytime I help someone (with the little knowledge I have), I hope that they actually learn something and try to give them links to the right places so that they'll learn, not just take code and come back later when they run into a problem.

Cgraz

itworks

i see what you meen and i have to agree that these days noone does nothing for free, but isn't PHP free?!

don't get me wrong please. when i help someone with something i know, they will learn from it too, i agree that the whole thing of helping should be like "not giving a fish to a hungry man but showing how to go fishing one".

for your help i'm most grateful 'cause it is really helpful, i feel like now, maybe i figured it out a little more.

thanks🙂