mmmrafik Posted October 19, 2011 Share Posted October 19, 2011 <?php // Connects to your Database mysql_connect("localhost", "dbusername", "dbpassword") or die(mysql_error()); mysql_select_db("mydatabase") or die(mysql_error()); //We only run this code if the user has just clicked a voting link if ( $mode=="vote") { //If the user has already voted on the particular thing, we do not allow them to vote again //$cookie = "Mysite$id"; if(isset($_COOKIE[$cookie])) { Echo "Sorry You have already ranked that site <p>"; } //Otherwise, we set a cooking telling us they have now voted else { $month = 2592000 + time(); setcookie('Mysite'.$id, 'Voted', $month); //Then we update the voting information by adding 1 to the total votes and adding their vote (1,2,3,etc) to the total rating mysql_query ("UPDATE userads SET total = total+$voted, votes = votes+1 WHERE id = $id"); } } if ( $mode2=="vote") { //If the user has already voted on the particular thing, we do not allow them to vote again //$cookie = "Mysite$id"; if(isset($_COOKIE[$cookie])) { Echo "Sorry You have already ranked that site <p>"; } //Otherwise, we set a cooking telling us they have now voted else { $month = 2592000 + time(); setcookie('Mysite'.$id, 'Voted', $month); //Then we update the voting information by adding 1 to the total votes and adding their vote (1,2,3,etc) to the total rating mysql_query ("UPDATE userads SET total = total+$voted, nvotes = nvotes+1 WHERE id = $id"); } } //Puts SQL Data into an array $data = mysql_query("SELECT * FROM userads WHERE id = $id ") or die(mysql_error()); //Now we loop through all the data while($ratings = mysql_fetch_array( $data )) ?> <link href="style.css" type="text/css" rel="stylesheet" /> { <?php echo '<div id="voting_14" class="voting voting_template_votess-up-down">'; echo "<strong class='positive_votes'>"; $current = $ratings[votes]; echo "<span>+" . round($current,0) . "</span>"; echo "<a href=".$_SERVER['PHP_SELF']."?mode=vote&voted=1&id=".$ratings[id]."> <input class='vote_positive' type='submit'></a>"; echo '</strong>'; echo "<strong class='negative_votes'>"; $current2 = $ratings[nvotes]; echo "<a href=".$_SERVER['PHP_SELF']."?mode2=vote&voted=2&id=".$ratings[id]."> <input class='vote_negative' type='submit'></a>"; echo "<span>-". round($current2,0) ."</span>"; echo '</strong>'; echo '</div>'; } ?> i have sql table userads with : id , name , username , total, votes , nvotes. Link to comment https://forums.phpfreaks.com/topic/249407-if-i-vote-on-one-user-this-vote-goes-to-all-users-need-help/ Share on other sites More sharing options...
fenway Posted October 19, 2011 Share Posted October 19, 2011 Read the rules, and try again. Link to comment https://forums.phpfreaks.com/topic/249407-if-i-vote-on-one-user-this-vote-goes-to-all-users-need-help/#findComment-1280608 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.