Same page, different content?

Question

All links have the same url but the data is different..

I’m working on a web based project that I have:

• categories of games:
• games(table with games in each category)
• description of each game(are more details)

One of the categories is called FPS.PHP, on this page there are several table games coming from the database with the fields Name, Type and Platform. What I wanted was basically to be able to click on the name of each game and open a page called DESCRIPTION.PHP where would be the details of the game that we clicked. Since there could be lots of games and making a page for each game would be exhausting, I wanted to be able to make a page that would serve as a description page for everyone.

PS: Each category has a table in the mysql database that contains games.

Does anyone know how to do that? FPS.PHP (First)

<?php

$servername = "localhost";
$username = "root";
$password = "Estagiarios2017#";
$dbname = "ricardo";

 // Create connection
 $conn = new mysqli($servername, $username, $password, $dbname);
 // Check connection
 if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
} 

 $sql = "SELECT  name, tipo, plataforma FROM fps";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
echo "<table><tr><th>Name  </th><th>Type  </th><th>Platform  </th></tr>";
// output data of each row
while($row = $result->fetch_assoc()) {
echo "<tr><td><a href='description.php?idfps=".$row['name']."'</a>" . $row["name"]. "</td><td>" . $row["tipo"]. " </td><td>" . $row["plataforma"]. "</td></tr>";



}
echo "</table>";
} else {
echo "0 results";


}
?>

FPS.php EDITED

    <tr>
 <td  valign="top">
<div class="feed_title" ><?php echo $fps["name"]; ?></div>
<div id="fps-<?php echo $fps["idfps"]; ?>">
<input type="hidden" name="rating" id="rating" value="<?php echo $fps["rating"]; ?>" />
<ul onMouseOut="resetRating(<?php echo $fps["idfps"]; ?>);">
  <?php
  for($i=1;$i<=5;$i++) {
  $selected = "";
  if(!empty($fps["rating"]) && $i<=$fps["rating"]) {
    $selected = "selected";
  }
  ?>
  <li class='<?php echo $selected; ?>' onmouseover="highlightStar(this,<?php echo $fps["idfps"]; ?>);" onmouseout="removeHighlight(<?php echo $fps["idfps"]; ?>);" onClick="addRating(this,<?php echo $fps["idfps"]; ?>);">&#9733;</li>  
  <?php }  ?>
<ul>
</div>
<div><?php echo $fps["descricao"]; ?></div>

<?php echo"<a href='description.php?idfps=".$row['name']."'>Ver mais</a>"?>
</td>
</tr>

Answer 1

It’s not the answer to your question, but it’s to help solve the problem with the modeling I told you about:

From what I understand, you only need 2 or 3 tables.

Making with 2:

Table of Categories:

id   |  nome
1    |  FPS
2    |  Corrida
3    |  RPG
4    |  Puzzle

Table of Games:

id   |  nome        | categoria
 1   |  CS          | 1
 2   |  GRID        | 2
 3   |  Battlefield | 1
 4   |  DIRT        | 2

Then when you go to make the pages, have one to see all the games in the category:

viewCategoria.php? id=2

Run select on all games with category 2 (Race)... and list.

viewGame.php? id=2

Run select in Game 2 (GRID) and display its details