CODEWITHSUNDEEP
mysqlsql
pblack
pblack

Reputation: 13

PHP/MySQL - Changing Query on clicking a link

I have a very basic site (just learning this stuff) where I have the results for a hockey pool I do from here. I want to build a page that lists the players and then when they click on a name, a page comes up with just that player's picks on it. You can see the kind of page I mean here.

THis page currently only shows one player, as I am using this query:

$q = "SELECT *, player_id, handle 
        FROM round_one 
  INNER JOIN players USING (player_id) 
       WHERE (player_id = 1)";

Right now I have it set just to return player_id 1, but I want it to do player_id 2, 3, 4 etc depending on what linked name they click on.

I have been reviewing some documentation on sort by columns queries when clicking on a column header, and am thinking this is sort of the approach I should be taking, but I just can't seem to figure out the correct way to do it.

Upvotes: 1

Views: 2072

Answers (1)

Dan
Dan

Reputation: 2093

You can achieve this by passing a parameter to the view_picks_by_player.php page, and then PHP can pick up that parameter and generate content for the appropriate player.

For example, in the page where you select the player you want stats for you could have:

<a href='view_picks_by_player?id=player1'>Get Player 1's Stats!</a>
<a href='view_picks_by_player?id=player2'>Get Player 2's Stats!</a>

And then in the top of the view_picks_by_player.php page you could have:

$id = $_GET['id'];

$sql = "SELECT * FROM player_stats WHERE id = '$id'";

Obviously your SQL is structured differently, but this is just a quick way to show how you can pass a variable to the php page so it can generate different content dynamically.

For security, you'll want to validate that the user has not typed anything nasty into the URL as the 'id' before you use it in your SQL, but that's another topic...

Upvotes: 4

Related Questions