PHP - Range Voting Form

Basically I am writing my own voting system but I have a few problems and I would like to address them all in one post rather than three.

First:
The first thing I need help with is using CURL to check if a user actually voted at the remote top list website.

Two:
I need maybe a source script of a 10 digit hash generator that will display the hash generated and will insert it into the database

This is currently what my hash generator looks like but I need someone to help me change it so that it will echo the actual hash generated and inserts it into the database,


<?php
function gen_md5_password($len = 6)
{
    return substr(md5(rand().rand()), 0, $len);
}
?>

Three:
I need some sort of way to tell the database that if they hash is not used within 24 hours, it will just dump or delete.

I made a website for school where everyone can upload their summaries, download them and rate them (thumbs up, thumbs down).
You upload a summary with some data: a specific class, subject, name etc.
The path to the file, the name, subject etc. comes in a mysql table and the summaries show in a list on the site. 

Now here comes the problem, when you vote a summary up you go to the page up.php like this:

Code: [Select]
<!--Directing to up.php-->
--some mysql--
while ( $summary = mysql_fetch_assoc($result) ) {
echo "<a href=\"up.php?id=".$summary['id']."&page=".$summary['class'].$summary['period']."\">";
}

On the page up.php I have the following code which adds +1 in the thumbsup row in myqsl:

Code: [Select]
<!-- thumbsup +1 -->
--some mysql--
$sql2 = "UPDATE locatie SET thumbsup = thumbsup + '1' WHERE id='".strval($_GET['id'])."'";
$uitvoeren2 = mysql_query($sql2);

and sends you back to the previous page
Code: [Select]
header("Location: ".$_GET['page'].".php");
Google crawls all my pages, and also the page Code: [Select]
up.php?id=1&page=class1periode3, which changes my mysql.
Leading to that all of the summaries are being voted on by google, which is every annoying.

This probably isn't the best voting script but I'm fairly new to php and thought this up on my own, so I was wondering if I could get it working properly 

Thanks in advance

Hi there, im hoping someone can help me with this. What i’m trying to do is prevent users from voting twice with cookies, ive tried to set several myself but none of them have worked. Any help would be amazing. Thanks.

EDIT: unsure why its formatted this way.  how to fix? 

 

<?php include 'functions.php'; // Connect to MySQL $pdo = pdo_connect_mysql(); // If the GET request "id" exists (poll id)... if (isset($_GET['id'])) { // MySQL query that selects the poll records by the GET request "id" $stmt = $pdo->prepare('SELECT * FROM polls WHERE id = ?'); $stmt->execute([$_GET['id']]); // Fetch the record $poll = $stmt->fetch(PDO::FETCH_ASSOC); // Check if the poll record exists with the id specified if ($poll) { // MySQL query that selects all the poll answers $stmt = $pdo->prepare('SELECT * FROM poll_answers WHERE poll_id = ?'); $stmt->execute([$_GET['id']]); // Fetch all the poll anwsers $poll_answers = $stmt->fetchAll(PDO::FETCH_ASSOC); // If the user clicked the "Vote" button... if (isset($_POST['poll_answer'])) { // Update and increase the vote for the answer the user voted for $stmt = $pdo->prepare('UPDATE poll_answers SET votes = votes +1 WHERE id = ?'); $stmt->execute([$_POST['poll_answer']]); // Redirect user to the result page header ('Location: result.php?id=' . $_GET['id']); exit; } } else { die ('Poll with that ID does not exist.'); } } else { die ('No poll ID specified.'); } ?> <?=template_header('Poll Vote')?> <div class="content poll-vote"> <h2><?=$poll['title']?></h2> <p><?=$poll['des']?></p> <form action="vote.php?id=<?=$_GET['id']?>" onSubmit="disable()" method="post"> <?php for ($i = 0; $i < count($poll_answers); $i++): ?> <label> <input type="radio" name="poll_answer" value="<?=$poll_answers[$i]['id']?>"<?=$i == 0 ? ' checked' : ''?>> <?=$poll_answers[$i]['title']?> </label> <?php endfor; ?> <div> <input type="submit" name="submit" value="Vote"> <a href="result.php?id=<?=$poll['id']?>">View Result</a> </div> </form> </div> <?=template_footer()?>

 

Edited July 1, 2020 by requinix
cleaning up post

Hello,

Im trying to create a simple voting script for my site, i been trying different things but cannot get it too function properly. The idea is you click the 'thumbs up' image to add 1 to the 'likes' value and thumbs down to add '1' to the dislikes. Sound simple but its giving me headaches.

Would really appreciate it if someone could take a quick look at my script. The table is called 'youtube_rating' (because thats the look i was going for) and in the table is 4 columns, id (aut0_increment), liked (counts liked votes), disliked (counts dislikes) and item_num which is the id for teh product the rating is for.

Code: [Select]
<? if ( $row['rating'] == 'YES' ) {
require ("../rating/voting/dbcon.php");

$result1 = mysql_query("select * from youtube_rating WHERE item_num='".$page_id."'");
$row = mysql_fetch_array($result1);
$dislike = $row['dislike'];
$like = $row['liked'];

if (isset($_POST['submitted']))
{

require_once ("../database/functions.php");

$userip = $_SERVER['REMOTE_ADDR'];
$id = safe($_POST['id']);
$vote = '1';


// check if user already voted
$result = mysql_query("SELECT * FROM youtube_ip WHERE userip='$userip' AND item_num ='".$id."'");
$num = mysql_num_rows($result);

    // if already voted show error
if (isset($_POST['submitted']) && ($num > 0))
{
echo '<div class="alreadyvoted">You have already voted!</div>';

}

    // add like
if (isset($_POST['submitted']) && ($_POST['submitted'] == 'like') && ($num == 0))
{
// add 1 to value
$liked_value = mysql_query("SELECT liked FROM youtube_ip WHERE item_num ='".$id."'");
$liked_total = $liked_value + $vote;

$query = "update youtube_rating set liked = '".$liked_total."' where item_num ='".$id."'";
echo '<div class="ilikethis">You like this!</div>';
      }

    // add dislike
if (isset($_POST['submitted']) && ($_POST['submitted'] == 'dislike') && ($num == 0)) 
{
// add 1 to value
$dislike_value = mysql_query("SELECT dislike FROM youtube_ip WHERE item_num ='".$id."'");
$dislike_total = $dislike_value + $vote;

$query = "update youtube_rating set dislike = '".$dislike_total."' where item_num ='".$id."'";
echo '<div class="idislikethis">You Dislike this!</div>';
}

// log ip
// if (isset($_POST['submitted']) && ($num == 0)) 
// {
// mysql_query ("insert into youtube_ip (userip, item_num) values ('".$userip."', '".$id."')");
// }
}
?>

<table width="50%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="48%" align="center">
    <form action="" method="post">
    <input name="id" type="hidden" value="<? echo $page_id ?>" />
    <input name="submitted" type="hidden" value="like" />
<button type="submit" class="like_button" name="like" id="like" >
<img src="../rating/voting/pixel-vfl73.gif" alt="">
<span><?php echo $like?></span>
    </button>
</form>
    </td>
    <td width="52%">
    <form action="" method="post">
    <input name="id" type="hidden" value="<? echo $page_id ?>" />
    <input name="submitted" type="hidden" value="dislike" />
<button type="submit" class="dislike_button" name="dislike" id="dislike" >
<img src="../rating/voting/pixel-vfl73.gif" alt="">
    <span><? echo $dislike?></span>
</button>
</form>
    </td>
  </tr>
</table>

<?
}
?>
The problem is the vote does not add up or update the database, also it doesn't seem to be checking if the user has voted or not, it just attempts (but fails) to add a vote no matter what

Thanks for any help.

So I have made an anonymous poll system but I would like to limit the possibility to vote only once from a single pc.

I think that I could store and check 3 things regarding a user that has voted:
1) $_SERVER['HTTP_CLIENT_IP']."!".$_SERVER['HTTP_X_FORWARDED_FOR']."!".$_SERVER['REMOTE_ADDR'];
2) HTTP cookie
3) Flash cookie LSO (because this contrary to the HTTP cookei can be detected in multiple browsers( (only if Flash is installed)))

But there can be a simple situation - a simple user votes one time from Firefox and after a time his IP changes (for example he uses some Mobile internet where dynamic addressing is used) . Then for some reason he wants to use Internet Explorer where Flash is not installed. In result - it is possible to vote twice.

Can anyone please suggest something regarding this?

I know there is not 100% bulletproof solution - I just want to minimise the possibility to vote more than once.

Also I am thinking about using EverCookie(undeletable cookie) but that could cause a lot of other problems.

hi guys

i am building a voting system for my gaming website

people sign up for matches, and those will be played at 3-5 different maps
people can vote for wich maps they want to play

each player can choose 3 maps, also 3 x the same map

now the results of that voting system are shown on the page like this

There is 1 vote for Map 1
There are 5 votes for Map 2
There is 1 vote for Map 3
There are 2 votes for Map 7
There is 1 vote for Map 4
There is 1 vote for Map 5
There are 8 votes for Map 8

now i want to make a script that picks the maps that will be played, so only show the 3-5 best results

in the example above it woud be 2 x map 8 and 1x map 2
but im not sure how to start on this

the db table of the votes is built like this

id    matchid    playerid    mapid    mapname
1    113    195    1    NukeTown
2    113    195    2    Grid
3    113    195    1    NukeTown
4    114    195    1    NukeTown
5    114    195    1    NukeTown

any advice or thoughts on this?

thanks

Hi Guys,


I am designing this website that takes votes on images. I need to store the votes for each image against the image name and a username. For this purpose, I need to modify the current code which retrieves votes from the voting system but doesn't have a system to enter the image name dynamically. Below is the code for the same:

Code: [Select]
<?php
ob_start();
$host="localhost";
$username="computat_abhi";
$password="[..]";
$databasename="computat_button";
$tbl_name="record";

$db=mysql_connect ("localhost", "computat_abhi", "[..]")or die(mysql_error());
mysql_select_db($databasename, $db) or die(mysql_error());

if( isset($_POST['Like']) )
{



$sql = 'INSERT INTO record(ImageNumber,LikeCounter) VALUES (\'b1\', 1)';


mysql_query($sql, $db) or die(mysql_error());



echo 'Like vote is registered';
}
elseif(isset($_POST['Dislike']))
{



$sql = 'INSERT INTO record(ImageNumber,DislikeCounter) VALUES (\'b1\', 1)';


mysql_query($sql, $db) or die(mysql_error());

echo 'Dislike vote is registered';
}


ob_end_flush();
?>

<html>
<head>
<title>

Do you Like/Dislike this image?

</title>
</head>
<body>
<h1>
Do you Like/Dislike this image?
</h1>
<form name="form1" method ="post">
<input type="submit" name="Like"    value="Like">
<input type="submit" name="Dislike" value="dislike">
</form>
</body>
</html>

Another issue is to register a new user on the website www.computationalphotography.in and link it with the voting system above. Looking forward to your help and suggestions.

Hello everyone.
I recently coded a Minecraft Voting for Diamonds script. Basically, you enter your username, you vote on the sites, then click "Get Reward". The reward then goes through a RCON script, and rewards the user with their diamonds in-game. the full script works fine, and I am happy with it, but there is one small problem; and that is users being able to abuse the system. If they wanted to, they could just refresh the page, and click Get Rewarded again, and again. I want to make something like this:



It has a countdown on the link, which is started upon click, and then the link re-activates when the timer is done. My script already has "disabled=..." tags, so you have to click all links, this way would make sure a user cannot click the link until the timer is done. I'm pretty new to PHP, and please forgive me if it is not 100% PHP, but this place seemed extremely helpful. I am also pretty new to PHP, so make it for dummies xD

Thanks everyone!

This works if say I do 192.168.0.1 - 192.168.1.254 it will work. However doing 192.168.0.1 - 192.168.1.10 will only generate up to .10 on both IP schemes. I see why, but I cannot figure out a way around this...

Thanks!

$start = explode('.', '192.168.10.1');
$end = explode('.', '192.168.11.10');

/**
 * Final output...
 */
$a = 0;
$b = 0;
$c = 0;
$d = 0;

// First segment
for ($a = $start[0]; $a < 1 + $end[0]; $a++)
{
// Second segment
for ($b = $start[1]; $b < 1 + $end[1]; $b++)
{
// Third segment
for ($c = $start[2]; $c < 1 + $end[2]; $c++)
{
// Fourth segment
for ($d = $start[3]; $d < 1 + $end[3]; $d++)
{
echo "{$a}.{$b}.{$c}.{$d}<br />";
}
}
}
}

I am currently working on a date range script and wondering if anybody think of an easier way to do this, doing up to next 8 weeks?  This one starts on a Sunday. I also need to do one starting on a Monday (will figure that one later)

$thisweek = date("Y-m-d");
$week = date('w', strtotime($thisweek));
$date = new DateTime($thisweek);
$firstWeek = $date->modify("-".$week." day")->format("M d");
$endWeek = $date->modify("+6 day")->format("M d");
echo $firstWeek." - ";
echo $endWeek;

$nextweek = date(("Y-m-d"), strtotime("+7 Days"));
$week1 = date('w', strtotime($nextweek));
$date1 = new DateTime($nextweek);
$firstWeek1 = $date1->modify("-".$week1." day")->format("M d");
$endWeek1 = $date1->modify("+6 day")->format("M d");
echo $firstWeek1." - ";
echo $endWeek1;

 

I have range of categories from 1 to 999

With this is piece of code:

foreach (range(96,204) as $number)
if (Tools::getValue('id_category') == $number)
return;
$this->filterResults();
return $this->display( __FILE__, 'block-center-filter.tpl');

iw managed to avoid display of 'block-center-filter.tpl' in that range but it shows in every other categories.

What i need is opposite... i would like to dont show except in that range...
how to do that?

Why is this not working?
Code: [Select]
$result = mysql_query("SELECT * FROM contacts WHERE type = 'consumer' AND sent BETWEEN '".date("Y-m-d")."' AND '".date("Y-m-d", strtotime("-7 days"))."'")
or die(mysql_error());
$numrows = mysql_num_rows($result);
if($numrows < 0 ){
echo "No records found";
}

The record that is stored in the sent column is like this "2011-11-03 14:42:12", so there is a record in there, but nothing is showing up.

Can anyone see why?

thanks in advance

So I already have this below...

$state = array (
    1 => 'Sectional',
    2 => 'Regional',
    3 => 'Semi-state',
    4 => 'State'
);

Can those numbers be a range -- 1-16, 17-32, 33-48 and 49-64 -- without just listing them all?

 

 

Okay we are using a javascript, but the javascript that the site comes from has bans all irans ips... and it loads slow for those people, how would I place a if statement saying dont load this javascript if in Iran, thanks... I know how to do it, but I can't find a real set number, and I would use just 1 ip but the guy has dynamic... thanks ahead of time

I have read that i can search for a number within a mysql database using BETWEEN

i.e: SELECT  * FROM `table_name` WHERE `field_name` BETWEEN 99 AND 200

How would i do this with the code below?


<?php
$salary = explode(":", $_GET['salary_to']);
 }
$types[] = (isset($_GET['salary_to']) && strlen(trim($_GET['salary_to'])) > 0) ?
     "`salary_from` LIKE '%". mysql_real_escape_string(trim($salary[0])) ."%' AND `salary_to` LIKE '%". mysql_real_escape_string(trim($salary[1])) ."%'" : ''; 
?>


Thanks for any help