Vote adding

[Undrium]

Heya, guys. I'm trying to make a vote system. It's very simple working like this :

Someone selects either 1 star, 2 stars, 3 stars, 4 stars or 5 stars to vote. The vote is posted away. Problem now is that I cannot add the vote to the sum variable I have in the database.

This code isn't working very well :

if (($_POST['newvote']) == 1) {
$vote1 = $vote1 + 1;
}

Etc etc till 5.

What should I do instead? It shouldn't be that much of a complicated problem. :bemused:

Thanks,

Kris.

[_theworks]

have you tried somthing like...

$vote1++;

[Undrium]

Yes but increasing with 5?

[_theworks]

huh? increasing with 5? ur guna have to be more clear...

[_theworks]

Oh i think i know what you mean...
use a switch...

switch ($_POST['newvote']) {
case 1:
    $vote1++;
    break;
case 2:
    $vote2++;
    break;
case 3:
    $vote3++;
    break;
case 4:
    $vote4++;
    break;
case 5:
    $vote5++;
    break;
}

[Undrium]

<form action= "XXXXXX.php" method="post">
<p>
<label><br />
<select name="newvote">
<option value="5">5</option>
<option value="4">4</option>
<option value="3">3</option>
<option value="2">2</option>
<option value="1">1</option>
</select>
</label>
<label><br />
</label>
</p>
<input name="submit" type="submit" value="SUBMIT" />
</form>
<?php

if (isset($POST['newvote']) == 1) {
$vote1++;
}
if (isset($POST['newvote']) == 2) {
$vote1++;
$vote1++;
}
if (isset($POST['newvote']) == 3) {
$vote1++;
$vote1++;
$vote1++;
}
if (isset($POST['newvote']) == 4) {
$vote1++;
$vote1++;
$vote1++;
$vote1++;
}
if (isset($_POST['newvote']) == 5) {
$vote1++;
$vote1++;
$vote1++;
$vote1++;
$vote1++;
}

$sql = "INSERT INTO * SET WHERE id = '$id'
vote1='$vote1'";

?>

This is the code I'm using. What I want is if a user votes '5' he'll add 5 to the vote1. I used your increment code $vote1++ instead of $vote1 = $vote1 + 5 etc. Why isn't my database getting updated with the new values? :S

[Undrium]

_theworks : I've no trouble adding stuff to the variables, I've trouble writing them back to their positions in the database instead. 🙂

Using switch is a good option though! My vote system gives points, not giving a certain vote one increment. Voting 5 will add 5 points in total. Thanks anyways!

[_theworks]

http://www.php.net/language.operators.increment

[Undrium]

_theworks : I know how increment works. I don't want 5 variables getting added with one. I want one variable added with one, two, three 4 or 5! My problem is to get the database updated with the new value though.

[_theworks]

😃 my bad sorry im not sure why its not writing to your db

[Undrium]

It's allright, the nice thing with this forum is that always someone tries to help! ;P

[Dada78]

Let me see if I understand what you are doing. You have a voting system lets say that displays a rating for on a certain page and for every so many votes this certain pages receives it bumps the overall rating that is displayed on the page up?

[jeepin81]

Hey Undrium, I am not 100% about this but if your final value for $vote is an integer, you do not need the quote marks around it. Try losing thoses and see if that helps.

Another thought:

Ditch the SET WHERE and replace it w/ VALUES.

Hope that helps

Best-
J.

[Undrium]

Dada78 ; That's correct, voting 5 will give the object +5 points. The objects total points will be divided with it's amounts of votes then after to get out if it's a 1,2,3,4 or 5 star. It's not the problem I have, though, the database won't put in new updated $vote1, can you see any errors in this?

[Undrium]

jeepin81 ; Wow, that was quick! Thanks, I'll try it out, if it works I'll mark this thread [Resolved] 🙂 Thanks again.

[Undrium]

<form action= "XXXXXX.php" method="post">
<p>
<label><br />
<select name="newvote">
<option value="5">5 Stars</option>
<option value="4">4 Stars</option>
<option value="3">3 Stars</option>
<option value="2">2 Stars</option>
<option value="1">1 Star</option>
</select>
</label>
<label><br />
</label>
</p>
<input name="submit" type="submit" value="SUBMIT" />
</form>
<?php
echo $vote1;
if (isset($POST['newvote'])) {
switch ($POST['newvote']) {
case 1:
$vote1++;
break;
case 2:
$vote1++;
$vote1++;
break;
case 3:
$vote1++;
$vote1++;
$vote1++;
break;
case 4:
$vote1++;
$vote1++;
$vote1++;
$vote1++;
break;
case 5:
$vote1++;
$vote1++;
$vote1++;
$vote1++;
$vote1++;
break;
}
$sql2 = "UPDATE INTO * SET vote1 = $vote1 WHERE id='&id'";
mysql_query($sql2);
}

?>

This is how my code looks now. It's still not updating vote1. I've set vote1 to be an int(11). What's so wrong with this?

[jeepin81]

Have you established a database connection before inserting your SQL statement?

See if this helps:

 <?php
$db_name = "Your DB name";
$table_name = "Your Table name";

//connect to server
$connection = @mysql_connect ("localhost", "username", "password")
or die(mysql_error());

$db = @mysql_select_db($db_name, $connection) or
die(mysql_error());



 echo $vote1;
 if (isset($_POST['newvote'])) {
 switch ($_POST['newvote']) { 
 case 1: 
 $vote1++; 
 break; 
 case 2: 
 $vote1++;
 $vote1++; 
 break; 
 case 3: 
 $vote1++;
 $vote1++;
 $vote1++; 
 break; 
 case 4: 
 $vote1++;
 $vote1++;
 $vote1++;
 $vote1++;
 break; 
 case 5: 
 $vote1++;
 $vote1++;
 $vote1++;
 $vote1++;
 $vote1++; 
 break; 
 } 
}
 $sql2 = "
 UPDATE INTO * 
 SET vote1 = $vote1 
 WHERE id='&id'";

$result = @mysql_query($sql2,$connection) 
or die(mysql_error());



 ?>

[Dada78]

Undrium wrote:

Dada78 ; That's correct, voting 5 will give the object +5 points. The objects total points will be divided with it's amounts of votes then after to get out if it's a 1,2,3,4 or 5 star. It's not the problem I have, though, the database won't put in new updated $vote1, can you see any errors in this?

Ok cool, yea I am working on the same thing for campsite reviews. Let me post my code that I am using. Instead of using a DB for this since thier is over 800 plus entries I am calling a script that places the vote then add a include statement in the HTML of the table where I want, in my case a star for the overall rating.

[Undrium]

jeepin81 : Yes I do already connect to the database earlier. Though I did as you wrote, but got this error :

0You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTO links SET vote1 = 0 WHERE id='&id'' at line 1

I hope this will help. Can't really narrow the problem down more. Thanks alot 🙂

[jeepin81]

I am not a 100% but try dropping the "&" before WHERE id='&id':

Also, I don't think you need the INTO in the UPDATE INTO.

Maybe these will solve the issue. I apologize for not getting this right the first time but I am also pretty new to the "wild world" of PHP - hence the Junior Member title.