Passing PHP variable in loop to another PHP file via hyperlink

Question

This is essentially a rating system where some text is displayed, users click good/bad, and the database has a vote added or subtracted from it. I am currently trying to do it like this:

File #1 (rate.php) - prints random database row with text in. There is a 'good' hyperlink which goes to good.php and a 'bad' hyperlink which goes to bad.php.

File #2 (good.php or bad.php) - Clicking the links adds or removes a vote to/from the database as appropriate and returns to rate.php via the header function.

I am currently having difficulty passing the variable from the while loop to good.php and bad.php. Because they are hyperlinks, there is no form.

Should I even be using a while loop? Is there a better way to structure the whole thing? Does this call for sessions?

EDIT:

Here is the while loop.

$query = "SELECT * FROM challenges WHERE visible = 1 ORDER BY RAND() LIMIT 0,1";
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
    echo "<div id='box'>";
    echo $row['challenge'];
    echo "</div>";
    echo "<div style='text-align: center; font-size: 12px;'>
<span id='good'><a href='good.php'>good</a></span> &nbsp;
<span id='skip'><a href='rate.php'>skip</a></span> &nbsp;
<span id='bad'><a href='bad.php'>bad</a></span></div>";
}

You should post some code. I haven't the slightest clue about what your while-loop dilemma is. — Waleed Khan
– Waleed Khan, Commented Jul 21, 2012 at 19:25
Please don't use mysql_* functions in new code. They were removed from PHP 7.0.0 in 2015. Instead, use prepared statements via PDO or MySQLi. See Why shouldn't I use mysql_* functions in PHP? for more information. — Madara's Ghost
– Madara's Ghost, Commented Jul 21, 2012 at 19:28

cyborg86pl · Accepted Answer · 2012-07-21 19:29:10Z

0

just pass a row ID with GET variable

good.php?row_id=12345
bad.php?row_id=12345

in good.php and bad.php it becomes a variable like:

$_GET['row_id']

answered Jul 21, 2012 at 19:29

cyborg86pl

2,6173 gold badges28 silver badges43 bronze badges

2

@Sebastian - That's just bad practice.. you should really use POST instead. Make a button named good and one named bad. Wrap them in a form and then in your rate.php page add the code for when the user submits using the good button, and then using the bad button

Tom
– Tom

07/21/2012 19:40:26
Commented Jul 21, 2012 at 19:40
i also recommend to POST this variable, but as long as @Sebastian want to do this via links, it's the easiest way

cyborg86pl
– cyborg86pl

07/21/2012 19:53:52
Commented Jul 21, 2012 at 19:53

Add a comment |

Collectives™ on Stack Overflow

Passing PHP variable in loop to another PHP file via hyperlink

1 Answer 1

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Your Answer

Sign up or log in

Post as a guest

Related