How to link to table?

Question

I have a Table in PHP and in each tr I need a link

<?php
$con = mysqli_connect("localhost","root","", "saber");
mysqli_set_charset($con,"utf8");
$result = mysqli_query($con,"select id,nome,vista from mensagens");

while($row = mysqli_fetch_array($result)){
    echo "<tr>";
    echo "<td>" . $row['id'] . "</td>";
    echo "<td width = '86%'>" . $row['nome'] . "</td>";
    if($row['vista'] == 1)
        echo "<td>Sim</td>";
    else
        echo "<td>Não</td>";
    echo "</tr>";
}
?>  

Does anyone know how I do?

Answer 1

You can insert the link inside the <td>

while($row = mysqli_fetch_array($result)){
echo "<tr><a href=".$row['link'];
echo "<td>" . $row['id'] . "</td>";
echo "<td width = '86%'>" . $row['nome'] . "</td>";
if($row['vista'] == 1)
    echo "<td>Sim</td>";
else
    echo "<td>Não</td>";
echo "</tr></a>";
}

EDIT:

To make every tr have a link you can use javascript:

while($row = mysqli_fetch_array($result)){
echo "<tr onclick='location.href=.$row['link']."\'";
echo "<td>" . $row['id'] . "</td>";
echo "<td width = '86%'>" . $row['nome'] . "</td>";
if($row['vista'] == 1)
    echo "<td>Sim</td>";
else
    echo "<td>Não</td>";
echo "</tr>";
}

Answer 2

I believe this solves in the case of three:

echo '<tr style="cursor:pointer" onclick="location.href=\''.$link.'\'">';

Answer 3

The link cannot be left out of Td. it has to be inside td. Involving only the text.

echo "<td><a href='".$link."'>" . $row['id'] . "</a></td>";

Answer 4

You’ll have to put a href around the <td>

echo "<a href=\"link\"><td>" . $row['id'] . "</td></a>";