Print table data

Question

I have in the following code:

$sql = mysqli_query($strcon, "SELECT * FROM cadastro");
$exibe = mysqli_fetch_row($sql);
echo "<table>"; 
echo  "<tr><td>Nome:</td>";
echo "<td>".$exibe[1]."</td></tr>";
echo  "<tr><td>Sobrenome:</td>";
echo "<td>".$exibe[2]."</td></tr>"; 

Give me the result:

Nome:   Olivaldo
Sobrenome:  Liveira

Obs.: Data passed via method POST no <form>

I want to bring you all the results, from my table on the screen, Bring in case all ID lines.

Not without where to start searching. Can you help me please?

Answer 1

Put a while to receive all records from the database.

echo "<table>"; 

$sql = mysqli_query($strcon, "SELECT * FROM cadastro");
while($exibe = mysqli_fetch_row($sql)){

   echo  "<tr><td>Nome:</td>";
   echo "<td>".$exibe[1]."</td></tr>";
   echo  "<tr><td>Sobrenome:</td>";
   echo "<td>".$exibe[2]."</td></tr>";

}

echo "</table>";