Change table by topic

Question

Change table by topic

Navigation

#1 by (2 votes)

0

I have the data to show as it is currently.

echo "<table>"; 
echo  "<tr><td>Nome:</td>";
echo "<td>".$exibe["Nome"]."</td></tr>";

echo  "<tr><td>Morada:</td>"; echo "<td>";
if ($exibe['Morada']){ echo $exibe['Morada'];}else{echo 'N/D';} echo "</td></tr>";

echo "<tr><td>Tipo:</td>";echo"<td>";
if($exibe['Tipo']){ echo $exibe['Tipo'];}else{echo 'N/D';} echo "</td></tr>";

echo "<tr><td>Email:</td>"; echo "<td>";
if($exibe['Email']){ echo $exibe['Email'];}else{echo 'N/D';} echo "</td></tr>";

Currently the data is shown all on the same page in table form ie:

 id - 1
 Nome[1] - Jorge
 Morada[1] - Rua do Sol
 Email[1] - [email protected]

 id - 2
 Nome[2] - Pedro
 Morada[2] - Rua da agua
 Email[2] - [email protected]

I want to change this for each id to appear in a different folder or window. Well I will have iumeros Id's and leave everything on the same page is too long

Lighter?

php

asked by anonymous 18.02.2014 / 18:52

1 answer

Log reading to infer counter OCI-22053: overflow error - C #

score 2 · Answer 1

I do not understand, but I'll try. I think he wants to list and associate the results with the ID. Let's try.

<script type="text/javascript">
// função javascript que receberá id e redirecionará para página ver.php passando o id
function go(id) {
    window.location = 'ver.php?id=' + id;
}
<script>

<table>
<tr>
    <td>Id:</td>
    <td>Nome:</td>
    <td>Tipo:</td>
    <td>Morada:</td>
    <td>Email:</td>
</tr>

<?php
// Se você tiver um array com vários sub-arrays com a estrutura do seu $exibe
foreach ($resultados as $exibe)
{
    // Primeiro recebo as variaveis
    $id = $exibe["id"];
    $nome = $exibe["Nome"];

    // Uso do operador ternário para simplificar o if
    $morada = ($exibe['Morada']) ? $exibe['Morada'] : "N/D" ;
    $tipo = ($exibe['Tipo']) ? $exibe['Tipo'] : "N/D" ;
    $email = ($exibe['Email']) ? $exibe['Email'] : "N/D" ;

    // Quando clicar na linha ele vai jogar para a página correspondente
    // O css é só pra deixar com a mãozinha quando por o mouse em cima
    echo  "<tr onclick='go($id);' style='cursor: pointer;'>";
    echo  "<td>$id</td>";
    echo  "<td>$nome</td>";
    echo  "<td>$tipo</td>";
    echo  "<td>$morada</td>";
    echo  "<td>$email</td>";
    echo  "</tr>";
}
?>   
</table>

See more about: Ternary Operator