Pass data by link - php application

Question

Pass data by link - php application

Navigation

#1 by (0 votes)

1

I am not able to do something, I am a beginner in php and web programming and I am trying to make a page to receive the ID of any user through a click on the link:

  'while($linha = mysqli_fetch_array($result) ) {

                            $id_usuario = $linha['ID_usuario'];
                            $name = $linha['nome'];
                            $Sexo= $linha['sexo']; 

                            echo "<tr> <td><a href='#'>$id_usuario</a></td> <td>$name</td> <td>$Sexo</td> <td>Tipo</td> </tr>"; //falta definir a pagina


                                    }'

It is a simple procedure I believe, on the other page I would like to get the user id and make a Select on all the information of this user registered in the database, but I want to know how I could do this on this other page

php sql-select link

asked by anonymous 13.03.2016 / 13:06

1 answer

The width of my site is not the same, header is smaller than the rest. How to solve? What is the purpose of the super command when used in the parameter declaration of a method?

score 0 · Accepted Answer

First you must pass the id through the link:

 echo "<tr> <td><a href='dados.php?id=".$id_usuario."'>$id_usuario</a></td> <td>$name</td> <td>$Sexo</td> <td>Tipo</td> </tr>";

On the other page you need to query the database by taking id :

<?php
// retirado de codigosnaweb.com - scripts grátis para o seu site

// PODE SER SEPARADO O TRECHO ABAIXO PARA SER CHAMADO POR INCLUDE
define("SERVIDOR", "<endereço do servidor de banco de dados>");
define("USUARIO", ",<usuário>");
define("SENHA", "<senha>");
define("BANCODEDADOS", ",<nome do banco de dados>");
$conecta = new mysqli(SERVIDOR, USUARIO, SENHA, BANCODEDADOS); // CONECTA

if ($conecta->connect_error) {
    trigger_error("ERRO NA CONEXÃO: "  . $conecta->connect_error, E_USER_ERROR);
}
// PODE SER SEPARADO O TRECHO ACIMA PARA SER CHAMADO POR INCLUDE

$sql = "$sql = "SELECT * FROM suatabela WHERE id=".$_GET['id']."";"; // CONSULTA
$query = $conecta->query($sql); // RODA A CONSULTA
$linhas = $query->num_rows;
if($linhas >= 1) { // SE HÁ LINHAS
    while($colunas = $query->fetch_assoc()) {
        echo " {$colunas["texto"]} "; // DADOS DA CONSULTA
    }
    $query->free(); // LIBERANDO OS DADOS DA CONSULTA
} else {
    echo "Não há resultados"; // SEM RESULTADOS
}
$conecta->close(); // FECHANDO A CONEXÃO
?>

Replace your bank information (name, address, username and password) in this code and save it to a "data.php" file.